Dec 06, 2022 02:13 AM
I have a database of people and one of the columns contains links to other records in that "People" database and is meant to showcase which other people this record has a relationship with. I was wondering if there is a way to update two records simultaneusly, so that when I add Person B as a relation to Person A, that relationship is reflected in both records.
Dec 06, 2022 05:36 AM
As far as I am aware, the only way to create a two-way link within the same table is to use automations.
1. Create a new automation
2. Set the trigger to "When a record is updated"
3. Set the table to the table with people in it.
4. Set it to watch only the Relationship field updates.
5. Add an "Update Record" Action"
6. Set the table to the same table as before
7. Set the Record ID to the relationship field
8. Click on the Relationship tag that was added to the Record ID field so that the drop down appears.
9. Click Edit Token.
10. Change the "Choose Data" to ID instead of Name
11. Under the Fields section, add the Relationship Field.
12. Set the Value to "Airtable Record ID"
Turn on the automation and viola!
Here is a link to an example Base where the automation has been set up for you.
Example Base
Hope that helps!
Dec 08, 2022 05:34 AM
Hi! Thanks for the suggestions. Is there anyway for this to work for multiple Record IDs? Often there are multiple records in that "Relationship" filed but the Automation creator doesn't seem to accept that the output of the field of the updated record is a list of record IDs rathar than just the one.,
Oct 27, 2023 12:25 PM
This is amazing! (I have been looking for this solution for so long).
However, what I am finding is that it only adds, not removes. Any thoughts on this on how to get it to remove a connection in both records?