Need help figuring a form flow

[tsmallmon]

I have a current personal website setup including users and passwords. What I would like to figure out how to do is add a form. What I would like the form to do is where I am getting lost.

I am diabetic as well as a few other medical conditions. I want the form to, be usuable by all my family memeber that I have as resigtered users.

There are apps that do part of this but they are expensive and don't full do what I want.

First the form would have a drop down to select the current user which would populate the questions and make sure the information is carried to the correct user report.

Second woud auto set the correct date and time

Questions would then be along the lines:
Blood Pressure
Weight
Blood Sugar
Body Measurements
Mood
Any current symptons
Check boxes for each medication as a reminder to take them.
Probably a few other questions.

This is where it will get tricky
When I hit submit instead of it emailing I want it to add the collected information to a report in a column next to the previously sumbit information, and display the report as well as save it for furture reference. This would allow me to be able to print the table of results to take to the doctor as well as monitor changes over a period of time.

By adding it to my website I would be able to enter or retrieve information from any device at anytime.

Any sugestions on how to do this with out have to pay extra fees or use third party software?

Thanks Tim

[BaconFries]

You can design the layout within the program but the logic will require programming in the backend to do what your asking. So a custom script (most likely paid) will be needed using the likes of php and as there are other users a database will also be required so to store and call there information when they are filling the form then save again any changes. Unfortunately we cannot teach you this as it is outwith the scope of the forum.

[wwonderfull]

WWB does have the front end part to submit from data to the database but the backend would require (custom codes) php javascripts or other libraries as has been mentioned to generate reports or tables. It would then be possible to create reports like you see in medical institutional document papers using the data from the database. Would require php templating for the reports and variables input along with separate report management for each users as separate users need separate tables for their activities. It also might need login session as you mentioned about dropdown which I have not seen such way of user management unless we have 5 gmail accounts logged in our app which reminded me of that way which is still complicated to work with.

It would take alot of time and money without a regret to be honest because it is indeed a totally custom project which wwb can be the tool to master all the solution along with custom coding.

[tsmallmon]

So basically it is doable but complicated.

What if I simplified it by each family member having their own pages.

Creating the form with the form wizard wouldn't be that hard, however I don't know how to get it to link the information to a table.

So far all the forms I have created always send the information to email.

I haven't even been able to get forms to send to email in a pdf style format or figure out multi-page forms .

[wwonderfull]

So basically it is doable but complicated.

What if I simplified it by each family member having their own pages.

Creating the form with the form wizard wouldn't be that hard, however I don't know how to get it to link the information to a table.

So far all the forms I have created always send the information to email.

I haven't even been able to get forms to send to email in a pdf style format or figure out multi-page forms .

First the data from the form goes to database from database takes the data generates the report. So in a sense it would still require custom codes as of my knowing wwb does not provide extensions so again said custom codes needed which has to be connected to the database to retrieve the data put it on the template and then create the printable page. Now more than that what is needed is you would also need a front end database data viewer where you will have the table and the column where you will have reports and each row will have unique data to create unique report for each day.

Two ways you can reduce more complication using folders in server for each family members and also by creating separate tables for each family members although it is the same database.

Now the sending emails and stuffs can be stopped by editing the code which is not a problem but after it goes to database you have to bring that data to view and not just view then I would say data viewer was enough and we have alot of extensions for it. But you need a special column to make the report so you need that special column too. And the table you need has to be custom made the dates should be in rows and the questions should be on column. On clicking the report it will take to a special page which will generate the report based on the data.

[alan_sh]

Why not just use something like Google Sheets to record the information?

Alan

[BaconFries]

@alan_sh asked and replied see the following from tsmallmon
viewtopic.php?p=491770#p491770

[BaconFries]

I haven't even been able to get forms to send to email in a pdf style format or figure out multi-page forms

Good place to start on how to use forms
Creating a Form
https://www.wysiwygwebbuilder.com/forms.html

The form data can be saved as csv or sql (server)
How to use PHP to collect Form data
https://www.wysiwygwebbuilder.com/forms_php.html
Once you have the csv you can then use the following display and/or print the data, you can use one of these extensions.
https://www.wysiwygwebbuilder.com/mobil ... table.html
https://www.wysiwygwebbuilder.com/collapsibletable.html

Extensions that can display CSV data from the server.
https://wysiwygwebbuilder.com/bootstraptable.html
https://wysiwygwebbuilder.com/csvcrud.html
https://wysiwygwebbuilder.com/datatables.html
https://wysiwygwebbuilder.com/responsivedatatable.html

Mult Page Form
How to use the Carousel to create a multi-page form?
https://www.wysiwygwebbuilder.com/carouselwizard.html

With all of the above it is possible but in some instances it will always require a custom script to ger what you really want.

[alan_sh]

@alan_sh asked and replied see the following from tsmallmon
viewtopic.php?p=491770#p491770

No, I meant why bother using a web site at all - just use an online spreadsheet.

Alan