Verified
Status Update
No update yet.
Comments
va...@google.com
va...@google.com
Hello there!
If I understand this request correctly, you'd like an API to retrieve all the existing products and SKUs, like the list provided
Can you provide more details on the workflow you have in mind and the potential usefulness of this feature?
- What impact (in terms of costs, productivity, etc.) could this feature have?
- What workaround (if any) are you currently using?
Kind regards.
ma...@google.com
Today, we are importing users from Google into Okta. We include their license information and match against a static list we have defined (based on that API list). If a new license or SKU is added on the Google side, we won’t be able to link this to the user until we’ve made a code change to add the new item to the list. We usually discover the list needs to be updated when the customer complains as we aren’t aware of changes on the Google side. When we are provisioning users, we are unable to assign them the new SKUs and have sometimes removed their Google access because of this.
The other problem comes from updating the license list on our side. Since we can’t query an API, we risk human error when manually updating the list and deploying it to customers. If someone makes a mistake, it can corrupt the whole license and SKU list for customers, which will remove all of their Google licenses.
The other problem comes from updating the license list on our side. Since we can’t query an API, we risk human error when manually updating the list and deploying it to customers. If someone makes a mistake, it can corrupt the whole license and SKU list for customers, which will remove all of their Google licenses.
Description
In Google sheets, when using an installable trigger to execute the toast() function, a toast will no longer appear when anyone other than the trigger owner activates the trigger. This only occurs under Chrome V8; rolling back to Rhino fixes it.
A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.
function toasty() {
SpreadsheetApp.getActive().toast('test');
}
What steps will reproduce the problem?
1. Create the above script
2. Add an installable onEdit trigger for this function
3. As any user other than the trigger creator, edit the spreadsheet
The expected output is a toast window with the word 'test' in it. Instead, nothing happens. No error appears.