hello, I have spent many hours to find a solution
having a googlesheet named vitals and has 3 columns
| abed | aname | temperature |
|---|---|---|
| 1 | name1 | 35.5 |
| 2 | name2 | 36.8 |
| 3 | name3 | 37.2 |
| 4 | name4 | 35.8 |
in AppsScript I saved a function
function myfunction(rx,cx,vx) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var cell = sheet.getRange(rx,cx);
cell.setValue(vx);
}
myfunction(3,3,'hello word')
and it works
how to insert 'hello_word' to cell 2,2 with appinventor?
THIS METHODOLOGY DOES NOT WORK FOR ME
is anybody to help Button1 to work (step by step please) ?
The concept of the application is to upload from AI2 values to temperature column for each person listed in the googlesheet under the aname column....
See here, to understand how you create a google apps script web app:
HOWTO: Create a Google Apps Script Web App bound to a Spreadsheet
then here:
Google Sheet CRUDQ II
or here:
Google Sheets for AppInventor
for methods to update a cell
Try a few things, and if you get stuck come back and ask.
Send and receive parameters.
var sheet = SpreadsheetApp.openById(e.parameter.ID).getSheetByName(e.parameter.SH);
var func = e.parameter.func;
if (func == 'myFunction') {
rx = e.parameter.rx;
cx = e.parameter.cx;
vx = e.parameter.vx;
sheet.getRange(rx,cx).setValue(vx);
return ContentService.createTextOutput("Agregado.");
}
could you publish the script for doPost and doGet functions please?
When I run from the addressbar the whole joined text
https://script.google.com/macros/s/......./exec
?ID=</d/........../edit> &SH=VITALS
&func=myfunction1
&rx=3&cx=4&vx="good morning" it works but never from my appinventor program !
This looks wrong, should just be the ID of the spreadsheet ?
h ttps://script.google.com/macros/s/AKfycbxaNmD0h..............Mayrub/exec
function doGet(e) {
var sheet = SpreadsheetApp.openById(e.parameter.Identificador_Hoja).getSheetByName(e.parameter.Nombre_Hoja);
var func = e.parameter.func;
if (func == 'myFunction') {
rx = e.parameter.rx;
cx = e.parameter.cx;
vx = e.parameter.vx;
sheet.getRange(rx,cx).setValue(vx);
return ContentService.createTextOutput("Agregado.");
}
}
/////////////////////////////////////////////////////////
function doPost(e) {
var sheet = SpreadsheetApp.openById(e.parameter.Identificador_Hoja).getSheetByName(e.parameter.Nombre_Hoja);
var func = e.parameter.func;
if (func == 'myFunction') {
rx = e.parameter.rx;
cx = e.parameter.cx;
vx = e.parameter.vx;
sheet.getRange(rx,cx).setValue(vx);
return ContentService.createTextOutput("Agregado.");
}
}