I already solved it
I wanted to solve the problem of empty values in phone number field.
I had already used ifempty (value; “”) and ifempty (value; emptystring) and nothing helps.
ifempty (value; emptyarray) is the solution !
I already solved it
I wanted to solve the problem of empty values in phone number field.
I had already used ifempty (value; “”) and ifempty (value; emptystring) and nothing helps.
ifempty (value; emptyarray) is the solution !
You can post your answer below, so you can mark it as solved
I have a similar problem, can you share your answer please?
Heya @ib
I just wanted to say great work figuring this one on your own!
Thank you very much for stepping back into this thread and for sharing your final setup with the rest of us. This could be super helpful to many others searching for the same information.
Hey, I do have a similar problem, and thanks to your solution I’m getting there it seems, but cannot find a way to solve it:
leaving it empty, using emptystring
(cause in my case that’s expected), or emptyarray
does not work and I still get the BundleValidationError: Missing value
Here’s what I noticed: If the cell in Airtable is empty, it won’t give me n item with nothing in it, but won’t return the item at all(!). It least it seems to me, that I need to handle that, but how?!
Update: Going through all pink constant variables, nbsp is working. But I would like to understand why others do not work like emptystring …