[dba-Tech] Simple online entry form solution

[Susan Harkins]

I appreciate that, but I didn't write any of the web stuff, just the
database stuff. I haven't a clue about web development. I've missed that
boat. 

Susan H. 

This should all be super simple for you, after all you wrote two books on
how to build websites using Adobe Dreamweaver...I have both of them. :-)
 
Jim

----- Original Message -----
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Discussion of Hardware and Software issues" databaseadvisors.com>
Sent: Wednesday, February 7, 2018 10:42:10 AM
Subject: Re: [dba-Tech] Simple online entry form solution

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

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com