56,943 questions
-2
votes
0
answers
20
views
Keep getting "invalid key" error - google apps script to send documents automatically to docusign for signature
[error][1]```
this is the .gs * * REQUIRED SCRIPT PROPERTIES: * - DOCUSIGN_CLIENT_ID (Integration Key) * - DOCUSIGN_IMPERSONATED_USER_ID (API User GUID) * - DOCUSIGN_PRIVATE_KEY ...
1
vote
2
answers
67
views
Comparing multiple flags at once
I have a script which checks the value of a series of flags before deciding on an execution pathway. Because of the way the script executes, the flag values are held as script properties, therefore ...
- 173
Advice
0
votes
4
replies
39
views
Slides Add-On accessing Sheets Data and Narrowing Scopes
I have an Add-On under review in the Google Marketplace.
My Add-On runs in Google Slides and needs to access Google Sheets data to create various visuals in Slides. Specifically my Add-On pulls data ...
- 67
0
votes
1
answer
48
views
Filter in Filter or Query/array for multiple sheets
I'm a long time reader, first time poster.
I'm having a problem showing invoice details for each company id for this sheets.
https://docs.google.com/spreadsheets/d/1iTJ8PR3snsbZKh01-...
2
votes
0
answers
29
views
Google Drive Add-on homepage renders twice when onItemsSelectedTrigger is present and no items are selected
I'm developing a Google Workspace Add-on for Google Drive and have run into a strange rendering bug.
When my add-on is opened in the Drive sidebar, the card generated by my homepageTrigger function is ...
Best practices
0
votes
3
replies
48
views
Handling Multiple Sheet Inputs
I have a spreadsheet that receives data inputs externally. That data is used by sheet formulas to calculate an output which is then collected via an HTTP request.
What is the best way to allow google ...
0
votes
1
answer
66
views
Checkbox behavior
So as per previous suggestions, I'm using checkboxes to replace the .getUi method so my project will work properly on mobile devices. I've come across a strange scenario and I wanted to confirm this ...
- 173
0
votes
0
answers
43
views
Frontend Not Connecting to Google Apps Script Backend in Student Forum Project [closed]
I'm working on a student forum project for my school using HTML/CSS/JavaScript for the frontend and Google Apps Script for the backend. The repo is here: Repository.
The issue I'm facing is that the ...
- 9
2
votes
1
answer
55
views
Stacked column chart to use column A as header in App Script
I have this table and the chart I want as below:
To acheive this I have to switch rows/columns, and use column A as headers.
However I cannot find the corresponding command for the checkbox "Use ...
- 305
-4
votes
0
answers
65
views
Fix for a (Drawing) Button assigned to an Apps Script, ‘Script Function cannot be found’ error only temporally fixes problem. Why? [closed]
(Edited as requsted to show all of the function code.)
Elsewhere on Stackoverflow this problem and fix is detailed. However, the fix only solves the problem for a temporary period – typically a day or ...
1
vote
2
answers
86
views
Checking for changed checkbox value
To get around the fact you can't pop user dialogue windows on mobile devices, I have created a simple function which posts any error messages to a cell and waits for the user to check a checkbox to ...
- 173
1
vote
1
answer
66
views
Filtering a 2D Array
I have a column of checkboxes, which drives some downstream processing if they are checked. At the moment, my code creates the array of checkbox values but only uses it to check if any checkboxes have ...
- 173
0
votes
1
answer
105
views
Looking for a specific word in a Title in a cell then pushing a numerical code to a different cell in Google Sheets
My situation in Google Sheets: I have a list of target words and phrases in column A (as few as 20 to as many as 400), in column B I have 3 and 4 digit number codes assigned to each target word and a ...
- 1
0
votes
0
answers
44
views
Error while opening Dialog inside google chat using appscript
I have a add-on app where i have added multiple commands . In that I have a slash command called /share which should open dialog . so its opening and closing after some time and the error says
Server ...
0
votes
0
answers
31
views
Appscript doPost Logs not showing up [duplicate]
I am using the reserved doPost(e) function to handle my posted CSV file data. When I try to access the data using e.postData.contents and log the contents, nothing is logged. Actually, it is more like ...
