CODEWITHSUNDEEP
google-apps-scriptweb-applicationsgoogle-sites
Chris S
Chris S

Reputation: 225

Can Google Apps Scripts be flexible enough to handle multiple sheets?

Is it possible with one Google Apps Script published as a Web Application to be flexible enough to connect to different spreadsheets depending on the person or webmaster using the Application?

I saw when working with one of my scripts there are ‘script properties’ and then ‘user properties’ tabs under ‘Project properties’.

I tried to add a property but couldn't get it to Stick

So then I found Google Apps Script ‘Class Properties’ area.

When I think of how these two properties might work, I think of Google Gadgets. A user can add a gadget to her Google Site but can then change or configure the Gadget in the properties area of that gadget

Is this type of functionality possible?

Upvotes: 0

Views: 133

Answers (2)

HDCerberus
HDCerberus

Reputation: 2153

For the question, 'Can Google Script me modified to run differently depending on who's running it', yes.

For example, you could use the function 'getActiveUser()', and dependent on who the user was, you could set a variable such as 'thisUsersSheet == usersSpreadsheet key', among many other ways to do this.

Whether or not it would be possible to have it replaced site gadgets, that's much more dependent on what you're trying to achieve specifically.

Note: You mention 'Script properties' and 'User Properties' in your question. Stay away from these, they are deprecated.

Upvotes: 2

Alan Wells
Alan Wells

Reputation: 31320

You can configure settings that will allow one script to access the files of the user of the Apps Script. The user needs to log in with their Google account. You can publish the Apps Script script to run as ANYONE, and Execute the app as: User Accessing the Web App. Which requires the user to log in with their Google Account, and will allow the script to access the users files.

The Properties Service is for storage. It doesn't set or grant permissions. A break down comparison of the different types of Properties is shown at:

Comparison of Property Stores

Upvotes: 2

Related Questions