[dba-Tech] Simple online entry form solution

Susan Harkins ssharkins at gmail.com
Wed Feb 7 12:42:10 CST 2018


I really don't like Google Docs, but that's where I started. My biggest need
is a dropdown list, preferably one that I can populate from sheet data --
that doesn't seem to be an option for 365. One of the Microsoft form options
offers a dropdown list, but you have to manually enter the values, which
isn't terrible by any means -- I'd have to update the list as the group adds
and loses members, but I'd have to do that to a list at the sheet level as
well. 

Susan H. 

Since you have mentioned Google Sheets, why not try Google Forms?

You can create a form, with or without the need for the respondent to have a
Google account.

It allows you to build Combo boxes among other input methods.

Or are you trying to build the form using sheet input?

B

On 6 February 2018 at 20:07, Susan Harkins <ssharkins at gmail.com> wrote:
> I'm currently looking for a very simple way to solicit data from very 
> unsavvy users. I have OneDrive for Business but I've found Excel 
> Online Forms very limited. I need to limit responses using dropdowns. 
> Also, I can't figure out how to edit a form once I've saved and shared it.
>
> Or either of these possible?
>
> I'm also looking at Googles Spreadsheet. I've got a script that will 
> let me create a form based on the sheet, but again, I need populated 
> dropdowns -- and I don't know if the form will pick up on those. I haven't
tried yet.
>
> The 365 Excel Online Form would probably be the easiest and quickest 
> route for me if I can generate dropdowns and edit the forms as needed.
>
> Looking for suggestions. Thanks!
>
> Susan H.
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com



--
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well-preserved
body, but rather to skid in sideways, totally worn out, shouting "What a
great ride!"
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com



More information about the dba-Tech mailing list