Dynamic pdf form avoiding fdf
Posted: Sat Jul 05, 2008 7:31 am
Hi everyone,
I've searched a lot for this topic, but all I keep running into is explanations on fdf.
I want to create a "setlist creator" for a band. We have all our songs, our repertoire, in a mysql table with columns for key etc. I'm imagining something like this:

First off, the user, a member of the band, chooses the number of sets (with 12 songs each by default, maybe this can be changeable?)
Next, a page similar in concept to the image above, appears, and the dropdown boxes are fed by the mysql table containing songs. Also, the date is taken from the relevant "gig" record in another mysql table. The user then selects the order of the songs. I'm not sure whether it's possible to have the page with dropdown boxes for the following sets come below the first one on the same page, or if it's best to click a "next" button for each set to be filled out?
I want the finished product to be an X-paged (X be the number of sets) pdf file ready for print, but I want to avoid using fdf as my server does not support this.
I hope some of you will help me along the way. I'm not looking for some finished code served to me, I just want some points in the right direction. I have Adobe Acrobat Professional 8 for OSX.
I've searched a lot for this topic, but all I keep running into is explanations on fdf.
I want to create a "setlist creator" for a band. We have all our songs, our repertoire, in a mysql table with columns for key etc. I'm imagining something like this:

First off, the user, a member of the band, chooses the number of sets (with 12 songs each by default, maybe this can be changeable?)
Next, a page similar in concept to the image above, appears, and the dropdown boxes are fed by the mysql table containing songs. Also, the date is taken from the relevant "gig" record in another mysql table. The user then selects the order of the songs. I'm not sure whether it's possible to have the page with dropdown boxes for the following sets come below the first one on the same page, or if it's best to click a "next" button for each set to be filled out?
I want the finished product to be an X-paged (X be the number of sets) pdf file ready for print, but I want to avoid using fdf as my server does not support this.
I hope some of you will help me along the way. I'm not looking for some finished code served to me, I just want some points in the right direction. I have Adobe Acrobat Professional 8 for OSX.