Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
May 28, 2022 03:32 AM
Hello everyone,
I have:
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
Solved! Go to Solution.
Jun 02, 2022 12:05 AM
Thank you, I ended up finding a solution where I “rebuilt” the array by:
Thank you for your help :slightly_smiling_face:
May 28, 2022 11:52 PM
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
May 29, 2022 11:13 AM
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.
Jun 02, 2022 12:03 AM
Thank you but this is what I was not able to do.
Jun 02, 2022 12:05 AM
Thank you, I ended up finding a solution where I “rebuilt” the array by:
Thank you for your help :slightly_smiling_face: