2,152 questions
0
votes
0
answers
173
views
Google Chat Apps Script bot deployment connected correctly but not receiving any events
I’m trying to build a simple Google Chat bot using Apps Script.
I’ve followed the official documentation:
Created the Apps Script project with handlers onMessage, onAddToSpace, onRemoveFromSpace.
...
-1
votes
1
answer
56
views
Issues with an email forwared working on Google Sheets
Javascript code that needs to send an email to a specific email from a column list (B). Whenever there is a change between comluns H to M in my Google Sheets.
Expected Result: The code should send a ...
- 1
0
votes
1
answer
76
views
Tether workbook copies to a master copy. Updates to copies filtered according to a key
I have a master and multiple copies of a sheets workbook. I would like to update the master and have the copies update AND filter the update according to a specified name/id value.
I have used the ...
1
vote
2
answers
639
views
Exception: Unexpected error while getting the method or property openById on object DocumentApp while trying to open Google doc file
I am trying to open a doc file and replace a value using the simple snippet:
function openFile(){
var doc = DocumentApp.openById("docId");
var body = doc.getBody();
body.replaceText(&...
- 522
1
vote
1
answer
76
views
Unable to Locate Google Apps Script for Web App Created in Classic Google Sites
We created a Google Web App in 2019 using the classic version of Google Sites. The associated Google Apps Script was accessible via the "Manage Site" menu at sites.google.com. However, since ...
- 11
0
votes
0
answers
135
views
Unity Game in Google Play Console Problem with AndroidManifest.xml, android:exported
I'm trying to put a 2D Game made in unity into the google play store. Never done it before and when I'm trying to upload the app bundle in google play console, I get the error,
You have uploaded an ...
0
votes
0
answers
79
views
duplicated ID shown to the user when the submitted the form at the same time
I'm trying to create a form for my employees to submit their tickets using Google forms.
The user is going to receive the ticket id as a confirmation message, and Google sheets will show the ticket id ...
0
votes
1
answer
131
views
Mix text and list in one shape on a Google Slide using Google Apps Script
I'm using Google Apps Script (SlidesApp) to dynamically generate a Google Slides presentation.
On one of the slides, I need to mix text and a list.
I prefer to keep these both within the same textarea ...
- 11.3k
3
votes
0
answers
332
views
Accessing AWS Access Portal via Google App
I used the following document to use Google as my idP to AWS. I followed the instructions and apart from the final step (Step 7: Google Workspace: Confirm Google Workspace users access to AWS ...
- 1,251
0
votes
2
answers
699
views
How to order placeholder elements in Google Slides for usage in Google Apps Script
EDIT: Final solution has been added as answer but I marked Tanaike's answer as solution as he pointed me towards the right direction.
I'm setting up a Google AppScript to automate a bit of reporting.
...
- 11.3k
0
votes
0
answers
46
views
Run Google App Scripts client side to import image in intranet link in GSheets
I have a local link: image.domain.loc/image01 that contains an image,
There is any way to access this image in GSheet /GAPPS script without a Proxy or a tunnel?
I need an easy way to insert image in ...
- 11
0
votes
0
answers
55
views
Google Sheets Script - Macro not sending network request when activated by checkbox edit listener
My question is, how can I get Macro1 to work as intended (complete the network request(s) and open the model popup with embedded hyperlink) when called from the checkbox onEdit listener?
I've written ...
- 39
1
vote
1
answer
102
views
Google Sheet different cell ranges protection and access levels (all, specific, email-based)
Have this Google Sheet:
SourceSheet (sample data) is available: SourceSheet
Trying to implement protection rules:
The ranges B2:B10 and B13:B21 can be edited by everyone.
Ranges D2:D10 and F2:F10 ...
- 4,383
0
votes
1
answer
112
views
Protecting sheet. Selective editing permissions in Google Sheet
I have a table like this:
SourceSheet (sample data) is available: SourceSheet
I need to protect all cells but certain ranges can be edited by everyone and some ranges can be edited by only users ...
- 4,383
0
votes
1
answer
172
views
Google Apps Script. Transfer data from current active sheet to another by URL (on Edit event)
I am trying to pass data from one Google Sheet:
Data transfered to another sheet by URL: https://docs.google.com/spreadsheets/d/1gFuY2i50Vxdl5kx7iHZAupILAW2u35KYSRzCKKXMWIk/edit#gid=0
Data (specific ...
- 4,383
