Is it possible to send the google spreadsheet data to another application without using button click event? -
i want send google sheet data application, using trigger onedit. able send data on button click event, want without using button little more automatic. should done on cell edit.i've tried can please help.
var ss = spreadsheetapp.openbyid("@@@@@@@@@@@@@@@@@@@@@@@@@"); function createspreadsheetedittrigger() { scriptapp.newtrigger('celltracker') .forspreadsheet(ss) .onopen() .create(); } function celltracker(){ var cell = ss.getactivecell().getcellvalue(); if((ss.getactivecell().getvalue()) > 0 && (ss.getactivecell().getvalue()) == cell){ var link = app.createanchor('xxxxx',"http://###############/noetic_data/adddatatoaras?data="+cell); } }
instead of calling spreadsheet id, in case attach script spreadsheet opening tools -> script editor -> blank project. open script editor can use onedit trigger code:
function onedit(e){ var myrange = e.range; //get range that's edited var myvalue = myrange.getvalue(); //get value of first cell in range //send data other application }
every time update range (mostly 1 cell) in spreadsheet, trigger wil use event object containing range , it's data.
https://developers.google.com/apps-script/guides/triggers/events
to see what's going on can use logger. example:
logger.log(myvalue);
Comments
Post a Comment