I created a panel using doGet (HTML panel), linked to a spreadsheet. It will be used by supervisors of the company where I work. Depending on which supervisor opens the page, only employees in your sector will appear in a drop-down list. (getEffectiveUser). When selecting an employee from the drop-down list, extract some data corresponding to the employee from the file
The drawback I have is that I have to give supervisors permission to edit the file (even if they do it from the HTML panel), and the idea is that those people can not see the file. The file can be shared to the organization without people noticing, but when they load data through the html panel, the file appears in the Drive in the "Recent" section. A form is not useful for me because it does not extract data from a spreadsheet dynamically.
I tried to add a file of "interface" mode, but the change must be done manually to execute an activator, and for time, the minimum is 1 minute and it is too much, since it must be automatic the return of the load from the spreadsheet to the html panel.