Skip to main content
Nintex Community Menu Bar

Lookup Function (Formula)

  • October 20, 2020
  • 2 replies
  • 25 views

venkatch
Forum|alt.badge.img+2

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.

 

2 replies

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • October 21, 2020
Hi,

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

venkatch
Forum|alt.badge.img+2
  • Author
  • Novice
  • October 21, 2020

Hi Simon,

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

That solved my issue.