Toolbar SurveyMan Button
Opened this issue · 1 comments
This is the first, and probably easiest thing that can be done.
Have a toolbar button where, when you press it, it fills in the appropriate column names. Users can then delete columns they don't want.
What should the behavior be when the user pushes the button and there are columns already filled in? It should try to match the first row as a header row.
Yeah, so I think the sidebar menu should list all the possible column names, and then users can press the buttons for the names they want auto-filled, instead of having them delete the column names they don't want post-facto. That is not efficient, i don't think?
FYI, documentation for sidebars is here: https://developers.google.com/apps-script/guides/dialogs
What do you also think about writing a script that allows users to directly import data files from Drive?
That seems like the easiest import option to me.
I think we can use "Picker" for this:https://developers.google.com/picker/
Thoughts?