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

[Tomy_Tom]

Good Morning!

I delete my all try (6projects) and i start new time AND IT WOOOORK!!!!!!!!!!!

LOT OF THANKS!!!!!!!

THANK YOU THANK YOU THANK YOUUUUUU!!!!!!!!

[Tomy_Tom]

Data send is okay data rad is okay, but if googlesheet value is date txt box value is date + T22:00:00......

what i can do?

[TIMAI2]

See the first post SCRIPT > UPDATE
for an alternative script that gets display values

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