Hi,
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 !
Getting the 1st record by searching field value
+4+4I 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 (codepen.io)
+29Look 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.