56,886 questions
0
votes
2
answers
105
views
Automatic Static Date Stamp
I'm trying to add an automatic static timestamp in this ticketing process:
Sheet A column B is labeled "Data Received". The user manually inputs the date when they receive a ticket.
When ...
- 3
Advice
0
votes
1
replies
72
views
Apps Script limits for a personal account
It's important for me to understand if I pay for the starter plan, whether I'll get an increased Apps Script limit, like enterprise accounts.
Либо нужен другой, более дорогой тариф. Не могу найти ...
1
vote
1
answer
96
views
429 Error on Google Sheets script pulling from Google Books API
I've created a Google Sheet where I enter a book ISBN in cell A2 and want the book title returned in cell B2 upon the click of a button that I've associated with function getBookData(). However, my ...
- 13
0
votes
1
answer
99
views
Google Sheets doesn't catch the user email via event [duplicate]
The task is: several users edit Google Sheets table. All of them have Editor's role. Some of the users are masterusers - they can edit everything. Some are clients - they can edit only empty time-...
- 356
0
votes
1
answer
92
views
Timed Email Notifications for multiple tabs, specific emails, based on dates in spreadsheet
I have a task manager spreadsheet for my company's project managers. Each person has their own tab that they add in their projects, due dates, etc. They get email notifications sent when an upcoming ...
0
votes
1
answer
180
views
Error in fetching pdf file from a website using google apps script UrlFetchApp
I have a Google Apps Script that downloads a daily PDF rate sheet from a public financial website. This script ran perfectly for months but suddenly stopped working around April 9th.
Instead of ...
- 113
Best practices
0
votes
7
replies
117
views
Static URL for Google Apps script?
Although each project has a name, Google Apps scripts use an automatically generated URL to make them available via the internet. This URL changes with each iteration of the code. Meanwhile a schedule ...
- 48.4k
0
votes
1
answer
120
views
Exception: API call to sheets.spreadsheets.batchUpdate failed with error: Empty response
I would like to know if there is someone intimately familiar with the Google sheets API who knows precisely what this error means:
Exception: API call to sheets.spreadsheets.batchUpdate failed with ...
- 359
0
votes
1
answer
86
views
Removing/resetting cell background color to null or white conditionally
My function will run without error and it will log the new cell color of white, or null (whatever one I test with), but it will not reset the cell background color of any cells in the range if any of ...
- 707
0
votes
1
answer
115
views
Adding Multiple Guests to Google Calendar Event via Apps Script and Google Calendar API
I'm inserting or updating events from a Google sheet with the guests' names in one column and their email addresses in another column. For events with multiple guests, the emails and names are ...
Advice
0
votes
1
replies
87
views
Is there anyway to extract live data from listed products (ei 1oz gold bar) for apps script?
The goal of this is to query Walmart, filter by product “metadata”, grab top 5 results, average price) is doable in principle. I created the trigger to execute every 8 hours., but the key issue is ...
- 1
Tooling
0
votes
4
replies
77
views
Can Google Docs be converted to Apps Script with full formatting preserved?
I am looking for a method to programmatically reproduce a Google Docs document using Google Apps Script, including all formatting such as headings, fonts, spacing, tables, and other layout elements, ...
1
vote
2
answers
133
views
Technical Issue: Pie Chart Slice "Distance from Center" and "Color" not updating via Apps Script
I am seeking help regarding a consistent technical issue with Pie Charts in Google Sheets when using Apps Script.
The Problem: When I try to programmatically update a Pie Chart, some visual elements ...
- 13
Tooling
0
votes
4
replies
156
views
Google Drive Folder File Counting Script
I need a reliable Google Sheets script that counts files in multiple Google Drive folders.
Requirements:
Handle all types of links or folder IDs in column E (plain URLs, rich-text links, or raw IDs).
...
Advice
0
votes
1
replies
47
views
Retain value of a cell
I have created a google form linked to a google sheet which captures users' request for a limited resource
It may be that the request fails because there were no resources left
However, the form also ...
