parseLookup

Use the parseLookup function to return the ID or Text value of a List lookup control.

Function format

parseLookup(Lookup value, Boolean return text)

• Lookup value: the value from a list lookup control.
• return text (optional): specify whether to return the ID or Text value of a Lookup value. True returns the Text value. False returns the ID. If you do not specify the optional parameter, the function returns the text value.

parseLookup example 1

In the following example formula, the Form.List lookup Text value is Australia.

parseLookup(Form.List lookup, true)

This formula returns the text value, Australia.

parseLookup example 2

In the following example formula, the Form.List lookup ID Text value is 10.

parseLookup(Form.List lookup, false)

This formula returns the ID, 10.

parseLookup example 3

In the following example formula, the Form.List lookup Text value is Australia.

parseLookup(Form.List lookup)

This formula returns the text value, Australia.