Forums

Generating data from tables

bongianu 26 Jan, 2013
Hi,

First of all many thanks to ChronoForms Team for creating this extension which has made work easy.

I wanted to know if ChronoForm could display data from two different forms to generate that data in one PDF or CSV?

For Instance,
I have FORM 1 with values Name,Age,Location.When the user hits save button for this form data is saved in the database.
I have FORM 2 with values Education,Income.When the user hits save button for this form data is saved in the database.

I want to generate a PDF/CSV by collecting the data of both the forms,please can you tell me if it is possible by Choronoforms extention?


Regards,
Anup
GreyHead 27 Jan, 2013
Hi Anup,

Yes, that is possible. You can use several DB Record Loader actions to retrieve data from different tables.

Bob
bongianu 27 Jan, 2013
Hi Bob,

Thanks for your reply.

I will try to tell this scenario in a better way:

There are 3 different User in my Website
1.Admin
2.Student
3.Professor

There is a different form link for Student and Professor.

Student form has fields:a.Name of Student
b.Student Subjects
c.Student Marks

When Student fills this form,he will click Submit and Thank you Email is Sent and PDF file is created with FORM data and also data is stored in database.

Professor form has fields:a.Name of Professor
b.Professor Teaching Departments
c.Professor Qualification

When Professor fills this form,he will click Submit and Thank you Email is Sent and PDF file is created with FORM data and also,data is stored in database.

Once Both User and Professor Completes the Form,the admin should be able Merge both the Form Data from two different tables.

Please let me know how is it possible to do?

Thanks,
Anup
GreyHead 28 Jan, 2013
Hi Anup,

It's not possible to tell you how to build a whole form application in a few lines here.

You start with the Student form, adding just the most important inputs. Test that it works.

Add the Professor form, again with just the most important inputs. Test that it works.

Work out how the DB Saves will work and the DB merge. Build that.

Go back and add the PDFs, extra inputs, etc.

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