Hi,
I'm volunteering/helping a High School Music Band with annual registration forms (to sign-up before school starts).I created a Joomla site with Community Builder component where I have created all of the web forms, asking the students for their information after logging into the site. There are ~400 students.
I have a multipage Word Document with all of the registration forms to be printed. In the Word pages I have the Form Fields created so the linked data from the web forms can be used to populate each students information for printing the completed forms.
Manually, I have to export the Community Builder "Profile" data to a spreadsheet (CBJuice to .csv file), then open Word and pick which student has completed their information when I need to print (make a PDF) then email them their forms. This is the part I'd like to circumvent with a script to process the student data and then create a PDF output similar to the Word documents.
Then the student can "do it yourself" and I don't have to perform the "Login > CBJuice output > Import into Excel > Open Form in Word > Pick student > Print PDF, then Email it" routine 400 times.
Basically, I need to create a specialized PDF button within a Joomla site so users can print their own forms.
Also desirable is the added possibility that the output document will be different depending on a selection in the web forms. The documents to be populated will be static but which one is used to create the PDF would be chosen based on a field choice in Community builder. An example: the kids who play horns have no interest in drumstick information, so the forms they get can omit drumstick choices page and include a page about care of their horn.
I've told folks they can start filling out their forms online on July 6th but this is not a hard deadline. Registration isn't until August 3rd, so they don't NEED their forms printed until then.
Thank you.