Help

Removing one record from a multiple linked record field

Topic Labels: Automations
Solved
Jump to Solution
217 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello everyone,

I have:

  • a webhook sending a user RecordID.
  • a linked record field containing multiple users

How can I remove just that one user from the linked record field?
So far I’ve managed to add a single user, or to replace them all with one user…

I would appreciate some help!
Thank you

1 Solution

Accepted Solutions

Thank you, I ended up finding a solution where I “rebuilt” the array by:

  1. adding a find record step where I find all those who are linked but not the one I want to remove.
  2. replacing the existing linked records with that new array.

Thank you for your help :slightly_smiling_face:

See Solution in Thread

4 Replies 4

Hey Joachim, I think the only way to do that would be to get the existing array of record IDs, remove the one you don’t want, and then update the record with the modified array I’m afraid

Welcome back to the Airtable community!

Are the linked records in a different table?
Can you remove the user from the backlink field in the [Users] table? If there is a one-to-many relationship (versus a many-to-many relationship) this is usually the easier way.

If you have a many-to-many relationship, I recommend scripting. It is possible to have a non-scripting process that involves formula fields and multiple reads on the records. However, the non-scripting method would require splitting the logic up across multiple fields and possibly multiple automations, making the system harder to maintain.

Thank you but this is what I was not able to do.

Thank you, I ended up finding a solution where I “rebuilt” the array by:

  1. adding a find record step where I find all those who are linked but not the one I want to remove.
  2. replacing the existing linked records with that new array.

Thank you for your help :slightly_smiling_face: