Skip to main content
Nintex Community Menu Bar
Answer

Conditionally set source view for a lookup control

  • June 2, 2019
  • 6 replies
  • 64 views

Hi,

 

Really new to this, I'm trying to set the default view ("source view) in a lookup control based on a condition.

I tried the following :

fn-If(amount >= 250000, "role1", "role2")

But I get the error:

value with name "fn-If(amount >= 250000, "role1", "role2")"  does not exist.

Best answer by PeterDeMeester

Hi Euan,
Solved it with making views in combination with filters in the form.
Greets,
Peter

6 replies

EuanGamble
Nintex Employee
Forum|alt.badge.img+13
  • Nintex Employee
  • June 4, 2019

Hi @mdb74 ,

 

I would be interested to know more about the solution you are trying to build. Could you send me an email to euan.gamble@nintex.com and let me know more about your form?


Thanks,
Euan


Forum|alt.badge.img+10
  • June 11, 2019
Try using this formula
fn-If(fn-GreaterThanOrEqual(amount ,25000),"role1","role2")

Forum|alt.badge.img+2

Hi Euan,
Found a solution for this? I'm having same problem, but can't find the clue.

So I want the lookup to filter on 2 columns, depending on the value of 2 differtent columns.
Many greets,
Thanks,
Peter


EuanGamble
Nintex Employee
Forum|alt.badge.img+13
  • Nintex Employee
  • February 4, 2021

Hi @PeterDeMeester,

 

Our filters only work on a single property, not multiple. However NWC Forms does allow filtering on multiple properties on the Data Lookup control to Office365.

 

Cheers,
Euan

 


Forum|alt.badge.img+2
Hi Euan,
Solved it with making views in combination with filters in the form.
Greets,
Peter

EuanGamble
Nintex Employee
Forum|alt.badge.img+13
  • Nintex Employee
  • February 8, 2021

Glad to hear you have a solution, @PeterDeMeester.


Cheers,

Euan