I did try to search for what I am trying to do within the forums but after about 5 hours no luck yet.
I own and use chronoforms and have a new requirement to setup that I am hoping I can do with chrinoforms.
I need to have a form or a web page without a form wherein the user types in the name of a school, their first and last name into two different fields and choose their data of birth from a calendar.
Once the user clicks submit or next, I need a couple of things to happen….
1) I need the age of that person to be calculated.
2) Then I need to take the age of the person and the school they typed in and look up a dollar value for that combination. What this means is that the person I am setting this up for sells training to individuals and charges different rates based on the age of that person. So I need to be able to store the school, age and fee for that age range somewhere and then when a visitor comes to the webpage and types the name of the school, their first name and last name and date of birth I need the age calculated and then lookup the school and the rate for that calculated age and prepopulate it into a form where there will be additional fields. So the school name, the first name and last name and age as well as the rate will be inserted dynamically into the chronoform. Each school will have a different rate based on the age of the person. They actually use age ranges so 30 years old or younger would be say $45 and age range 30 to 35 would be $48.
I am not sure how to accomplish this with chronoforms.
3) I need to store all the data submitted from the form in the database and export all of it later in a csv file. This part I know how to do. Now one additional request is to allow the user who filled out the form previously to pull up that info again in the future. Not sure this is very doable but I figured I would throw it in.
I own and use chronoforms and have a new requirement to setup that I am hoping I can do with chrinoforms.
I need to have a form or a web page without a form wherein the user types in the name of a school, their first and last name into two different fields and choose their data of birth from a calendar.
Once the user clicks submit or next, I need a couple of things to happen….
1) I need the age of that person to be calculated.
2) Then I need to take the age of the person and the school they typed in and look up a dollar value for that combination. What this means is that the person I am setting this up for sells training to individuals and charges different rates based on the age of that person. So I need to be able to store the school, age and fee for that age range somewhere and then when a visitor comes to the webpage and types the name of the school, their first name and last name and date of birth I need the age calculated and then lookup the school and the rate for that calculated age and prepopulate it into a form where there will be additional fields. So the school name, the first name and last name and age as well as the rate will be inserted dynamically into the chronoform. Each school will have a different rate based on the age of the person. They actually use age ranges so 30 years old or younger would be say $45 and age range 30 to 35 would be $48.
I am not sure how to accomplish this with chronoforms.
3) I need to store all the data submitted from the form in the database and export all of it later in a csv file. This part I know how to do. Now one additional request is to allow the user who filled out the form previously to pull up that info again in the future. Not sure this is very doable but I figured I would throw it in.