How to get field values based on record ID

[Henrik_Harju]

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?

[kuovonne]

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.