I've been looking in the forum today and most likely with a lot of hard work I'll be able to do this form myself and the support on this forum (bob) is super but I wonder what someone might charge for it.
Please give me a quote to build in ChronoForms the following:
Userform:
select box city (either dropdown box or AJAX text field, SQL with all the citynames is available); default = ALL
select box year (2009,2010,2011) (default is 2009)
select box option 3: a list with <10 values; default =all
select box option 4: a list with <10 values; default =all
select box option 5: a list with <10 values; default =all
text field: name (mandantory if email is entered)
text field: email
tick box; agree to terms (mandantory if email is entered)
Submit button
After the user click on submit:
A new page should be displayed with the results of a query based upon the users selection in the form. The query should take all the values entered as tightly as it can get it.
If the user entered a name and email the results of the query that is displayed should also be emailed
The name and email should be stored in the users table from Joomla! (if the email is already there then no action should be taken) If Joomla! users table requires any other fields those can be filled with default values. Also the user should not be activated.
The entire form should be stored (city, year, option 3, 4, 6, name and email) in a seperate table. Each new entry should be logged regardless of double entries by a name or email adres). It should be possible to retrieve the information later (possible via ChronoConnectivity) to run queries on it.
You should use multiple tables. One of the fields that will be returned is a period in time. This periode is based for on region. And a city always is in a region. So: overtime the time periodes will change. But I would like to change only that field in the DB. Ofcourse if a city changes region (sounds strange but it happens) I only want to change the region code for the place etc. Normal commen database practice.
No need to make a fancy form; I will do the layout myeself.A basic <BR> between the fields is OK.
Once you build and delivered code I should get full rights to use, change, modify the code. Delivery of the code should be in such a fashion that I should add it to Chronoforms myself. tables that need to be created/filled should be delived in a sql file so I can auto add it myself.
If you require more information please let me know.
Please give me a quote to build in ChronoForms the following:
Userform:
select box city (either dropdown box or AJAX text field, SQL with all the citynames is available); default = ALL
select box year (2009,2010,2011) (default is 2009)
select box option 3: a list with <10 values; default =all
select box option 4: a list with <10 values; default =all
select box option 5: a list with <10 values; default =all
text field: name (mandantory if email is entered)
text field: email
tick box; agree to terms (mandantory if email is entered)
Submit button
After the user click on submit:
A new page should be displayed with the results of a query based upon the users selection in the form. The query should take all the values entered as tightly as it can get it.
If the user entered a name and email the results of the query that is displayed should also be emailed
The name and email should be stored in the users table from Joomla! (if the email is already there then no action should be taken) If Joomla! users table requires any other fields those can be filled with default values. Also the user should not be activated.
The entire form should be stored (city, year, option 3, 4, 6, name and email) in a seperate table. Each new entry should be logged regardless of double entries by a name or email adres). It should be possible to retrieve the information later (possible via ChronoConnectivity) to run queries on it.
You should use multiple tables. One of the fields that will be returned is a period in time. This periode is based for on region. And a city always is in a region. So: overtime the time periodes will change. But I would like to change only that field in the DB. Ofcourse if a city changes region (sounds strange but it happens) I only want to change the region code for the place etc. Normal commen database practice.
No need to make a fancy form; I will do the layout myeself.A basic <BR> between the fields is OK.
Once you build and delivered code I should get full rights to use, change, modify the code. Delivery of the code should be in such a fashion that I should add it to Chronoforms myself. tables that need to be created/filled should be delived in a sql file so I can auto add it myself.
If you require more information please let me know.
This topic is locked and no more replies can be posted.
