web app : sharing settings

Question

I have an apps script, a web app (within google site, share option: "Who has access to the app:anyone within mydomain" when publishing it) who make a forms using code as :

  var app = UiApp.createApplication();
  var panel = app.createVerticalPanel();

.....

When user press submit button the data are saved in a spreadsheet.

I have to give full access to an user group on this spreadsheet in order to make the forms works.

the problem, is that i don't want user1 (belonging to the user group) see what user2(belonging to the user group) has save in this spreadsheet.

At the moment, i share the spreadsheet without notifications but users are style able to access the spreadsheet using "shared with me" button on the drive.

Question: Is that possible to hide share (like $ share on windows)?

Is that possible to let the script special grant option to read/write the spreadsheet without sharing it with the user group on run time.

or how the actual google forms (the one provide by google drive, not mine) handle this problem ?

Google API is not activate in my domain, i have a google education license and i am the admin of this domain.

hope it's clear enough.^^

thanks for hwelp

Mogsdad Mogsdad · Accepted Answer · 2013-03-07T11:34:57

If you use Google Forms, you do not need to share your spreadsheet at all. You can distribute the URL for the live form, and from there users can only enter form data. Forms are static, though - you can edit the questions easily, and create logical flows between pages of questions based on previous answers, but you cannot dynamically include data. You're also very limited in your options for layout. But aside from that, the ease of use and information security make them a good option.

With Legacy Forms, collected data is stored in a spreadsheet. Since the introduction of the new Forms, you need to first create your spreadsheet, then select Forms - Create Legacy Form to start. The "Summary of Responses" report reflects what is in the form table in the spreadsheet. Any changes you make to the sheet affect this, for example row deletion, addition, or information edits.

With the new Forms, introduced in February 2013, the collected data is attached to the Form, not a Spreadsheet. You can choose to have it copied to a spreadsheet, but since that is a copy, any edits you make to it will not be reflected in the "Summary of Responses". You can create a new Form from the "Create" dialog in Drive, or from within a spreadsheet.

web app : sharing settings

2 Answers