How to Add Collaborators Without Overwriting Existing Ones in Airtable Automations

When you use an Airtable automation to update a collaborator field, the update action replaces whatever is in the field with the new value. If the field already has three people tagged, updating it to add a fourth person removes the first three.

This is the standard behaviour for all field updates in Airtable automations. However, you do not need a script to work around this. The Update record action lets you combine field values. You can pass in both the existing collaborators and the new one at the same time, and Airtable writes them all back together.

Set Up Your Base

You already have a main collaborator field called "Collaborators" that holds all the current assignees.

You will need a second collaborator field. Call it "New Collaborator". This is where you place the person you want to add. You can populate this manually or have another automation fill it in.

You can also add a checkbox field called "Run Automation". This will serve as the trigger. When checked, the automation runs.

Build the Automation

In the Automations panel, choose a trigger. "When record matches conditions" works well here. Set it to fire when the checkbox is checked. Alternatively, trigger it when the "New Collaborator" field is updated. Use whichever fits your workflow.

Then add an Update record action and set the Record ID to the record from the trigger.

In the Collaborators field, use the plus icon to combine both values. First insert the existing value from the Collaborators field, then add the value from the New Collaborator field. Airtable writes both back together, keeping everyone already in the field and adding the new person. If the new person is already listed, Airtable automatically prevents the duplicate.

As a final step, add a second Update record action. Clear the New Collaborator field and uncheck the checkbox. This keeps your table clean and prevents accidental re-triggers.

Once everything is set up, test the automation. Add a new collaborator, check the box, and confirm that the main field now includes the new person alongside the existing ones.

Why This Pattern Matters

The append pattern is important for any multi-select-style field in automations, not just collaborators. Airtable's multi-select fields have the same problem: updating them replaces the entire value rather than adding to it.

For multi-select fields, the same approach applies. See how to append a tag to a multi-select field in Airtable without overwriting for the equivalent steps.