Skip to main content

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.

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

Try using this formula
fn-If(fn-GreaterThanOrEqual(amount ,25000),"role1","role2")

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

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



 

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

Glad to hear you have a solution, @PeterDeMeester.




Cheers,



Euan

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings