Something wrong in airtable

[Soham_Shah]

yes, just try filling it with any values because we want to test whether blank cells are causing the error or not

[sherif (Sherif Hassan)]

empty row
thaank you very mutch @Soham_Shah
thanks all of u

[themaayur (Mayur Berad)]

It has been told multiple times in different topics that there should not be empty rows, that will create issue.

[Soham_Shah]

So please mark my post as solution

[sherif (Sherif Hassan)]

biggest solution mark

[themaayur (Mayur Berad)]

I have marked you post as solution

Something wrong in airtable

Hi, I can see there are empty cells in your airtable spreadhsheet and try filling the empty cells, as I had the same problem once

[Aditya_Singh]

Also, you must use global switch variable before calling the GetColumn block.

[sherif (Sherif Hassan)]

last thing

@sherif

Can I set the default value of the blank cell to a fixed value, not found, for example?

how can I do that
because if the column has an empty cell it will not load

[themaayur (Mayur Berad)]

Instead of keeping blank set something default like empty.
And when you get the values if it contains empty then don’t show it.

But don’t keep blank cells.

[Soham_Shah]

As i said fill the blank cells with any value let’s say none and if you don’t want to show them in your app then you need to filter the using logic that if value not equal to “none” then only add items to your list

[sherif (Sherif Hassan)]

I want to do this automatically set the value of the empty cell to “not found”
how is it ?
@Soham_Shah

[themaayur (Mayur Berad)]

Nothing can be done automatically @Soham_Shah and I have suggested you the logic to do that.

[sherif (Sherif Hassan)]

how can I set default cells values @Maayur

[themaayur (Mayur Berad)]

Something wrong in airtable

Instead of keeping blank set something default like empty. And when you get the values if it contains empty then don’t show it. But don’t keep blank cells.

Something wrong in airtable

As i said fill the blank cells with any value let’s say none and if you don’t want to show them in your app then you need to filter the using logic that if value not equal to “none” then only add items to your list

[vknow360 (Sunny Gupta)]

@themaayur

Nothing can be done automatically

After reading this mySQL be like:
mySql: Am I a joke to you?
Also he:
No one trusts me

[sherif (Sherif Hassan)]

using filter do that

[Soham_Shah]

yes but that’s basically logic