If list is empty after trying to get Column from Airtables - Global var is set to *empty-string*, I want it to be 0

[Choofa]

Hi.

My Table with Columns in Airtable might often be with 0 rows. When app runs Get Column and don’t get any data my Global var get’s *Empty-String* and not 0(as in empty). Since I get *Empty-String* the list is not empty I can not use block is list empty.

The error I get is this when I try to change text in textbox with my blocks:

I know there are many posts with this error, but I could not find ANY posts with solution to set list to 0 instead of *Empty-String*, therefor I make a new topic

[Earn_Money_online (AiaStore)]

Are u trying search function then use this method

Custom Search Bar with Simple & Dynamic Listview | Guide

So Welcome, Everyone today in this guide I will show how to Implement a search bar in your app with Simple & Dynamic Listview. So Let’s Begin 1. Search Bar with simple List • Design Design The Search Bar According to Your Need Make two Arrangement [image] In search Arrangement there will be a textbox for input. Other things you can manage according to your need OR check my aia. • Blocks Variables List from which user will search [image] Textbox to temporarily save input [image] The…

Or
Watch this

How to create search option in your app in kodular, thunkable etc

[Still-learning (1-2-3-4...)]

If any one cell is empty then , i hope, app will not get any value from airtable…

In such case you can try with if then else block, may be work for you

[Choofa]

@Earn_Money_online

then use this method

That does not answer my question. I’ve read that topic, but it doesn’t say anything about if database has empty column, then…

@Earn_Money_online

Or
Watch this

I will have a look at this video when I come home

@Still-learning

i hope, app will not get any value from airtable…

The Column it search for value in has no value, so the app should set () in global var. But instead it set Global var to (*Empty-String*).

@Still-learning

In such case you can try with if then else block

Please look at my given blocks, as you can see I’m already using if, then, else…

[Still-learning (1-2-3-4...)]

Yeah noted, the reason is the same. Also you may not set that global variable initi to create empty list instead you may put empty string …

So you use the block contains text empty string block instead of is the list is empty…

[Choofa]

Ah, that might work, I will have a try when I get home

[Choofa]

@Still-learning

So you use the block contains text empty string block instead of is the list is empty

Don’t get it to work. Tried with different blocks and tried to put blocks into eachother to see if anything happens, but I get same error.

Here are some of my Do It results:

I’m empty of ideas of how I can solve this

[dora_paz (Dora)]

If list is empty doesn’t return empty string. Set global variables to create empty lists

Or

[Still-learning (1-2-3-4...)]

@Still-learning

Also you may not set that global variable initi to create empty list instead you may put empty string

Did you check this first??

[Choofa]

@Still-learning

Did you check this first??

I might have misunderstood your suggestion as I believed that was what I did if you see my first picture on latest reply with pictures of what I tried​ I removed Create empty list with a text block, I thought that was your suggestion, but I might have misunderstood as said

[Choofa]

But the blocks you have set up in first picture is same as mine if you see main post images, ain’t it? I just dont check it when I get column, but I don’t see why that should matter

I will try the 2nd image if that could work

[dora_paz (Dora)]

Now I noticed on text box change block, are you making a custom search bar ? If this is the case then you could try something like this

[Choofa]

That could work also, but I did as previous example you came with. It worked

I did like this: