Help

How to get a record without recordID?

Solved
Jump to Solution
564 1
cancel
Showing results for 
Search instead for 
Did you mean: 
akshay_o_p
4 - Data Explorer
4 - Data Explorer

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.
Screenshot 2021-11-06 165244
need to access records based on the SerialNumber.

thanks in advance

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

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.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

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.