Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to get field values based on record ID

565 1
Showing results for 
Search instead for 
Did you mean: 

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.