Skip to main content
Nintex Community Menu Bar

Lookup Function with Variable

  • March 23, 2018
  • 1 reply
  • 9 views
D

Hey to all -

 

has anyone found a way how to use a variable in the lookup function ?

For example I have a calculated field in my form where I added a formula:

lookup("Condition Factors","ID",cboProducts,***Variable***)

 

When I enter my variable directly - it works but I want it be flexible, variable will be based on a value of another calculated field.

Any ideas anyone?

 

Kind regards, Dimitri

    F

    1 reply

    S

    You can use if function

    If(CalculatedValue=="test",lookup("Condition Factors","ID",cboProducts,Variable1),If(CalculatedValue=="test1", lookup("Condition Factors","ID",cboProducts,Variable2),""))

     

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement