Airtable can't filter mobile number - [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text

Hello, hope you friendly folk can help :slight_smile:

I’m trying to filter Airtable results on ‘Mobile phone number’ column using a Parsed phone number from Twilio. There should only be one record.

But I am getting this error:

If I’m honest, I have never managed to get Airtable filters to work, so often grab more than I need then filter before the next module! Would really appreciate help understanding these filters if possble.

If useful to know - the ‘field type’ in Airtable for Mobile phone number is ‘Phone number’

Thank you!

Maybe try quotes around the number? i think Airtable treats numbers as strings.

e.g {Mobile phone number} = “variable_name”

2 Likes

Who’d have thought it’d be so simple. Thank you!

2 Likes