On 2018/08/17 8:11 PM, Bob Sisson wrote:
I am looking for a cross platform app builder that will use SQLite to build an inspection
checklist that will build a "summary page" that takes selected check boxes,
radio buttons and pull downs and looks up their expanded values and fills in a summary
page to be printed.
This sounds somewhere between weird and wrong, which is why you are
getting replies about the question being confusing. I'm assuming /
hoping that you meant the following:
"I am looking for an App development platform that can build a
cross-platform app which will have checklists with very many items (that
can be checked/selected) and then be saved to an SQLite database and
then able to query the data to produce a short summary page which can be
displayed to the user and be printed."
It is also possible that you meant that the app should "generate the
checklists" from data that you have pre-loaded into an SQLite database.
Both of these things are extremely easy to do using HTML5 and PHP - it's
as cross-platform as it gets, and PHP can natively understand SQLite
Databases (and others). The summary can be output as HTML or PDF and
even mailed to anywhere. Submitting the data will also add it directly
to your central web server, and more importantly, the moment you change
a checklist, it will be changed immediately for all users, no need to
send a refreshed set of data. Any server running a basic LAMPP stack
will suffice, and any browser on any device will be your oyster.
Now there's lots of information missing about your use-case, but if you
say PDF forms could do it (barring the field-count), it means that
PHP+HMTL5 will do it significantly better and easier. It will then be
easy to later add fun things like who submitted which checklist at
which time, and which items were all (un)checked when they did. etc.[*]
One caveat I can think of: Most phone browsers will need a live internet
connection to function. Computer browsers can typically function
off-line, but to submit a filled-in checklist will again need a live
internet connection.
Cheers!
Ryan
[*] - We've done similar things a few times (as have others here), if
you need some more specific information, pointers or assistance, will
gladly help, but mail us off-line because that falls far outside the
scope of interest of this forum.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
