Comment modifier les données avec googlesheets

[TIMAI2]

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

I have lost count of the number of times the community has received requests for help from developers, after following the Hay Kel series of videos on CRUD with google sheets. The videos are well produced, and offer the viewer a good insight to creating the app-sheet-script ensemble required for CRUD activities. However, the script is flawed: a bound to sheet script, with code that only allows the bound spreadsheet and use of the first sheet; hard-coded columns and hard-coded row data for upda…

Spreadsheet component. Example. Google Sheets

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API. How to create the Service Account, here: http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…