Skip navigation
DerrickDel
DerrickDel Calculating status...
Currently Being Moderated

Dynamically populating dropdown lists in a pdf form from a datasource

Feb 10, 2009 11:35 PM

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
5953 Views   9 Replies   Latest reply: adobeMurat, Aug 5, 2010 1:08 AM
 
Replies
  • Daverms
    Currently Being Moderated
    1. Daverms,
    Feb 11, 2009 1:53 AM   in reply to DerrickDel
    Report
    Yes!.. You can!...

    Refer here for more info,

    http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=form sPDF_04.html
     
    |
    Mark as:
  • DerrickDel
    Currently Being Moderated
    2. DerrickDel,
    Feb 11, 2009 7:35 AM   in reply to Daverms
    Report
    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 :)
     
    |
    Mark as:
  • Daverms
    Currently Being Moderated
    3. Daverms,
    Feb 16, 2009 11:01 PM   in reply to DerrickDel
    Report
    Hi DerrickDel,

    Can you please post your code here?...



     
    |
    Mark as:
  • DerrickDel
    Currently Being Moderated
    4. DerrickDel,
    Feb 16, 2009 11:28 PM   in reply to Daverms
    Report
    <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>
     
    |
    Mark as:
  • Daverms
    Currently Being Moderated
    5. Daverms,
    Feb 17, 2009 3:28 AM   in reply to DerrickDel
    Report
    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..

     
    |
    Mark as:
  • DerrickDel
    Currently Being Moderated
    6. DerrickDel,
    Feb 17, 2009 6:45 AM   in reply to Daverms
    Report
    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.
     
    |
    Mark as:
  • DerrickDel
    Currently Being Moderated
    7. DerrickDel,
    Mar 1, 2009 11:11 PM   in reply to DerrickDel
    Report
    Not possible eh?
     
    |
    Mark as:
  • Lithcause
    Currently Being Moderated
    8. Lithcause,
    Mar 20, 2009 10:39 AM   in reply to DerrickDel
    Report
    you can try doing a cfdocument format="pdf" and try making that a interactive form... just a thought
     
    |
    Mark as:
  • adobeMurat
    Currently Being Moderated
    9. adobeMurat,
    Aug 5, 2010 1:08 AM   in reply to DerrickDel
    Report

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

     

    Enjoy,

     

    Murat

     

    www.muratkuru.com.tr

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points