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

[Olagoke_Holo]

Thanks for the offers (sheet csv, aia block & others), I tried yours now and everything work perfect. Thanks so much, you just cure my headache.

[david_dominguez]

good morning
I have followed all the indicated steps and it gives me the following error when I run from MIT App Inventor in test mode

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

I think the error refers to this point

Can you help me please

thanks in advanced

[Kevinkun]

[david_dominguez]

[TIMAI2]

Your problem is upstream with the google apps script. Check the script is correct, ensure you have deployed/re-deployed the latest version.

We would need to see the full content of responseContent to be able to advise further on what the error is.

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…

[Kevinkun]

Sorry for ask you to decode the response Content.
The Content is obviously not a json.

[nivarz]

You are the best, thanks you very much, from DR...!!!!

[Tamer_Muhassil]

You made a great application, I wish I could run it.
Error Post >>
"The operation remove list item cannot accept the arguments: , ["<!doctype"], [1]"

[Tamer_Muhassil]

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

[TIMAI2]

Assuming you haven't changed the script, show your relevant blocks

[Tamer_Muhassil]

All of the blocks are the same, I did not change.

[TIMAI2]

You do not show your blocks for deleting a record?

[Tamer_Muhassil]

[TIMAI2]

Does the error arise after you select "Yes" in the notifier ?

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

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