Forums

Pulling data from several tables and other neat things

Sabye 07 Nov, 2012
Hello all,

I have been searhcing for a good forms generator that will perform seveal functions and Chrono was highly reccomended. I need to accomplish the following;

- create a user input form that will save data in its own table in an exiting database
- this form will pull data from other tables in this database and display on the user input screen as read only fields
- each stored record will have a unique accumulated ID number
- upon the user completing the form, the "Submit button will perform several functions; save data to existing table using the current submit function, save the user data to the new table, and e-mail the form data in a unique format to multiple e-mail address (ie admin, agent and agents client)
- will also need to be able to print the form in a unique format with user fields injected into the printed form.
- require user to be able to search forms and edit thier entry filtered on thier user ID and submission ID number
- create reports for daily, weekly, monthly reporting of collected data in menu selected criteria, also avaiablle to filter on logged in users by security level.
- Must be able to "include" the form in an existing form format as "injected" fields

Well, how's that for requirements huh? Do you think Chono will allow me to accomplish this feat?

Thanks a bunch,
Maurice
GreyHead 07 Nov, 2012
Hi Maurice,

Yes, apart from the last bullet which I don't understand.

Bob
This topic is locked and no more replies can be posted.