[dba-Tech] Simple online entry form solution

Wed Feb 7 11:17:28 CST 2018

Susan:

That's the problem. To have all the features you/they need requires a custom project. Even the simplest methods are easy up until that last 5 percent. (But of course that is why you get paid the big bucks. ;-))

Jim

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

Well, the quickest and easiest method so far is an Excel Online Form or Survey. Both have limitations as far as presenting and entering data, but it's a good temporary solution. It's a great temporary solution. 

Susan H. 

That was one of the OT crew suggestions too. I don't know php but don't mind learning enough of it to make that happen. My one consideration is that this is a pro bono project for a nonprofit. They need something that I can show them how to support it when I'm not available -- if I can come up with one. 

Thank you!
Susan H. 

On 2/6/2018 21:07, Susan Harkins 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,

They're a snap in PHP. This one grabs its dropdown entries from MySQL but it's every bit as easy writing to MSSQL ...

|<html>

|'text</span>/<span word="Javascript'" id="DWT2791" class="ZM-SPELLCHECK-MISSPELLED">Javascript'</span>><br>     function submit( f ) {<br>       f.submit();<br>     }<br>   |

|
|php
$conn = mysqli_connnect(...);
$resfoo = mysqli_query( $conn, "SELECT foo FROM footable" )
           or exit( "Cannot retrieve foo values" ); echo "Foo Value: n"; echo " 'foo' onChange='submit(this.form)'>n"; while( $row = mysqli_fetch_row( $resfoo )) { $sel = ( $table === $row[0] ) ? "id='sel' selected" : ""; printf( " s'>%sn", $sel, $row[0], $row[0] ); } echo " n"; echo " 'edit' type='button' value='Pick a foo' onClick='submit(this.form)'>n"; ?>|
|

html>

PB

-----
|

>
> Susan H.
>
> _______________________________________________
> 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