google-apps-script Questions
4
I've been trying to work with Trello and the Google Apps Script this week. I am trying to create an array of hashes that I can then use to load the spreadsheet. Google apps script doesn't like the ...
Lepp asked 29/9, 2012 at 7:19
8
Solved
jQuery.param() takes an array of key-value pairs, and turns it into a string you can use as a query string in HTML requests. For example,
a = {
userid:1,
gender:male
}
would get converted to
us...
Tore asked 10/8, 2014 at 2:9
1
I am new to Google Addon development. I have been working to develop a Gmail addon using the Google Apps script.
My current requirement is to retrieve some information from a website which is auth...
Bolt asked 27/6, 2019 at 10:47
1
I'm using VS Code in combination with clasp to develop in Google Apps Script.
Using scriptlets inside a <script> or <style> tag is messing with VS Codes syntax highlighting:
Also I ...
Lawanda asked 21/5, 2019 at 12:40
7
Solved
I want to use a Google Form to populate a Google Spreadsheet. One of the fields is email address, and I need to validate this against the list of emails for our organisation - in other words forcin...
Quetzal asked 18/5, 2012 at 9:36
1
In Python I use as headers the "Request Headers" that are in the request captured using the browser's developer options and it works fine.
I tried the same with Apps Script, but UrlFetchA...
Georgeanngeorgeanna asked 28/9, 2022 at 15:11
8
My function includes adding a menu and toast to the document. I have verified that the trigger (onOpen) is set as well. It only works when a user goes into Tools, Script Manager, Run. We have too m...
Diba asked 12/11, 2012 at 2:20
2
I have a Google Sheet and I want to have its data updated from our server. Currently I'm using google sheet script editor. google sheet->tools->script editor https://developers.google.com/app...
Decrypt asked 20/6, 2018 at 7:21
7
Solved
I have a WooCommerce store, which is connected with Zapier to a Google spreadsheet. In this file, I keep track of the sales etc. Some of these columns contain -obviously- prices, such as price ex V...
Pembrook asked 17/3, 2018 at 8:59
3
Solved
In a Google sheet, I have a custom form based off of some posts/blogs that I have found online to learn more about Google App Scripts. The form works correctly but I am having trouble with the colu...
Willy asked 19/7, 2017 at 23:53
4
Solved
In a Google Sheets spreadsheet, I want to show a modal dialog created from HTML, then run a function, then close that HTML prompt automatically.
The dialog should stay until the function finishes ...
Allelomorph asked 20/3, 2016 at 17:36
2
Solved
=ARRAYFORMULA(IF(ROW(B:B)=1, "Share Price", IF(ISBLANK(B:B), "", googlefinance(B:B, "price"))))
I am trying to make row 1 (my header row) have a name, and then below that, if a valid ticker symbo...
Cassy asked 26/3, 2020 at 19:6
6
I wonder is it possible now to change theme in script editor from white to dark background. If not how to make Google make it.
Parks asked 31/10, 2013 at 1:54
7
Solved
I am adding a unique ID to each submission of the form. Right now, I made that ID the first field, and pre-filled it with the ID, along with a help text asking the user not to modify this field. Is...
Jerboa asked 3/12, 2013 at 4:5
5
Is there a programmatic way to control hide/unhide Gridlines or protected ranges in Google spreadsheet? There is an option in the menu - View > Gridlines or Protected Ranges to do this. But I want ...
Percale asked 6/11, 2012 at 12:9
10
Solved
Back in 2012, I had some Google Apps Script code for a poker game:
function addplayerstoArray(numplayers) {
var playerArray = [];
for (i=0; i<numplayers; i++) {
playerArray.push(i);
}
} ...
Sterile asked 11/9, 2012 at 20:45
3
Solved
I have had some experience writing container-bound scripts, but am totally new to web apps.
How do I debug (e.g. look at variable values, step through code etc) a web app? In a container bound scr...
Poulard asked 15/7, 2012 at 16:32
6
Solved
Here is a sample code
GmailApp.sendEmail("[email protected]", "mail subject", "mail body");
after the call I can see a sent message in my gmail account and that has a ID like this 147f7e77a...
Koren asked 21/8, 2014 at 9:54
1
I have a google script that I'm using in google spreadsheet to export some data from there. Recently they update the spreadsheet and I'm getting this error:
UiApp has been deprecated. Please use...
Sheritasherj asked 9/2, 2019 at 9:43
10
Solved
I encountered the weirdest error while trying to delete rows that match a specific value using Google Apps Script.
Here is my Code:
function myFunction() {
var doc = SpreadsheetApp.getActiveSpread...
Nunley asked 20/6, 2016 at 14:16
2
I'm using the current Apps script function to add a new post to my WordPress site:
var um_url = 'http://test.mywebsite.com/wp/wp-json/wp/v2/posts';
var um_headers = {
"Accept" : "application/j...
Tonkin asked 5/7, 2016 at 21:59
2
Solved
I'm getting an error response from the API that I'm using, but Google scripts seems to truncate the message. How can I see the full message in Google scripts?
This is the message:
Request failed ...
Acidify asked 19/8, 2016 at 10:5
3
Solved
I need to copy and paste Formulas only in a spreadsheet using Google Apps Script
var range = activeSheet.getRange(targetRow-1, 1, 1, activeSheet.getLastColumn());
range.copyTo(activeSheet.getRange...
Insanity asked 23/5, 2017 at 9:24
1
Solved
I want to have the randbetween function only return a random number until a specific day, then stop changing. Is there a way to accomplish this in googlesheets?
=IF(today()<F1,randbetween(1,10),...
Gamez asked 19/8, 2022 at 17:3
6
Solved
I'm trying to find the best script in terms of runtime to complete a task. I've got a decently large spreadsheet where I need to check values in certain known columns, and depending on a match case...
Bridge asked 28/8, 2013 at 7:49
© 2022 - 2024 — McMap. All rights reserved.