Share google doc with selected person

Questions & Suggestions
1

I frequently share Google Docs with several people, and I would like to make a macro that automates this process. First, I want a prompt where I can indicate if the person being sent the doc can "view", "comment", or "edit"; then I want to be able to select who the doc is sent to via a macro palette.

image
Step 1

image
Step 2

I know I could have one macro palette with "view", "comment", and "edit" options that link to three separate palettes of macros—each one with actions to send to specific people (with "view", "comment", or "edit" access based on which was selected in the first palette).

I'm wondering if there is a way to accomplish the same thing without needing the three macro palettes for "view", "comment", or "edit" access—just one where I select "view", "comment", or "edit" access, which opens a second palette when I can then select the person receiving the doc. Is this possible?

If what I just described made any sense, I would appreciate your help!

2

Assuming you do not have too many people and the list is not going to change that much, why not do the following.
Create a user prompt with the

Username1 Permissions
Username2 Permissions
Username3 Permissions
Username4 Permissions

where permissions character is V C E N for

View, Comment, Edit, Space or N for none...
and then take the necessary action for each user.

1 Like