Dynamically populating dropdown lists in a pdf form from a datasource

[PTOT Connect]

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

[Daverms]

Yes!.. You can!...

Refer here for more info,

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=formsPDF_04.html

[PTOT Connect]

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 🙂

[Daverms]

Hi DerrickDel,

Can you please post your code here?...

[PTOT Connect]

<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>

[Daverms]

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..

[PTOT Connect]

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.

[PTOT Connect]

Not possible eh?

[Lithcause]

you can try doing a cfdocument format="pdf" and try making that a interactive form... just a thought

[Guest]

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

Enjoy,

Murat

www.muratkuru.com.tr