How to get field values based on record ID

1651 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1

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.