mdb74
Canvas Initiate

Conditionally set source view for a lookup control

Jump to solution

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.

0 Kudos
Reply
6 Replies
EuanGamble
Nintex Employee
Nintex Employee

Re: Conditionally set source view for a lookup control

Jump to solution

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

0 Kudos
Reply
PeterDeMeester
Design Dabbler

Re: Conditionally set source view for a lookup control

Jump to solution

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

0 Kudos
Reply
EuanGamble
Nintex Employee
Nintex Employee

Re: Conditionally set source view for a lookup control

Jump to solution

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

 

0 Kudos
Reply
PeterDeMeester
Design Dabbler

Re: Conditionally set source view for a lookup control

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

View solution in original post

0 Kudos
Reply
EuanGamble
Nintex Employee
Nintex Employee

Re: Conditionally set source view for a lookup control

Jump to solution

Glad to hear you have a solution, @PeterDeMeester.


Cheers,

Euan

0 Kudos
Reply
sojanm
Workflow Veteran

Re: Conditionally set source view for a lookup control

Jump to solution
Try using this formula
fn-If(fn-GreaterThanOrEqual(amount ,25000),"role1","role2")
0 Kudos
Reply