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

[Tamer_Muhassil]

No, when I say "Read All Data"

[Tamer_Muhassil]

This happened when I created a new record.

[TIMAI2]

@TIMAI2

There is no list from csv table block in my blocks, have you added one somewhere ?

Can you answer this ?

[Tamer_Muhassil]

I did not use "List from CSV Table".
Where should I use in my blocks?

[TIMAI2]

@Tamer_Muhassil

this time the error message has changed.
Error Post >>
" [Cannot parse text argument to “list from csv table” as a CSV-formatted table]"

You indicated this as an error - how is this error shown ?

[Tamer_Muhassil]

[Tamer_Muhassil]

[TIMAI2]

I am now confused as to what you are doing?

[Tamer_Muhassil]

I get this error

[Tamer_Muhassil]

@Tamer_Muhassil

"The operation remove list item cannot accept the arguments: , ["<!doctype"], [1]"

[TIMAI2]

OK, we are back where we started.

Show the entire responseContent:

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…

Have you correctly deployed the apps script ?

[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.