Skip to main content

How to get field values based on record ID

  • June 12, 2022
  • 1 reply
  • 61 views
H

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

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • 6009 replies
    • June 12, 2022

    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.


    Terms & ConditionsAccessibility statement