Solved

Conditionally set source view for a lookup control

M

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.

icon

Best answer by PeterDeMeester 8 February 2021, 11:17

View original

6 replies

EuanGamble
Userlevel 5
Badge +13

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

S
Badge +10
Try using this formula
fn-If(fn-GreaterThanOrEqual(amount ,25000),"role1","role2")
P
Badge +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
Userlevel 5
Badge +13

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


 

P
Badge +2
Hi Euan,
Solved it with making views in combination with filters in the form.
Greets,
Peter
EuanGamble
Userlevel 5
Badge +13

Glad to hear you have a solution, @PeterDeMeester.



Cheers,


Euan

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings