I am having frustrations with Airtable linked fields.
I have an airtable base with links between the primary field in one table repeated as a secondary field in other tables…
I have been able to get a single linked record to appear using a make scenario but haven’t had any luck updating/creating a record with several primary field records. The above have been entered manually.
I have a Plant/facility Info table which has all the information about each plant/facility. This links to an Invoices table. For each invoice I may have mutiple plants/sites covered by that invoice.
I can get the raw data from a Pipedrive deal in text format “Site 1, Site 2, Site 3” - I then need to search in airtable for the records to get the record ID for each Site. I think I have this ok.
But how do I get the record Ids all into a single field into another table and get airtable to recognise these? What is the correct syntax in Airtable’s “Update a Record” Module?
Thanks in advance guys!