[dba-Tech] Simple online entry form solution

[Gustav Brock]

Hi Susan

I haven't tried, but this page mentions dropdowns:

https://www.techwalla.com/articles/how-to-create-online-forms-in-excel

/gustav

-----Oprindelig meddelelse-----
Fra: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 7. februar 2018 04:08
Til: 'Discussion of Hardware and Software issues' <dba-tech at databaseadvisors.com>
Emne: [dba-Tech] Simple online entry form solution

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.