Tag Info

New answers tagged


Change this var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy"); into this var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy").toUpperCase(); ht to Chris


So you want to get a value from your spreadsheet, and use it in your script? I have added a couple of lines at the top of your script, and used startDate to populate the query object: function fetchMAP28() { var range = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Dates").getRange("A3"); var startDate = range.getValue(); // Note the timezone ...


I found a way around it and no script needed. You just need to use another sheet. See the updated sheet mentioned above for the working example. =HYPERLINK(CONCATENATE("http://www.example.com/check-out.html?value1=",roundup('sheet2'!A1),"&value2=",$B30,"&value3",$C30),roundup('sheet2'!A1)) Hope this helps.

Top 50 recent answers are included