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?

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

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

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:

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...

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.