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

[Tamer_Muhassil]

[TIMAI2]

Read again

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

[TIMAI2]

And check that you have correctly deployed your app script:

METRIC RAT AI2 - Correctly Deploy a Google Apps Script Web App for AI2

METRIC RAT AI2 - New Versions for New Google Script Editor

[Tamer_Muhassil]

[TIMAI2]

And again:

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

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 ?

[TIMAI2]

[Tamer_Muhassil]

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?

[TIMAI2]

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

[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