![]() ‘ContactMap_ID’ is unique.Ī contact can be associated with multiple locations, and a location can be associated with multiple contacts. Table B has ContactMap records: Table B has ContactMap records. Table A has location records: Table A has location records. You can find the existing linked record IDs by searching for that existing record using a ‘Find Record’ step in Zapier. When you update a linked record field, you have to also include the existing linked record IDs along with the new one you want to add, separated by a comma. ![]() This solution will work for both many-to-many AND one-to-many relationship tables: In my case, I have two tables with a many-to-many relationship, so Mitch’s solution didn’t work (or I misunderstood it). But Table A records will only be linked to ONE record from Table B. In Mitch’s example, he was able to look up the corresponding record from Table B and perform an ‘Update Record’ function in Table A to add in the linked record ID from Table B. As this only works if your linked tables have a one-to-many relationship. I tried the solution that but it didn’t work for me. I ran into this problem too where Zapier would override the existing linked records in a field and replace them with the single linked record value from the update function. Mitch, if you have a chance, could you please explain this a little further? If you could snap a quick screenshot or two, that would be especially appreciated! Happy to explain any of the steps further if you need more help & hope that makes sense… It doesn’t quite make sense to me how this is the only work around (that i have found) but it’s been working for me ever since :) Sounds a bit complicated but the process is actually very easy once you know how to do it. You can hide the ‘LookUpREC’ and ‘LookUpRECString’ columns now as they will effectively be working in the background of your zap. It will then add the ‘INVOICENUMBER’ in to the linked column of Tab A. When new information enters Tab A, it will now find Tab B, see if the ‘INVOICENUMBER’ exists, if it doesn’t it will create a record in Tab B. In the ‘TAB B LINK’ selection, use the ‘INVOICENUMBER’ selection from Step 1. In the ‘Record’ selection, use the ID from Step 2. 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 |