0

This is a follow-on to question here.

Review in linked post: menu click function in a library ('rm' in this case) works.

ui.createMenu('Test').addItem('Test-Lib', 'rm.test');

However, going forward I had found that this ONLY works iff the user has EDIT access to the (rm) library. I have tested this for "links" "readonly" and "readonly public access". Only works for EDIT access.

The background information is that I've found NO information regarding this from Google/Official sources.

Initial finding was good (click function in library) in that it saved me a lot of coding. But now I'm back to square one, as I cannot give edit access to the library.

Anyone have any experience on this? Ideas? Workarounds? Thoughts?

EDIT;

Big thanks to @tehhowch comment below with his link. Solved it, but still a little bit tedious solution. To summarize:

  1. Read-Only access means that user does not have access to the development version, but only the linked version - so need to make sure that linked version has all the requirements met.
  2. Republishing the lib to the same version did not work.
  3. Republishing the lib to a new version and updating the client spreadsheet to the new version did work.

Of course, this is a bit tedious going into all client spreadsheets that use the lib, but at least now i can deploy with read-only access to my libs :)

Improve this question
2
  • 1
    Well, what error message do you get? Related: stackoverflow.com/questions/12842441/… stackoverflow.com/questions/19841664/… Please update your question with any relevant error messages and how you have attempted to resolve your issue. Commented Jul 9, 2018 at 16:55
  • @tehhowch Amazing, with your link I was able to solve the issue. Two things. (1) Read-Only access means that user does NOT have access to the development version, but ONLY the linked version - so need to MAKE SURE that linked version has all the requirements met. (2) Republishing the lib to the same version did NOT work. (3) Republishing the lib to a new version and updating the client spreadsheet to the new version DID WORK. Of course, this is a bit tedious, but at least now i can deploy with read-only access to my libs :) Commented Jul 9, 2018 at 19:16
Related questions
10
Spreadsheet onOpen menu from a Library
0
Menu not creating in spreadsheet onOpen
1
Google apps script - Custom menu to run custom funtion
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.