I am trying to get data from airtable table named leads using phone number which i have got from another table. Here is the error I am getting
Airtable Error { error:'INVALID FILTER BY FORMULA',
message:'The formula for filtering records is invalid : Invalid Formula. Please check your formula text'
statusCode:422 }
my field type from which I am trying to get data is a phonenumber field and here is my code.
function CollectRecordsFromLeads(recordID,phoneNumber){
console.log(phoneNumber);
base("Leads").select({
filterByFormula: `OR( New Number (Whatsapp)='${phoneNumber}')`, //New Number is the field name
}).eachPage(function page(records, fetchNextPage) {
records.forEach(function(record) {
});
fetchNextPage();
}, function done(err) {
if (err) {
console.error(err);
return;
}
console.log(LeadRecordSet);
});
I am new to Airtable api so any help could be great.