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