I am wanting to create a new item using external data through zapier, which I am able to do on most data types/column types. One point of data is a unique identifier, using this identifier I would like for it to show related data that is in a linked table (also I can do). The issue is that I cannot directly input this unique identifier to a linked table column.
Example: Zapier pushed data is 852. 852 is also in a linked table along with 852’s phone number and email address. I want 852 from zapier to automatically show the related data.
I cannot reliably bring that info over from the source.