CODEWITHSUNDEEP
google-apps-scriptpermissions
Ivan
Ivan

Reputation: 11

Shared Google sheet users has no permission to call showModelessDialog under installable trigger

I have got a google sheet with a onEdit installable trigger calling a bound script. In the script it will call showModelessDialog to show a dialog and it works fine when I edit the sheet.

The sheet is shared to other users with edit permission, but when they edit the sheet no dialog be showed and got

"You do not have permission to call showModelessDialog"

Checked the authMode is FULL when the script be called by the installable trigger.

Tried to trigger the same script from a custom menu and all users work fine.

May I know why others user cannot call showModelessDialog under onEdit installable trigger even authMode is FULL and how to fix it?

Upvotes: 1

Views: 77

Answers (1)

MαπμQμαπkγVπ.0
MαπμQμαπkγVπ.0

Reputation: 6737

onEdit is a Custom Function, as discussed in this SO post:

Custom functions run with limited permissions, and cannot take advantages of services that rely on user credentials, including DocumentApp.

I think that is one of the reason why you are getting that error.

Upvotes: 0

Related Questions