Here is a similar topic
I don't think I need Automation, but it seems that pretty much everyone uses it.
https://community.airtable.com/t5/base-design/field-to-show-source-of-linked-field/td-p/158124
This situation is a bit different from the one that Sho linked to. In that other thread, it made sense to use same table links because everything in the table was the same type—everything was an organization. Thus, I recommended my same-table-back links script.
However, in this case, your table is holding two types of things that are not the same: suppliers and brands. In this case, I think you should split the data into two tables, one for suppliers and another for brands. Once you have two tables, you will get links and back links that work automatically. You will also be able to set preferences to say that suppliers can be linked to multiple brands, but each brand should have only one supplier.
This situation is a bit different from the one that Sho linked to. In that other thread, it made sense to use same table links because everything in the table was the same type—everything was an organization. Thus, I recommended my same-table-back links script.
However, in this case, your table is holding two types of things that are not the same: suppliers and brands. In this case, I think you should split the data into two tables, one for suppliers and another for brands. Once you have two tables, you will get links and back links that work automatically. You will also be able to set preferences to say that suppliers can be linked to multiple brands, but each brand should have only one supplier.
Hm, I consider suppliers and brands to both be instances of "organisations" that are held by the table "organisations", however they are of different types of organisations. Splitting that data into two tables has both advantages and disadvantages. I think with the new List-View it might be possible to get around some of the disadvantages.
Airtable has backlinks now!
- Create a new “Link to another record” field (if you want to do this to an existing field, you’ll have to copy the contents of that field into this new one)
- (You’ll get a “Add lookup fields?” popup. That’s not used for this, so you can hit Skip)
- Another hidden “Link to another record” will be automatically generated with the name “From field: nNew field name]”. This field is your backlink field
Let’s say you have records Parent, Child1, and Child2. If you link Parent to Child1 and Child2 via your new field, then those two records will automatically populate Parent in their backlink cell
(Interestingly, it works the other way around. If you “backlink” Child3 to Parent via the backlink field, Parent will automatically be linked to Child3.)