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

I am now confused as to what you are doing?

I get this error

Hata

OK, we are back where we started.

Show the entire responseContent:

Have you correctly deployed the apps script ?

Read again

And check that you have correctly deployed your app script:

And again:

Is it too difficult to set the responseContent to a Label, then get the content of the label and post it here ?

Also, have you checked that you have deployed your apps script correctly ?

image

The problem was solved (when I copy it to everyone)
I installed Crudq II, I want to use filtering instead of SQL query. How can I do it?

Explain what it is you want to do. The whole point of using SQL queries is to return the data you want...

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

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

1 Like

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

1 Like

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?

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

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

I will take a look later today