56,999 questions
0
votes
0
answers
14
views
Google Script Trigger no longer activating properly
I have the following script:
function resetDailyCheckboxes() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
sheet.getRange('C2:C8').setValue(false);
sheet....
0
votes
1
answer
21
views
Create a 2 row table combining data from 4 rows
I'm trying to build a stock management sheet for my bar, all items have up to 3 serving options, for each serving option I'd like to add price and volume, but they would report to the same master item ...
0
votes
1
answer
72
views
Why I can't write in a google sheet cell with Apps script? [duplicate]
I created a new spreadsheet, from the extensions tab I selected Apps script and I created a new function.
The spreadsheet looks like this:
A2 is a checkbox, D1 has a custom function:
function ...
- 105
0
votes
2
answers
75
views
Google Doc add ons with multiple sidebars. Now a sidebar only displays if the doc is refreshed
There is nothing unusual about the code I used for displaying sidebars. Here is one example (the others are all the same as this):
function displayFormatTableSidebar()
{
var ui = HtmlService....
3
votes
2
answers
64
views
Use a Macro to add a value from one cell to another cell
I am trying to take a value from a cell (B21, which is the sum of B11:B20) and add that value to the existing value in cell B4. Below is what I am currently at to no avail. Has anyone used macros in ...
- 31
0
votes
1
answer
38
views
Use onOpen function on two sheets in the same Google workbook [closed]
I currently have the below onOpen function that runs when it opens the Google sheet. It goes to the active cell to one row past the current date. I want to use this same macro on sheet1 and sheet2. ...
-4
votes
1
answer
165
views
Make fixed map in modified Minesweeper clone [closed]
I'm trying to repurpose Minesweeper to be used as an obscured map in a puzzle I'm making. I've had the most success in a Google Sheets clone I found that was built with Google Apps Script. I've done ...
Advice
0
votes
1
replies
30
views
Performing OTA on ESP32 via Google Sheets
I've got an ESP32 devkit 1 board connected to the wifi, reading data from a google sheet cell 1:1 every 10 minutes.
This gives a crude form of remote control, allowing to send data to the device ...
- 123
1
vote
0
answers
95
views
Google Apps Scripts "Folding Code" how does it work? [closed]
I just recently found out that you can fold code in the Google Apps Script Editor window. However, I'm wondering if anybody knows how it works.
On the images I've posted some "functions" ...
- 19
-1
votes
0
answers
85
views
return in the same Googlesite when using Google script webapp to process a form [duplicate]
I have a HTML form embedded in my Google site.
A google script webapp is used to process the form.
What I want - and what I don't manage to get working -
is that the user gets redirected to a special ...
3
votes
0
answers
67
views
Appscipt mislabeling microsoft mails
I wrote an appscript with condition :
any mail, which has not starred/important and readout label as ArchivedBird.
function labelReadUnimportant() {
const LABEL = 'ArchivedBird';
const label = ...
- 85
0
votes
1
answer
53
views
Why does Google Apps Script return unspecified error when authenticating tester of Docs formatter?
I have a simple script for iterating over files in a directory in my Google Drive and applying regexes to Google Docs. Recently I have been prompted to revise permissions on execute, and when I select ...
- 1
0
votes
1
answer
64
views
Using Apps Script to forward emails - can I make them show in Inbox?
When I get a certain type of email, I need it auto-forwarded to a certain address with a specific cover message. So I wrote a script that scans that inbox and uses the "forward" method to ...
- 1
-1
votes
0
answers
70
views
Apps Script Bug - Can't copy script into folder, or write a script to create a script [duplicate]
I am creating a Drive backup system in Apps Script, and all goes well.
Except, when I try to copy files of type "application/vnd.google-apps.script" into a specific folder using something ...
1
vote
0
answers
38
views
Adding a confirmation mesage broke my script [duplicate]
It is true - this is the same problem as referenced above - a Google Sheets issue with SpreadsheetApp.getUi();
I have a script on a Google Sheet which clears out old data
function ...
- 23