venkatch
Forms Fledgling

Lookup Function (Formula)

Jump to solution

Hi,

In my Nintex Form, when the requester selects the Country, based on the selection a text field has to get show if it is LatAM or NAM, The country is list of United States (Includes Canada) and Latin American Countries.

I have used the syntax as lookup(Country,Title,Country,Region) i am very much aware that this is incorrect.

The Country List has the Country Names in the Title Column and the Region with LatAM and NAM values.

I am using a Calculated Value.

Kindly assist me on this.

Thank you in advance.

 
0 Kudos
Reply
2 Replies
SimonMuntz
Nintex Employee
Nintex Employee

Re: Lookup Function (Formula)

Jump to solution
Hi,

Looks almost right.
lookup(list title, column to filter on, value to filter on, output column)
so
lookup("Country","Title",NameOfTheCountryControlNoQuotes,"Region")

View solution in original post

Reply
venkatch
Forms Fledgling

Re: Lookup Function (Formula)

Jump to solution

Hi Simon,

Thank you, i know i was mucking in the Syntax.

That solved my issue.

0 Kudos
Reply