Simple CRUD with Google Sheets and Apps Script (fixes Hay Kel flaws...)

[Tamer_Muhassil]

So let me say, SQL stay, but I want to make a filtering option to the list.

[Tamer_Muhassil]

By the way, I can't go without saying. "Crudq II" is great

[TIMAI2]

Revival - Italo's Custom Listview Filter Bar - with Clock

With all links to Italo's guide on the above lost from appyBuilder and Thunkable, I thought I would put up a remix of the original blocks, with an aia project example. This uses a clock timer instead of a textbox extension. The only change I have made is to add an extra conditional check: does the last textbox content equal the current textbox content (if so, do nothing), to cut down on unnecessary processing. This also ensures that listview selections above the last one can be made. Clock timer…

[ABG]

@Tamer_Muhassil

but I want to make a filtering option to the list.

https://ai2.appinventor.mit.edu/reference/concepts/pholo.html

[lolo64]

hi
thanks for your job . i am making my recipebook that exactly what I am looking for.
I would like to know if is there a maximum number of letters when you create a new record?

[TIMAI2]

A Google Sheets Cell can accept up to 50,000 characters.

[Ahmad_Gazali]

Hi @TIMAI2 and everyone
I tested your updated CrudII and it's working good.
After that, I add a filter list, but only the second data would appear.

I add these blocks:

Result only the second index:

Sheet, there should be two from Indonesia:

Complete Blocks

Aia file:
CRUDQII_testFilter.aia (14.3 KB)

I once have deleted this "remove list" block

It showed two data but when I clicked the first data it will return the second, I click the second data but it's error cause there's no the third data.

How to add the filter function and solve these problems?
Thanks in advance

[TIMAI2]

I will take a look later today

[TIMAI2]

Should be a simple fix, add back the header row from the original list?

[Ahmad_Gazali]

Thanks a lot. You're so helpful. It's working good now

[TIMAI2]

Might be indexing issues if you try to update an item from your filtered list...

[Ahmad_Gazali]

I hope I can fix it later, if not I'll ask for help