Common:UseLOOKUPFunctionToGetRecordID
From AgileApps Support Wiki
Revision as of 23:18, 9 November 2011 by 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 …")
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(...)).)
}}