AgileApps Support Wiki Pre Release

Difference between revisions of "Common:UseLOOKUPFunctionToGetRecordID"

From AgileApps Support Wiki
imported>Aeric
(Created page with "{{Note|<br>You can use the LOOKUP function to return the <tt>record_id</tt> field for a record that matches specified criteria. (For the User object, the LOOKUP function …")
 
imported>Aeric
 
Line 1: Line 1:
{{Note|<br>You can use the [[LOOKUP function]] to return the <tt>record_id</tt> field for a record that matches specified criteria. (For the User object, the [[LOOKUP function]] returns a text string--which is what you need, in this context. For all other objects, it returns a number. To convert that numeric value to a string, wrap the LOOKUP function in a TEXT function: <tt>TEXT(LOOKUP(...))</tt>.)}}
{{Note|<br>You can use the [[LOOKUP function]] to return the <tt>record_id</tt> field for a record that matches specified criteria. (For the User object, the [[LOOKUP function]] returns a text string--which is what you need, in this context. For all other objects, it returns a number. To convert that numeric value to a string, wrap the LOOKUP function in a TEXT function: <tt>TEXT(LOOKUP(...))</tt>.)}}
}}

Latest revision as of 23:18, 9 November 2011

Notepad.png

Note:
You can use the LOOKUP function to return the record_id field for a record that matches specified criteria. (For the User object, the LOOKUP function returns a text string--which is what you need, in this context. For all other objects, it returns a number. To convert that numeric value to a string, wrap the LOOKUP function in a TEXT function: TEXT(LOOKUP(...)).)