In a table where the field is a “LINKED to record” field.
Many times the value for the LINKED field is a value in another text or formula field.
A script that can take the value of a string field, and insert that value to the LINKED To field so that the lookup is somewhat automatic. Currently the only way to do this is to manually do a copy/paste from one field to the LINKED Field.
I believe what would need to be done is -
- Copy the table field from to a variable
- Do a lookup in the LINKED Table
- Insert the valid lookup into the LINKED TO Field
- If there is an invalid look - then don’t display anything
Phone # Link to Contacts via Phone Name Lookup
111-111-1111 111-111-1111 Abe Lincoln (This is the desired result)
Phone # Name
111-111-1111 Abe Lincoln