Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to find a record without ID to add data to its other columns

Topic Labels: API
194 1
Showing results for 
Search instead for 
Did you mean: 

Hey there AT community!

im currently working on some AT connectors for are company shop floor using tulip and was wondering if there is a way with airtable api to find a record using i.e. a serial number instead of the record ID to point to it to add data to its other columns. I have read that in this case what your using to lookup has to be in a text format field in AT but currently serials are generated using a formula field for us.

1 Reply 1

Hi @Marc_Swanson,
If using the API to query records, you can use filterbyformula: How to Sort, Filter, or Retrieve Ordered Records in the API | Airtable Support