Skip to main content

I’m wondering how I should get values from fields based on record IDs?


I have a table called customers with a record created by record_id() formula. How can I get the value of say an email address or billing address if I know the records ID in a different table?


Or am I thinking about this wrong somehow?

Welcome to the Airtable community!


How do you want to retrieve the data? I am assuming that the record ID is exposed in the target table as a formula field.



  • a human looking at the user interface? Do a search on the record ID field.

  • a script running within the base? Do a selectRecordId() query with the record id.

  • an external service that interacts with the base via the REST API? Use filterByFormula to identify the record in question.


Reply