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

Getting the 1st record by searching field value

Topic Labels: API
284 2
Showing results for 
Search instead for 
Did you mean: 

I have studied the API docs and seen infos on how to retrieve a record, but my need is to get all the infos about a record with a special value in a field - say the 1st found “invoice” with “unpaid” in its status field, so I can act on it on an external system and then update the status to “reminded” for example.
How would that work ?
Thanks !

2 Replies 2

I feel this is the idea, but how can I simply state I am looking for records “WHERE suchfield =thatvalue” to mimic MySQL searches ?
Formula Field Reference - Overview | Airtable Support

In order to prepare the request I found this nice tool in case it helps others : Airtable API Encoder (

Look into the filterByFormula documentation for the REST API. You will need to construct a valid Airtable formula. I recommend testing the formula in an Airtable formula field.