Scripting - filter by "Link to another record" fie...

[Cinematic_Pictu]

Is it possible to create a formula something like this:

IF({Fulfillment Company}=“Thomson Shore”, {Thomson Shore Ref}={Shipping First & Last Name})

So Field A is being used as a formula field if Field B (multiple option) says X (an option) then Field C (link to another record) will pull information from Field D (normal text field).

[Phil_Lauer1]

I’d like to be able to do something similar, change the contents of a text field based on data in another field. Any luck accomplishing this?

[Cinematic_Pictu]

Unfortunately not - would love to hear a response from Airtable.

[Elias_Gomez_Sai]

It is not enough with Formula and Lookup fields? Could you explain or leave an example?

[Andy_Lin1]

To expand on @Elias_Gomez_Sainz’s response:
If you have your data structured like so:

• Table: Companies
  • Field: Company Name
  • Field: Contact Name
• Table: Invoices
  • Field: Fulfillment Company
  • Field: Shipping First & Last Name

You can look up the data you need by linking {Fulfillment Company} to “Companies”, and setting {Shipping First & Last Name} to a lookup field ( {Fulfillment Company} > {Contact Name}).

This is the related official help page:

Airtable Guide

Linking Between Tables - Airtable Guide

With Airtable, you can create relationships between individual records.  Building on our Martian example, we can connect our Mars supplies with the vendors that manufactured them.  This will display the name of the vendor in-line and make it easy to...

[Cinematic_Pictu]

The lookup fields work well for some things. Here’s a more detailed (and clearer) example:

Column A.1 - Sheet 1 - Formula Field
Column B.1 - Sheet 1 - Multiple Option Field
Column C.1 - Sheet 1 - Link Field to Sheet 2
Column D.1 - Sheet 1 - Link Field to Sheet 3
Column E.2 - Sheet 2 - Text Field
Column F.3 - Sheet 3 - Text Field

If Column B.1 is “Value 1”, then Column A.1 would populate information from Column E.2
BUT
If Column B.1 is “Value 2”, then Column A.1 would populate information from Column F.3
AND
It’s still editable for custom values

So the information would all be in one column, instead of having a formula per column.