Skip to main content
P
PTOT Connect
Participant
February 11, 2009
Question

Dynamically populating dropdown lists in a pdf form from a datasource

  • February 11, 2009
  • 5 replies
  • 9543 views
Is there a way to populate a dropdown list in a pdf form from a datasource, specifically from an Access database table or query, using LiveCycle Designer. I am easily able to do this using cfselect in Coldfusion, however, cannot seem to figure it out for pdf forms. I am aware of the Show Dynamic Properties option enabled in LiveCycle Designer, and then binding to a datasource. However, this seems limited as I am only able to select single columns from Access (currently using an Access database) tables, and a unable to select from queries like I do using cfselect in Coldfusion forms. Is this something that must be done with Java scripting? If so, is there any other way? I know nothing about scripting. Thanks
    This topic has been closed for replies.

    5 replies

    A
    Anonymous
    August 5, 2010

    You can find a sample PDF here which related dropdown list are populated from Access table.

    Enjoy,

    Murat

    www.muratkuru.com.tr

    L
    Lithcause
    Inspiring
    March 20, 2009
    you can try doing a cfdocument format="pdf" and try making that a interactive form... just a thought
    D
    Daverms
    Inspiring
    February 17, 2009
    Hi DerrickDel,

    Do you want to create an interactive pdf form from where the user can select a value from the drop down presented?

    (Or)

    You just need to populate a pdf from database tables?.

    Please clarify..

    P
    PTOT ConnectAuthor
    Participant
    February 17, 2009
    I want to create an interactive pdf form where the user selects a value from a drop down list on the form. I would like that drop down list to be dynamically populated from a database table or query.
    P
    PTOT ConnectAuthor
    Participant
    March 2, 2009
    Not possible eh?
    D
    Daverms
    Inspiring
    February 17, 2009
    Hi DerrickDel,

    Can you please post your code here?...



    P
    PTOT ConnectAuthor
    Participant
    February 17, 2009
    <cfpdfform source="C:\Users\Derrick\Desktop\pdftest.pdf"
    result="pdftest"
    action="read">
    <cfdump var="#pdftest#">
    </cfpdfform>

    <cfpdfform source="C:\Users\Derrick\Desktop\pdftest.pdf" action="populate">
    <cfpdfsubform name="form1">
    <cfpdfformparam name="Patient" value="">
    </cfpdfsubform>
    </cfpdfform>
    D
    Daverms
    Inspiring
    February 11, 2009
    Yes!.. You can!...

    Refer here for more info,

    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=formsPDF_04.html
    P
    PTOT ConnectAuthor
    Participant
    February 11, 2009
    I have reviewed the link you sent me. What I am still having problems with is the value attribute. What is allowed in the value attribute? When I create the same dropdown with cfselect, I am able to define which query to use and then which column to populate it with. How can I do this with the cfpdfformparam tag? Can you give me an example using the cfpdfformparam tag where the value attribute is a column from an Access/SQL query? Thanks so much for your prompt reply, you have given me hope :)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices