Help

Creating unique description for unique linked record

Solved
Jump to Solution
987 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Mohammed_Ali
4 - Data Explorer
4 - Data Explorer

Hi!

Hoping if anyone can give me a few pointers, I wanted to create a unique description to a record when linked with another record in another table. The field in the original table is allowed to link multiple records.

So… In Table1 it is a link record to Table2. When the user links a record in Table1 to one of the fields in Table2, I want them to populate some description thats unique to the Table1/Table2 connection. Asking the support I have been told this is not possible, but potentially I could script this somehow, but not sure how to do this?

Not looking for the specific script but if anyone can give me an idea as to how to do it, would be very helpful!

Thanks

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Yes, this is possible, but you would need to set this up as a many-to-many relationship, which would require 3 tables instead of 2 tables.

Your unique descriptions would take place in the 3rd table. Each record in the 3rd table would represent the unique intersection between precisely one record in table #1 + precisely one record in table #2.

Here is Airtable’s guide on many-to-many relationships:

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

Yes, this is possible, but you would need to set this up as a many-to-many relationship, which would require 3 tables instead of 2 tables.

Your unique descriptions would take place in the 3rd table. Each record in the 3rd table would represent the unique intersection between precisely one record in table #1 + precisely one record in table #2.

Here is Airtable’s guide on many-to-many relationships: