Issue I’m using the Stackdriver Error Logging REST API with Apps Script. The documentation is at: https://cloud.google.com/error-reporting/reference/rest/v1beta1/projects.events/list The group ID is required in the query parameter string. I need the group ID but I don’t know where to get either
Continue readingTag: google-apps-script
Automatically sort Google Sheet by most recently updated row
Issue I want to have a sheet which automatically sorts the most recently edited row to the top, in order to surface freshly edited results and not let them be buried by outdated entries. Solution Here’s the solution I came
Continue readingHow can I extract data from specific cells on a specific trigger?
Issue I am being asked to make a Google spreadsheet do the following and I have no idea how to make this happen: I work at a car dealership where we track live sales on a shared Google spreadsheet. They
Continue readingConvert column index into corresponding column letter
Issue I need to convert a Google Spreadsheet column index into its corresponding letter value, for example, given a spreadsheet: I need to do this (this function obviously does not exist, it’s an example): getColumnLetterByIndex(4); // this should return “D”
Continue readingGappscript customer menu to trigger copy range to range of another spreadsheet for loop
Issue What I am trying to do is transfer rows depending on the value in column p starting at row number 7. If cell in column P has a value of " Order" then copy that row from column B
Continue readingIf any row in range (G11:G25) contains boolean (true) then run function, else msgBox
Issue The function I’m running (clearRowContents) in sheet ‘Section 2’ will clear contents and validation for any checked item (col H) in a list as well as the checkbox itself (col G). The remaining unchecked boxes and list items will
Continue readingHow to set cell value (range of cells) based on the result of another function?
Issue I have a spreadsheet (Web) with urls in column E and empty cells in column F. Function getTitle takes url from E and returns its Title. But how can i write all Titles to column F near their urls?
Continue readingFill Down values from a 1×6 array into an _x6 array Google App Script for Google Sheet
Issue I’ve got this: array_to_fill_down = [a, b, c, cat, 15, blue] rows = 3 What I want is this: array_output [ {a, b, c, cat, 15, blue}, {a, b, c, cat, 15, blue}, {a, b, c, cat, 15, blue}
Continue readingRange Not Found, Google Apps Script for Google Sheets
Issue I’m trying to build a custom range for this sort function in an Apps Script for Google Sheets but I keep getting the error: "Exception: Range not found; sortProductionLog @ macros.gs:15" I’m sure this is something basic but I
Continue readingTrying to send email from google sheets with apps script, but blank cells give unwanted output
Issue I’m trying to send some values in table to an email, the problem starts when it sends the date, I want it in this format "dd-mm-yy" var fecha = new Date(registro.getRange("c16").getValue()); var fechaF = Utilities.formatDate(fecha, "GMT","DD-MM-YYYY"); The above code
Continue readingGoogle Apps Script to open a URL
Issue Is there a way to write a google apps script so when ran, a second browser window opens to www.google.com (or another site of my choice)? I am trying to come up with a work-around to my previous question
Continue readingHow to make multiple dependent dropdown inputs more efficient?
Issue I managed to make dependent dropdown list using codes from https://codewithcurt.com/create-dependent-drop-down-on-google-web-app/. I need to make multiple entries of the same questions like in the pic here: It works and I get the intended responses. But it seems like the
Continue readingCan I nest an web app in another web app?
Issue At the moment, I need to create an app that will dynamically change it’s sections This is the app layout. The main section would be an independent webapp, because it would keep changing it’s contents. The nav bar it’s
Continue readinggetValues from Google Sheet to html <select>
Issue I’m rather new to Google Scripts and HTML and I’ve managed to put together something from what I could gathered on other posts, but I’ve hit a wall when trying to automatically populate an html dropdown menu from a
Continue readingVis.js JSON data to Google Spreadsheets Range
Issue I have a little issue trying to retrieve the data from the Vis.js (here a example!) nodes position and edges related to the id, to a Google SpreadSheets range. Here’s the code (HTML and GAS) let nodeArray = []
Continue readingPass google script value to html
Issue I have been looking at various other solutions posted here but none of them seem to work for me. I’m trying to pass a variable from my google script (which is originally stored in google’s PropertiesService) to my html,
Continue readingHow to make adjacent col's input field mandatory based on a selection in another column/same row HTML Table?
Issue There’s quite a few examples around, but I couldn’t find one covering a table. The intent is to have the Comments column’s input field shown as mandatory, if value Rejected or Discuss is selected in an adjacent column. Here’s
Continue readingCan't have link in Embedded web app in Google site?
Issue I’m trying to integrate a google script app deployed as a web app in a Google Site. The embedding feature works well and all seems good at first. But for some reason links don’t work in the embedded view.
Continue readingunwrapping all promises from a recursive fetch
Issue I am trying to make a recursive function that returns all the subblocks of a given block. For some background information, I am using the Notion API to get all the blocks from a page. A block can have
Continue readingSending "this" radio button element parameter to function in Google Apps script
Issue I have a custom sidebar generated via Apps Script on a Google Sheet. The custom sidebar html contains a form and fieldset with 5 radio input elements, all with onchange events: google.script.run.viewOptionsFormRadioChange(this); Here’s the full form HTML: <form id="viewOptionsForm">
Continue readingHow to make submission function work in a web form that is created using Google Apps Script and embedded in a Google Site?
Issue I want to embed a web created using Google Apps Script to a Google Site. However, data submission button in the form comes to be defunct, when the form is embedded in a Google Site like this. In the
Continue readingGoogle apps script: include script tag within html list
Issue I have a Google Sheet and a bounded script that automates sending a daily email with a dashboard, based on data from the spreadsheet. Part of this dashboard is a bullet point list ul li in my html. Now,
Continue readingHow do I set a form to send the response somewhere?
Issue I got a google add-on, and I am making an email, with a form, but I don’t know how to send there answer to a server, or if possible, send there answer as a reply to the email, and
Continue readingGoogle Web App google.script.run not working
Issue I have the following .gs: function doGet(e) { return HtmlService.createHtmlOutputFromFile(‘index’) } function goToMaster() { const ss = SpreadsheetApp.getActiveSpreadsheet() const sheet = ss.getSheetByName(‘Master Projects’) sheet.activate() } The goToMaster() function activates a sheet called "Master Projects" When running the function by
Continue readingIn Google Apps Script, How to prevent multiple submission of form data by reloading the HTML returned by doPost()?
Issue I created a web form using Google Apps Script, where form visitors would see result.html after data submission. However, the data may be submitted multiple times if visitors reload the result.html by pressing F5, Ctrl + R, ignoring the
Continue readingHow to apply a CSS file in the Google Apps Script project to an HTML file returned by doPost()?
Issue I created a web form using Google Apps Script, where form visitors would see result.html after data submission. However, an external css file css.html in the same project of this result.html is not included in result.html. I have five
Continue readingHow to display values from google script object in html <p>?
Issue HTML code I want to display object values in this form in <p or easier solutions <div class="control-form-id"> <label for="id">Id:</label> <input type="text" name="id" id="id" required> <button type="button" onclick="JSinHTML();" id="search" >Search</button> </div> <div class="serial"> <label for="serial">Serial number:</label> <p id="serial">result</p> </div>
Continue readingPlay Sound when a specific cell change the Value google sheets
Issue I am trying to run the code of this post, : Google Script: Play Sound when a specific cell change the Value with the recommendation of Rob Blakemore Could someone pass me a sheet that is working with this
Continue readingPOST Request does not show any value in node JS
Issue I’m trying to send a post request to my node js server through google app script, but the received data is {}. I tried sending a Post through zapier and postman, zapier will work if I set the payload
Continue readingGoogle Sheets Sidebar | HTML form, how do you parse the onsubmit formObject?
Issue I’m creating a form in the sidebar to create new sheets based on a wide range of criteria. I’ve got about 27 inputs total. I have one text entry, and several groups of radio’s and checkboxes. I’m stuck at
Continue readingPOST Request does not show any value in node JS
Issue I’m trying to send a post request to my node js server through google app script, but the received data is {}. I tried sending a Post through zapier and postman, zapier will work if I set the payload
Continue readingPlay Sound when a specific cell change the Value google sheets
Issue I am trying to run the code of this post, : Google Script: Play Sound when a specific cell change the Value with the recommendation of Rob Blakemore Could someone pass me a sheet that is working with this
Continue readingGoogle Sheets Sidebar | HTML form, how do you parse the onsubmit formObject?
Issue I’m creating a form in the sidebar to create new sheets based on a wide range of criteria. I’ve got about 27 inputs total. I have one text entry, and several groups of radio’s and checkboxes. I’m stuck at
Continue readingCan't pinpoint error origin using Chrome Developer Tools + Apps Script (Javascript error)
Issue I am trying to debug an error on my code, I am using Apps Script and I know my error is related to JavaScript. To be more exact, here: agendaColaboradores.append(‘<input class="elementoFormularioMovCob" type="time" id="movCobHoraEntradaES’ + colaboradorTrim + ‘" name="movCobHoraEntrada’ +
Continue readingHow to exclude an option that have reached capacity from the form deployed using Google Apps Script
Issue I created a web form using Google Apps Script that has options with capacity. In the following example, there is a question to ask visitors to choose cheesecake or chocolate cake. Suppose that I have only two pieces of
Continue readingHow to iterate through this html table and get data from rows whose last col is not empty?
Issue I’ve been trying to get this data, but the array comes out empty: function saveData() { var tableData = []; var table = document.getElementById("dtable"); console.log(table) for (var i = 0; i < table.length; i++) { let tableCells = table.rows.item(i).cells;
Continue readingHow to populate one of the HTML Table columns with pre-set options using Apps Script?
Issue I am trying to get this table to display the options for each of the table rows, but I can’t quite get it: I suppose I’d set it in the seconf for loop, but I’m new to html and
Continue readingHow to add options to an HTML Table using Apps Script?
Issue I was wondering how I could add these options to an HTML table within Apps Script Editor. Here’s the script: function doGet() { return HtmlService.createTemplateFromFile(‘Index’).evaluate(); } /* PROCESS FORM */ function processForm(formObject) { var result = ""; if (formObject.searchtext)
Continue readingGoogle Web App Script Unknown Parameter Error on Load
Issue On load my web app is producing this error: DataTables warning: table id=data-table – Requested unknown parameter ‘9’ for row 21, column 9. For more information about this error, please see http://datatables.net/tn/4 Code.gs function doGet() { return HtmlService.createTemplateFromFile(‘Index’).evaluate(); }
Continue readingMake the high/low values in step wise from a range in google sheet
Issue Need google app script to make stepwise to an array of numbers taken from a range cell values. Example suppose the taken cell values from A column are as: A1 1 A2 4 A3 2 A4 1 A5 4
Continue readingMake the high/low values in step wise from a range in google sheet
Issue Need google app script to make stepwise to an array of numbers taken from a range cell values. Example suppose the taken cell values from A column are as: A1 1 A2 4 A3 2 A4 1 A5 4
Continue readingPass Google Apps Script (GAS) – Charts Service chart to HTML Template to create within GAS to create Modeless Dialog Box
Issue User: Tanaike kindly answered my question here: Pass Google Apps Script (GAS) – Charts Service chart to HTML Template within GAS However, I realized that I’d like to also edit my template and use a modeless dialog box to
Continue readingAdd an open url handler to a button
Issue I created a button and I have applied to this button a handler to collect the data of some fields and record them in a spreadsheet. I wish, however, at the end of this operation, the script to open
Continue readingAdd an open url handler to a button
Issue I created a button and I have applied to this button a handler to collect the data of some fields and record them in a spreadsheet. I wish, however, at the end of this operation, the script to open
Continue readingAdd an open url handler to a button
Issue I created a button and I have applied to this button a handler to collect the data of some fields and record them in a spreadsheet. I wish, however, at the end of this operation, the script to open
Continue readingHow do I grab URL in Apps Script (.gs) and hand it to a .html script?
Issue This is my first question here and I am pretty new to js and html so please excuse if I’m missing something obvious. Goal: I want to create a script, that creates a Folder in your Google Drive but
Continue readingApps Script google.script.run does not work within a Library-bound html file when triggered by other users
Issue I have an authorization problem, but I can’t figure it out. I have 50+ spreadsheets each for a separate user in our company. Each user spreadsheet has a container-bound script that accesses a standalone library called "Library" where all
Continue readingApps Script google.script.run does not work within a Library-bound html file when triggered by other users
Issue I have an authorization problem, but I can’t figure it out. I have 50+ spreadsheets each for a separate user in our company. Each user spreadsheet has a container-bound script that accesses a standalone library called "Library" where all
Continue readingHow do I grab URL in Apps Script (.gs) and hand it to a .html script?
Issue This is my first question here and I am pretty new to js and html so please excuse if I’m missing something obvious. Goal: I want to create a script, that creates a Folder in your Google Drive but
Continue readingConvert unordered lists (<ul>) into HTML-formatted tables (<table>)
Issue I have previously been asking for a solution that would allow me to convert an unordered list into a formatted HTML table. At that time, a kind user suggested a solution that I have attached below. That solution turns
Continue readingConvert unordered lists (<ul>) into HTML-formatted tables (<table>)
Issue I have previously been asking for a solution that would allow me to convert an unordered list into a formatted HTML table. At that time, a kind user suggested a solution that I have attached below. That solution turns
Continue readingHow can I send an entire array of form responses from HTML/Javascript instead of one at a time?
Issue I am making a map painter programme, that takes in X, Y and colour data from user input and stores in a Google spreadsheet. The data is sent to the spreadsheet as a form, following this solution. In my
Continue readingMultiple bulk import entries using Google Apps Script
Issue I know there are existing codes to build a form that can upload multiple files (bulk import) such as this Uploading Multiple Files to Google Drive with Google App Script, but I was just wondering if it’s possible to
Continue readingPulling Row Data Into a Google Sheets Sidebar then replacing new entered data into original row selected
Issue I am currently trying to modify a already written code to be able to pull in row data of certain columns into the Sidebar then after the user submits it updates the row that was selected. I have been
Continue readingIntegrating Plaid and Google Apps Script
Issue I would like to write a Google Apps Script that can pull transaction data from my bank and add it to a google spreadsheet. I thought Plaid might be a good option, but I am unable to figure out
Continue readingPublish spreadsheet to the web without page break
Issue On the computer when accessing the published spreadsheet, it appears complete, showing all columns. However, when trying to access by cell phone, the page is completely broken and does not give complete visibility of the data. I would like
Continue readingApps Script append values from two functions to the same row
Issue I have two functions in Apps Script, both write values to my Google Sheet. I wanted to have them on the same row. I tried to use sheet.getLastRow().setValues(sheet.appendRow([obj.name, obj.mimeType, obj.id, Utilities.formatDate(new Date(), "GMT+8:00", "yyyy-MM-dd’T’HH:mm:ss’Z’")]) But it didn’t work. Here’s
Continue readingHow can I make user input case insensitive in an HTML Form in Apps Script?
Issue I have made a custom function on Google Sheets that allows the user to see how much they have spent on an expense. Here is the example output: The HTML sidebar: Here is the JavaScript function: function perCentBrand(brand){ var
Continue readingPass data between two HTML pages (Google Apps Script)
Issue I’m trying to pass var ‘id’ from the page ‘a.html’ to ‘b.html’. The var content comes from ‘code.gs’ as below: code.gs function data(){ var id = 1; return id; } Next, I get this var and I show it
Continue readingTranspiled JavaScript code fails when I use decorator with gas-webpack-plugin
Issue EDIT1:I made a minimum reproduction repository here code & reproduction steps are available at the repository. EDIT2: Same error occurs when I embeded the transpiled code on html file. EDIT3: I tracked down the main cause of this problem.
Continue readingMy UserForm doesnt give an Output (GoogleSheets)
Issue i am very new to google sheets and tryed to use an Userform to fill in my Sheets. But every time, i click submit it just freezes and nothing more happends… https://docs.google.com/spreadsheets/d/13LdDIMvWpVkj5rom2fHV25FtYvbOcnKr4cZF84nITYQ/edit?usp=sharing And the code: HTML: <!doctype html> <html
Continue reading