How to get field values based on record ID

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.