Step 3 - Update Record in Airtable (TAB A) Search by field will be ‘INVOICENUMBER’ and search value will be the ‘INVOICENUMBER’ column from Step 1 (Tick the ‘create Airtable Record if it doesn’t exist yet?’ box if it’s relevant to you) - again, you need to fill the ‘INVOICENUMBER’ record from Step 1 Step 2 - Find or Create record in Airtable (TAB B Info) Step 1 - create record in Airtable (where your Tab A info feeds in) Tab B - you need to look up that column of Record_ID () - called ‘LookUpREC’ - then….Ĭreate a formula column and = the ‘lookupRecID’ column - called ‘LookUpRECString’ Tab A - you need to do a Record_ID () formula - for namesake I’ve called it ‘REC’ Tab A - create a Linked field colum to tab B for the example I’ve called it ‘TAB B LINK’ ‘ INVOICENUMBER’ is in my first column which will be linking tab A to tab B (my unique identifier) I just need some advice as to how I can get Zap to update the Airtable field with multiple values instead of replacing the old values. I want the field to hold multiple entries for the older ones, on the basis of their business name and email. It always replaces the old Requirement links/entries associated with any Client, with the Requirement ID for a new Requirement made by the client. Now the issue is that even thoguh the Requirements column on the clients table is a field that allows linking to multiple data entries, Zap does not update the Requirements column on the clients table with multiple fields. As a result, all the requirements that come through require Zap to be linked from the Requirements table to the Clients table. Since the Client entries are made dynamically, we cannot pre-populate the Client table. Once they put in a Requirement, we use Zap to create a new entry for them in the Client table. The Requirements table receives orders, even from Contacts who are not in our Client list yet. I have an Airtable base with two tables: Requirements and Clients.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |