since ‎18-01-2015
‎10-12-2019
scottc79002886
Level 1
Issue with populating field from database scottc79002886 - Adobe LiveCycle
I am designing a pdf and pulling information from a database into a pdf field. I have two tables in the database and two tables on the pdf. I set one field as text and one as value. When I do this everything works great.However, I need the initial choice to fill in two boxes not one.I created a query in access Combo : [Subject] & ":" & [Intervention]then placed the following code into my pdfvar boundValue = this.boundItem(xfa.event.change);var valuesArray = boundValue.split(":");Subject.rawValue...
81
Views
0
Likes
0
Answers and Comments
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
I found another reply from you on an old post about something similar and I tried it and it worked wonderfully. Thank you so much.
19
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
Bruce, Any advice. I am beating my head against the wall trying to figure this out. I have spent about 7 hours on it with no luck.
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
Here is the databaseWhat I would like to do is be able to select a client (Jane Doe for example) from the dropdown and have the client ID and Counselor fields populate automatically. I used your instructions for my original problem and it worked great. I am hoping that you can walk me through this one as well.
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
I have one final question for you BR001. Is it possible to use a drop down to populate two fields?Example I select Joe smithand box 1 populates with abcdefgand box 2 populates with klmnop
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
You are awesome thank you so much
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
Thank you so much you are right I forgot to bind the value it is working great now. I have one more question.At the top of the form is Client Name field as a drop down which is bound to item textI want the item text to also display in a text field at the bottom of the formI tried but it didn't workName.rawText=this.boundItem(xfa.event.change);
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
so now I am more confused then ever. Is it even possible to do what I am trying to?
18
Views
0
Likes
0
Answers
Re: Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
That works to populate the clientID with the name but that is not what I am trying to do. Here is the databaseLets assume I pick the name Sam Smith from the drop down I want it to automatically add his userid to that field. If I select Mary from the drop down I want it to populate the clientid with her number
19
Views
0
Likes
0
Answers
Connecting a drop down box and text field scottc79002886 - Adobe LiveCycle
I am new to livecycle and have only been using it for 2 days. I have be so grateful for all the amazing expert help I have found here. I believe my first form is almost complete. I am having a problem with one last issue. I created a database with two fields. field 1 is Name and displays a name IE John Doe, Field 2 is ID and contains a unique string such as 12345678. I created a drop down box for the Name and it works great, I can see all the names in the database. I then created a text field wh...
446
Views
0
Likes
14
Answers and Comments
Need help with ODBC Connections in Adobe LiveCycle scottc79002886 - Adobe LiveCycle
Hello I have designed a form for my company that uses a database to populate a few fields on the form. I am unable to get it to work correctly without acrobat pro installed. I am using using xfa.sourceSet.DataConnection but as I said it will only work with acrobat pro installed. We do not have acrobat pro on any of the machines at my company and installing it is not an option is there any other way to accompish this?
325
Views
0
Likes
1
Answers and Comments