App Inventor, App Script, Google Sheet update

[YP Ng]

Hi,

I made the below program using combination of App Inventor, App Script and Google Sheets. But seem like it is update the next column. I want to make it update the same column. Means cell C2 and D2 for qty and price. How could I achieve this?

[TimAI2]

That would be the "sheet.appendRow()" in the google apps script !

You have several choices, but it does sound like you want a full database on your google sheet (CRUD - Create, Read, Update, Delete)

If you want to keep things simple, is it possible to store the "half completed" entry on the user's phone, using tinydb, then upload when all the information is available?

If not have a look here:

https://puravidaapps.com/spreadsheet.php

or search forum / google for other methods