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 …")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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(...)).)

}}