Android Question Programatically building screens/forms and handling data entry

[jcredk]

Hi all,

I searched the forum, but did not find something comparable to what I search.

I am working on a program with a workflow to enter data (texts, radio, combo, up/down values, signature, camera ...).
As making the application "product-oriented" and focusing several customers, we would like to have the ability to store in the database the forms that are to be entered by the user:

• One request on the database would provide "the data dictionnary" of the fields to be entered by the end user
• One request on the database would provide the "view definition", a mapping providing ways a field could be entered
• One request on the database would provide the default values (when creating a new record) or the previously entered values (if data entry was interrputed and starts again)
• Of course at the end an update on the database would save the user data entry

Do you know something on the forum dealing with this ?
Do you think it's reasonnable to implement this with B4A ?
Would you have high level advises on the code architecture?

OK not a small thing and with large questions but any contribution is welcomed ...!

Thanks, @+
Jcredk

 

[devlei]

I'm struggling to understand exactly what you want to do, but two questions:

• Have you checked out the DBUtils functionality? See link here
• Are you familiar with SQLite? You should be able to handle any type of database functionality (forms, records, queries, tables etc) with it! One tutorial is here .

 

[klaus]

You should have a look at the User's Guide there you find a more recent SQLite example.

Best regards.