All Questions
55 questions
1
vote
0
answers
54
views
TypeError: dataTable.addRows is undefined in Charts.newDataTable() [closed]
I'm encountering a very strange issue in Google Apps Script and I'm hoping someone can shed some light on it. I'm getting a TypeError: dataTable.addRows is not a function when trying to build a ...
1
vote
2
answers
139
views
App script expression to calculate the number of days between two dates
I am trying to find the number of days between the current date and file creation date. The idea is to delete the files that are not more than 4 days from current date.
I used the below app script but ...
- 13
0
votes
1
answer
114
views
Adding values of cells
Bonjour,
i need to do basic operations on values in cells. For that i have developed a script but the values are added as in a string meaning that if a cell has the value 2 and the other one 3 it ...
0
votes
1
answer
35
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 ...
- 317
0
votes
0
answers
37
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, ...
- 1
0
votes
1
answer
112
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
29
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
// ...
19
votes
4
answers
4k
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 ...
- 917
0
votes
0
answers
121
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
1
vote
0
answers
40
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
652
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; ...
- 9,572
0
votes
0
answers
111
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
139
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
2k
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 ...
- 53
0
votes
1
answer
328
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 ...
- 16.2k