Assigned
Status Update
Comments
ko...@gmail.com <ko...@gmail.com> #2
Kk, got a more contained example of the issue using a very small add-on.
source:
https://script.google.com/d/1o3AvP1zRrx7WnDEx_fV_IhS2fc3QstuKHvFaBsqjcffqxdhLNjC7j62S/edit?usp=sharing
add-on listing:
https://chrome.google.com/webstore/detail/dcpikpbagjcipkfmacefilfbkdjlfjmd
Because I've made the add-on "unlisted" there are slightly different reproduction steps:
* Steps 1-4 are the same as in my original post
5. In the Incognito window that you're testing this in, open the following link
https://chrome.google.com/webstore/detail/auth-issue-tester/dcpikpbagjcipkfmacefilfbkdjlfjmd?authuser=1
The "authouser=1" query parameter is very important in the above link as otherwise the add-on will be installed for the "default" account and the issue won't express.
6. Click the "+ Free" button on the above linked page to install the add-on
7. In the new Sheet you will be brought to after clicking "+ Free", wait a few seconds for prompt to appear. Click "continue" and then authorize the add-on
8. Open the Dev console
9. Go to "Add-Ons" => "Auth Issue Tester" => "Open Sidebar"
10. Note the error printed to the console and inserted into the sidebar
Demo of the above listed steps 5-10:https://cl.ly/0p0v080F2j1s
source:
add-on listing:
Because I've made the add-on "unlisted" there are slightly different reproduction steps:
* Steps 1-4 are the same as in my original post
5. In the Incognito window that you're testing this in, open the following link
The "authouser=1" query parameter is very important in the above link as otherwise the add-on will be installed for the "default" account and the issue won't express.
6. Click the "+ Free" button on the above linked page to install the add-on
7. In the new Sheet you will be brought to after clicking "+ Free", wait a few seconds for prompt to appear. Click "continue" and then authorize the add-on
8. Open the Dev console
9. Go to "Add-Ons" => "Auth Issue Tester" => "Open Sidebar"
10. Note the error printed to the console and inserted into the sidebar
Demo of the above listed steps 5-10:
re...@gmail.com <re...@gmail.com> #5
I was the person who originally reported this issue to Streak.
ad...@travek.com <ad...@travek.com> #6
I am facing similar issue. Getting error "You do not have permission to call showSidebar" on Opening the file (Docs, Sheets etc..)
Since yesterday, I am getting an exception when calling showSidebar() function with in onOpen().
I am building custom menu onOpen and calling showSidebar() function with in onOpen(). I want run check a few things in a Google Sheet every time the file is open and display an alert and sidebar if certain condition is not met.
The functionality was working perfectly, until yesterday!!
Below is the error that I am getting onOpen()
"You do not have permission to call showSidebar"
I have been using the same script from beginning of this year and never had this issue. I started seeing it since yesterday. Just wondering recent changes to OAuth scope to include " container.ui " is causing the issue.
Since yesterday, I am getting an exception when calling showSidebar() function with in onOpen().
I am building custom menu onOpen and calling showSidebar() function with in onOpen(). I want run check a few things in a Google Sheet every time the file is open and display an alert and sidebar if certain condition is not met.
The functionality was working perfectly, until yesterday!!
Below is the error that I am getting onOpen()
"You do not have permission to call showSidebar"
I have been using the same script from beginning of this year and never had this issue. I started seeing it since yesterday. Just wondering recent changes to OAuth scope to include " container.ui " is causing the issue.
ad...@travek.com <ad...@travek.com> #7
We and our clients numbering around 100 with Google App Scripts attached to spreadsheets found around the 11th of Nov that they needed to re-authorise apps to run. Notification email have been sent to us and our clients. Example below.
We alone received over 1000 email in one day like this for our internal application triggered either by Time or Form Submit.
We have spend over 100 hours reauthorising Google App Scrips so far. Our concern is that will this happen again and why has it happened?
------ Email Message ------
Your script, Client List, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.
The script is used by the document Client List - Do Not Remove.
Summary:
Error Message Count
You do not have permission to call showModalDialog (line 16, file "Menu") 4
Start Function Error Message Trigger End
11/14/17 10:55 AM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 10:55 AM
11/14/17 12:56 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 12:56 PM
11/14/17 1:02 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:02 PM
11/14/17 1:15 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:15 PM
Sincerely,
Google Apps Script
We alone received over 1000 email in one day like this for our internal application triggered either by Time or Form Submit.
We have spend over 100 hours reauthorising Google App Scrips so far. Our concern is that will this happen again and why has it happened?
------ Email Message ------
Your script, Client List, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.
The script is used by the document Client List - Do Not Remove.
Summary:
Error Message Count
You do not have permission to call showModalDialog (line 16, file "Menu") 4
Start Function Error Message Trigger End
11/14/17 10:55 AM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 10:55 AM
11/14/17 12:56 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 12:56 PM
11/14/17 1:02 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:02 PM
11/14/17 1:15 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:15 PM
Sincerely,
Google Apps Script
co...@grmw.org <co...@grmw.org> #9
I am getting the same "you do not have the permission to call..." on many of the scripts I have in place. This started on Nov 3rd. I also go the "you don't have permission to call showSidebar". If I just go in and manually run any of the functions, the script re-authorizes and starts running again.
[Deleted User] <[Deleted User]> #10
Folks how can we get this escalated for an action by Google team ? Its been close to 15 days since the issue started and there has been no action!!
ry...@google.com <ry...@google.com>
ro...@gmail.com <ro...@gmail.com> #11
Thank you for your reports. The issue originally reported is due to recent improvements in Sheets' ability to handle multiple logged in accounts. These improvements expose limitations in Apps Script's ability to do the same. In particular, users may experience issues if they (1) are logged into more than one gmail.com account or more than one account belonging to the same G Suite domain, (2) have selected an account other than the default account while using Docs, Sheets, Slides, or Forms, and (3) use add-ons or the script editor.
ad...@arizonasignsplus.com <ad...@arizonasignsplus.com> #12
Thanks for the clarification of the issue - that matches what we've been seeing. Are you all actively working on a fix or is there a workaround? This is a pretty frustrating experience for our users.
ga...@google.com <ga...@google.com> #13
We're seeing the same. In addition, Session.getEffectiveUser().getEmail() is no longer reliable, if you're logged in with multiple gmail accounts it always returns the first one. Quite a serious problem, please fix this urgently.
ab...@igm.technology <ab...@igm.technology> #14
We have the same issue which is causing our Supermetrics Data Studio community connector to throw errors.
in...@gmail.com <in...@gmail.com> #15
We have the same issue which is causing all of our google sheet queries to break. Its broken our entire data pull that we use with DOMO.
fl...@cpqd.com.br <fl...@cpqd.com.br> #16
Comment has been deleted.
fl...@cpqd.com.br <fl...@cpqd.com.br> #17
I have the same issue
rl...@gmail.com <rl...@gmail.com> #18
Same issue here, all of my reports are down.
ca...@gmail.com <ca...@gmail.com> #19
I have the same issue
me...@strategiezenit.com <me...@strategiezenit.com> #20
We have a very urgent problem. All our reports in Supermetrics with data from Analytics are failing. We get the message "Error: 403 The caller does not have permission (view ID: 12511297)" and the "view ID" number in the error message keeps changing. We have tried using the "Refresh account list " and sometimes it help, but when we run it again we get the same message "Error: 403 The caller does not have permission (view ID"
ke...@gmail.com <ke...@gmail.com> #21
Same problem - all our dashboards on data pulled by Supermetrics are broken - please fix!
mj...@mvadvancements.com <mj...@mvadvancements.com> #22
Any news on this?
Description
var myArray = myObjects[i].myColumn.split(", ");
for (var i = 0; i < myArray.length; i++) {
body.appendListItem(myArray[i])
.setGlyphType(DocumentApp.GlyphType.BULLET)
.setLineSpacing(1.85)
.setIndentStart(40);
}
body.appendListItem("Text").setIndentStart(40);
But how can I set the bullet type to "checkbox"? It is one of the available options within GDocs - as is visible in the attached screenshot.
What steps will reproduce the problem?
Even when .appenListItem() is used on an existing GDoc, the new ListItem has the BULLET GlyphType - as shown here:
What is the expected output? What do you see instead?
I desire to see a "square bullet" or "checkbox bullet" instead of the traditional filled-in-circle bullet.
Project key: MsLO8G64pT47impXr9mjkMu5LtA9g6o2-
To subsequent readers: If you are also experiencing this issue, please
click the star next to the issue number. We prioritize issues with the
most stars.