is there any way to access a single record via airtable API without using recordID?
tried SEARCH() filterbyformula but not working since it is a number field.
need to access records based on the SerialNumber.
thanks in advance
Solved
How to get a record without recordID?
Best answer by kuovonne
Welcome to the Airtable community!
When using filterByFormula you need a valid formula. SEARCH expects a text string, not a number. Test your formula in a formula field in the Airtable user interface before putting it in filterByFormula. You should be able to use a simple filter like {SerialNumber}=5 to get the record where the SerialNumber is 5.
+27Welcome to the Airtable community!
When using filterByFormula you need a valid formula. SEARCH expects a text string, not a number. Test your formula in a formula field in the Airtable user interface before putting it in filterByFormula. You should be able to use a simple filter like {SerialNumber}=5 to get the record where the SerialNumber is 5.
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.