[dba-Tech] Simple online entry form solution

[Jim Lawrence]

There is a lot more complex forms in Google (all for free) if you want to go that route. My daughter took about a day and a half to build an entire website to her preferences. It was all done via drag and drop. Here is a link to a blog input form that stores all the detail on to a Google spreadsheet back-end. Working Example:

https://sites.google.com/view/kflamenco/contact

I don't think she had to write a single piece of code. The following is the link to the form sample options page. Again it is all drag and drop. You just select the feature you want, drag to the working windows, drop the object where you want it...in this case a form, position it, size it, add and subtract the entry fields, modify and caption the field, position the save button and done. The content of the fields are all saved into a spreadsheet, that you, as the site owner, can retrieve. Note the Google spreadsheet is complete compatible with Microsoft Excel:

https://www.google.com/forms/about/?utm_source=product&utm_medium=forms_logo&utm_campaign=forms  
http://bit.ly/2BgKSIP

...And the following is the form builder page:

https://docs.google.com/forms/u/0/

To make a test page after the form has been constructed to your liking, just right mouse check on the working form, select the option, view page source, select the entire page , open a text document on your desktop, move to text doc and deposit the contents in the text doc and save. Either immediately name the text document or rename it to something like "MyFormTest.html". After that you can just double click in the file and it should automatically display in you default browser. Easy peasy. You can go back to the builder page as often as you want and trick up a form to your exact specification. ...Have fun. :-)

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