google apps script - How to get the date of the form submitter or the document in a published add-on -

-

in google apps script add-on simply send, try capture timestamp. timestamp (using e.response.gettimestamp().tostring();) formatted est, timezone (the timezone of master script file).

what have either timezone of person submitting form, or timezone of form document add-on installed on.

if has cool trick information appreciated.

if assume user running add-on in same timezone form, getting user's time zone should sufficient.

the calendarapp has gettimezone() method return time zone of user's primary calendar.

template.timezone = calendarapp.gettimezone();

below quick forms add-on demo display time zone in dialog. time zone returned string, name of time zone listed joda.org. format used google apps script triggerbuilders, example:

 // schedule trigger execute @ noon every day in us/pacific time zone  scriptapp.newtrigger("myfunction")    .timebased()    .athour(12)    .everydays(1)    .intimezone("america/los_angeles")    .create();

screenshot

code.gs

/**  * @onlycurrentdoc  limits script accessing current form.  */  var dialog_title = 'timezone probe';  /**  * adds custom menu items show sidebar , dialog.  *  * @param {object} e event parameter simple onopen trigger.  */ function onopen(e) {   formapp.getui()       .createaddonmenu()       .additem('show dialog', 'showdialog')       .addtoui(); }  /**  * runs when add-on installed; calls onopen() ensure menu creation ,  * other initializion work done immediately.  *  * @param {object} e event parameter simple oninstall trigger.  */ function oninstall(e) {   onopen(e); }   /**  * opens dialog. dialog structure described in dialog.html  * project file.  */ function showdialog() {   var template = htmlservice.createtemplatefromfile('dialog');   template.timezone = calendarapp.gettimezone();   var ui = template       .evaluate()       .setwidth(350)       .setheight(180)       .setsandboxmode(htmlservice.sandboxmode.iframe);   formapp.getui().showmodaldialog(ui, dialog_title); }

dialog.html

<!doctype html> <html>   <head>     <base target="_top">   </head>   <body>     <div>       timezone is: <?!= timezone ?>     </div>   </body> </html>

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more