Help

Update Record Ovewrites

Topic Labels: Automations
2714 6
cancel
Showing results for 
Search instead for 
Did you mean: 
cshenoy86
7 - App Architect
7 - App Architect

I am using the Update Record action type in airtable automation. However what I notice is that it completely replaces the existing data in that cell and overwrites it with new data. Is there a way to update the record by appending new data to the already existing data without overwriting? 

The field that I am updating is a linked record and would already have some ids existing. I just want the update record to append new ids to the existing list.

cshenoy
6 Replies 6
AirBenderMarcus
7 - App Architect
7 - App Architect

Hey @cshenoy86 ,

For some reason I wasn't able to do this in a single step but luckily the solution is still pretty simple.

You'll need 2 Update Record actions:

On the first, input the existing field data and the data you want to add separated by a comma.

AirBenderMarcus_0-1703796048852.png

Then create another Update Record action and insert the value from that same field in the first Update Record action:

AirBenderMarcus_1-1703796150049.png

Then the new values should be appended instead of overwritten.

AirBenderMarcus_2-1703796226022.png

 

I tried using this but this is what happens
Say there are already 2 records Test 1 and Test 2 and the two updates need to append Test 3 and Test 4. What happens is Test 1 is retained and Test 2 is replaced by Test 3 and Test 4 even though already existing as a linked record gets added as a new record with an altogether different name.
My automation flow is like this

cshenoy86_0-1703847978332.png

Here is my first update

cshenoy86_1-1703848015646.png

 

Here is my second Update

cshenoy86_2-1703848036912.png

 

Somehow in the second update, I am not able to retrieve the ids of the linked records. How is that possible?

cshenoy86_3-1703848112714.png

 

cshenoy

Hi,
if you want to link to more records, act from other side. Update these records by linking them to the initial record. Loop using repeating group.

cshenoy86
7 - App Architect
7 - App Architect

Thanks for this. However since it is a many to many relationship between the two fields, the issue persists. So even from the other side when linking there are chances of having an existing value already there. As of now I have used script to mitigate this issue which takes all the existing values and then appends new values to it.

cshenoy

Well, I can't suggest about your automation because without screenshot it's not clear what are you trying to do.
I just want to say that ID of record to update supposed to be a single value, not a list of IDs. With list it can work, but I think it consider only the first ID. For multiple update, repeating group should be used. But if you were able to apply the script, it's a most flexible and reliable way in your case.

cshenoy86
7 - App Architect
7 - App Architect

I found out about the repeating group for multiple groups and I think that can work, Basically this is what I was saying when I said the linked relationship is many to many. 

cshenoy86_0-1704378548157.pngcshenoy86_1-1704378588914.png

The linked relationship is between columns from two tables. And both columns can have multiple values. So that was creating an issue.But now with repeating group it might work.

cshenoy