All Questions
55
questions
0
votes
1
answer
34
views
Generating multiple EmbeddedChart in Appscript based on a filter
Based on the sheet here, I want to be able to generate a line graph for every Breakdown in the sheet.
Using the code below, I was able to list and split the rows I want into tuples and create a ...
0
votes
0
answers
34
views
getLastRow() - The coordinates of the range are outside the dimensions of the sheet [duplicate]
I have created a series of Google Sheets documents to manage a small organization's inventory, sales, clients, orders, etc. I've employed a series of AppsScript's scripts to automate certain tasks, ...
0
votes
1
answer
40
views
How to manage archived accounts in Google Workspace?
I am very new to the Google world and trying to get some automation done to see if the below would work in App-script. I am also not a Java guy, so I try my best. We use Okta as our SSO. Once a user ...
0
votes
0
answers
28
views
Why does my script using "onNewEmail(e)" fail? [duplicate]
Here is the script. I get errors like:
TypeError: Cannot read property "message" from undefined. onNewEmail
TypeError: Cannot call method "getFrom" of undefined. at onNewEmail
// ...
0
votes
0
answers
36
views
"Type Not Usable in Add-on Platform" Error When Using CardService in Google Apps Script
I am developing a Google Workspace add-on using Google Apps Script. I am encountering an issue while using CardService to create a UI that displays a list of GitHub repositories. The functionality I ...
19
votes
4
answers
3k
views
Problem loading external scripts like jQuery
I'm facing a problem since this morning with webapps deployed with Apps Script that used to works fine previously. Of course no changes has been made to justify this problem.
External scripts are not ...
0
votes
0
answers
21
views
App Script works in editor but permissions denied when running from sheets [duplicate]
I'm trying to make a script that syncs group membership to whatever emails are in this google sheet. I put the main body of my script in the onEdit function so it runs every time any cell is changed. ...
0
votes
0
answers
90
views
G Apps Script "We're sorry, a server error occurred." when installing a trigger
I'm attempting to install an onFormSubmit trigger to a Google Sheet. When running the setTrigger function below, I receive this error:
Exception: We're sorry, a server error occurred. Please wait a ...
1
vote
0
answers
39
views
How to add selectively create events & add event created / not created to my Google sheet?
I want to create a Google sheet that acts as "Scheduler + Logger" of all my meetings & calls.
To do this, I have a created a Google sheet containing all relevant information - I will ...
0
votes
1
answer
571
views
Appscript : Moving many files quickly on google drive
I want to move a few hundreds of pdf files stored in Google Drive folder to another folder on the same drive. At the moment, I am using moveTo from DriveApp as below
for (var i=0; i<idList.length; ...
0
votes
0
answers
50
views
How do I submit a Google Form (Or add a submission to the form's data) from an external program?
I'm making a website with an organization, and we use Google Sheets for the majority of our backend management because it's what's most accessible for our users. We use Google Forms for submitting ...
0
votes
1
answer
120
views
can't get calendar events from Google sheets to Calendar
I am trying to set calendar events from schedules I have in Google sheets to google calendar to avoid doing it manually.
I developed a code and it is giving me error message
Here is how my sheet looks ...
2
votes
1
answer
1k
views
Create a Google Calendar event with a specified Google Meet ID, conferenceData.conferenceId
I am wondering why the following function creates an event with a random meet ID instead of the conferenceId I specified. The conferenceId can't be programmatically set as I want? I can set the meet ...
0
votes
1
answer
297
views
How to create a sidebar in my Google Workspace add-on for Google Sheets by using the appsscript.json file?
I'm trying to create a sidebar in my Google Sheets app by using the appsscript.json file.
I'm trying to figure out how to use this tool and the JSON file it generates.
Also the documentation here.
I ...
1
vote
1
answer
59
views
How do I search for file while iterating through Folder IDs?
I'm trying to loop through standardized subfolder structures to check if each has a specific file type in it. I conducted small scale testing to ensure I could achieve proper searching of a folder ...