So if I do a formula like this in AirTable:
phone=‘+61 432 777 028’
it can figure out the + and even the space - but it gets more complicated when trying to filter by formula through API… now I’m sure i’m missing something but here is the proof… in video form!
Tldr: spaces are not working in AirTable filter formula through API
Minor issue but just thought I’d point it out
hey, on the first example you can see the First named field shows up - it’s only when I add the space… but I can try %20 I should have tried that first… it’s interesting + works for you along with %20… that’s why I added a video lol… I appreciate the quick responses! In either case I removed spaces manually so I wouldn’t have to search for spaces and it wouldn’t be required - just thought it was interesting to point out… curious is all
“First” is not shown in your video.
Also, you are choosing 2 completely different records in your video.You didn’t just change one record to spaces vs. no spaces, which would have been the correct test to perform.
What you did is that you chose a completely different record that might not have anything for “First”. Like I mentioned above, if your 2nd record doesn’t have a value for “First”, then you’re going to get an empty response from the API because you told it to only show you “First”. So, like I mentioned above, I would remove that part from your API call and see if it works.
If that still doesn’t work after that, then like I mentioned above, I would try it in Postman and see what happens.
I would also try using double quotes instead of single quotes to see if that makes a difference.