I am in the process of writing a php from set which will be used to do the following sequence of tasks:
1. present initial page which shows client name (surname and first name as separate text along with a text form for phone number. On filling out the form and submitting, a mysql query will be done to select the entered client from the client database.
2. show a complete list of fields (there are around forty) on a second page. Some fields will not be populated, as they will be entered that week (e.g. I now have week_n date and week_n_lbs to be entered). We serve folks groceries for 12 weeks during a calendar year so there are 12 week_n and 12 week_n_lbs fields. On submit, I want the current values in the form to be used to update the database for that client for that week_n and the page in step 1 to be shown with blank values of the family name, first name, and phone number, so the person using the form can enter data for the next client.
I also have a need to do some monthly reporting, but figure that I can write the php for that once the things gets going.
Right now, the form under construction is Malachi Food Pantry. As one can see it does not do what I want. I guess my question is whether phpformgen can be expected to do a lot of these goals automatically, or is it the case that I will need to tweak/modify the form heavily? I assume that I will need to write the mysql queries but that is expected. It is the sharing of stuff from page to page that I don't see phpformgen doing, but then maybe it can't as currently constructed since it can't be expected to read my mind.
Please let me know any suggestions for helping me achieve this goal. We are seeing more and more people who need food assistance these days and I am trying to write a basic tool to help the workers automate the data entry and reporting, which is currently being done by hand on paper.
Thanks very much for your help.
Comer
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Send me an email so we can communicate outside this forum. I would be happy to help you out.
You are correct, phpFormGenerator will not read your mind and is only meant to be a basic form generator. Customization is left to the user.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am in the process of writing a php from set which will be used to do the following sequence of tasks:
1. present initial page which shows client name (surname and first name as separate text along with a text form for phone number. On filling out the form and submitting, a mysql query will be done to select the entered client from the client database.
2. show a complete list of fields (there are around forty) on a second page. Some fields will not be populated, as they will be entered that week (e.g. I now have week_n date and week_n_lbs to be entered). We serve folks groceries for 12 weeks during a calendar year so there are 12 week_n and 12 week_n_lbs fields. On submit, I want the current values in the form to be used to update the database for that client for that week_n and the page in step 1 to be shown with blank values of the family name, first name, and phone number, so the person using the form can enter data for the next client.
I also have a need to do some monthly reporting, but figure that I can write the php for that once the things gets going.
Right now, the form under construction is Malachi Food Pantry. As one can see it does not do what I want. I guess my question is whether phpformgen can be expected to do a lot of these goals automatically, or is it the case that I will need to tweak/modify the form heavily? I assume that I will need to write the mysql queries but that is expected. It is the sharing of stuff from page to page that I don't see phpformgen doing, but then maybe it can't as currently constructed since it can't be expected to read my mind.
Please let me know any suggestions for helping me achieve this goal. We are seeing more and more people who need food assistance these days and I am trying to write a basic tool to help the workers automate the data entry and reporting, which is currently being done by hand on paper.
Thanks very much for your help.
Comer
Send me an email so we can communicate outside this forum. I would be happy to help you out.
You are correct, phpFormGenerator will not read your mind and is only meant to be a basic form generator. Customization is left to the user.