Send datepicker to google sheets specific cells

MIT App Inventor Help
2

One method is to use a google apps script bound to the spreadsheet, then to post the data required to the script, which will then apply the data to the selected sheet, and return the value and content.

APPS SCRIPT

//for testing with AI2
function doPost(e) { 
  var ss = SpreadsheetApp.getActive();
  var sh = ss.getSheetByName(e.parameter.sheet); 
  var id = e.parameter.id ;
  var cell = e.parameter.range;
  sh.getRange(cell).setValue(id);
  return ContentService.createTextOutput(JSON.stringify({"VALUE":id,"CELL":cell}));
}

BLOCKS

blocks
blocks690×570 59.1 KB

SCREEN

image
image375×458 18.5 KB

SHEET

image
image407×302 13.9 KB

(Google Sheets kindly recognises the string as a date!)

When ever you edit or change the google apps script, remember:

1 Open the script project
2 Go to Publish
3 Deploy as Web App
4 Project version: - select New from the dropdown
5 Execute the app as: your google account address (email)
6 Who has access to the app: Anyone, even anonymous
7 Press the Update button

You have to do this EVERY TIME you change your script

1 Like