I have a function for a web app that makes copies of templates, as parameters it receives the name of the template and the id of the template. CODE.gs function generate_(idTemplate, name) { var template = DriveApp.getFileById(idTemplate); var folder =…
Current result has this: [ ['Cycling','Chess'], ['Cycling','Pilates'], ['Cycling','Elevate'], ['Cycling','Kundalini'], ['Cycling','Scrabble'], ['Cycling','Crossword'], ['Cycling','Darning'], ['Running','Ashtanga'], ['Running','Poker'], ['Running','Sudoku'], ['Running','Sewing'], ['Running','Jump'], ['Boxing','Mushin'], ['Boxing','Tai'], ['Boxing','Tae'], ['Boxing','1000'], ['Boxing','Transient'], ['Boxing','Walking'], ['Strength','Flow'], ['Strength','Tantric'], ['Strength','Quigong'], ['Strength','Active'] ] Split the array so that only the following remains: ['Chess'], ['Pilates'], ['Elevate'],…
I'm working on a project where I shall send data from my app to a google spreadsheet in 2 sheets through app script. I set up a paraphrase to secure the connection. Hkey I have a lot of data to…
I want to create a survey using Google Froms, but only limited people who have the codes can submit the form and do the survey. I have already created a list of codes inside a Google Sheet. When I try…
I'm trying to display google sheet as a web app but returned a bad value error when trying to run it. Here is the code I used: function doGet() { return HtmlService.createTemplateFromFile('Index').evaluate(); } function getData(){ var spreadSheetId = " ";…
I need to get information that is in a cell (F3), and insert it into a JS variable. I know that to send variables from JS to AppScript it is through google.run.nomedafuncao() However, in this case, the meaning would be…
I'm having fun at work and building a sheet with a bunch of little scripts (read: I'm a debutant that know a little bit appscript and html code). I succeeded to make a script to make a prompt box appear…
This sample data entry web app works as expected and appends new data to the spreadsheet using the id. With minimal changes, how can the script from the HTML file be placed into a different file while keeping the same…
I have the following json structure returned by an API: { "data": { "artemis_ids": {}, "symbols": { "0XBTC": { "price": 2.37 } } } } When I use JSON.parse in Google apps script, the "0XBTC" string is somehow converted to…
I need to retrieve some data from a Google Spreadsheet via App Script for which I set up a DoGet function. Currently I´m retrieving an array but a I need data comes as JSON key-value pairs format. The table on…