Referencing Other Table in Primary Field

[AlliAlosa]

Is it possible to reference another table in a primary field formula? I would love to be able to automatically add/remove records based on a checkbox value in a separate table.

We are using Airtable to keep track of email accounts and distribution lists for our company. A distribution list can be associated with singular email accounts as well as other distribution lists. For this reason we have two tables - “Email” and “Dist Lists”. “Email” lists all accounts including distribution lists which are distinguished with a checkbox, and a separate table, “Dist Lists” links back to “Email”. The problem is any time I create a distribution list I have to add the record to both “Email” and “Dist Lists”.

Any help would be greatly appreciated! Thank you!

[Elias_Gomez_Sai]

As you can see, you can’t do that. You can instead create a Linked Record field, and then select de Primary Field as a Formula, to play with the linked record.

[Trang_Le]

I know this topic is a long time ago, but what formula would I enter into the Primary Field? I’m still learning to use forumulars in Airtable so I appreciate any help.

[Elias_Gomez_Sai]

The Formula depends on the desired results and available Fields. Check the docs:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

[Trang_Le]

Oh yes, I finally worked it out. Thanks anyway.

[Amber]

Looking to do the same thing. Any chance you could share your Formula for this? :slightly_smiling_face:

[Kamille_Parks]

If you just want to display the name of the linked record, the formula would be just be the name of the linked record field wrapped in brackets. If you want to prepend or append anything to it the formula would be like 'Text to appear before'&{Name of field}&'text to appear after'

[Claire_Conza]

in your primary key field, change field type to formula, then click the name of the field you wish to use as your primary field. In my case below, I’ve used my SKU field which is a rollup field…

I then hide the field I’ve referenced (SKU)…