Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED
Is lookup dialog possiable with LC?
1 Accepted Solution
Correct answer by
Hi Bill,
It sounds like you are doing a lot of processing of the data. Are you using a standard dropdown from the Stnadard Object library or a data dropdown from the Custom Object library?
I would recommend the data dropdown, as it comes with data connection script built-in. All you need to do is hook it up to a data connection and tell it what tables/columns to use. The three <value> items is all that you have to change.
I know that the script here is in the initialize event, but just run with that initially. We have used several data dropdowns in forms and have not had too bad a performance.
Give this a try first and if performance is still an issue, try moving this script to the preOpen event. I would strongly recommend Stefan Cameron's blog and in particular:
Connecting a Form to a Database - Stefan Cameron on Forms
Selecting Specific Database Records - Stefan Cameron on Forms
Databases: Inserting, Updating and Deleting Records - Stefan ...
Displaying All Records from an ODBC Data Connection - Stefan ...
There are many more, but these should help.
When I said you could build the dialog natively, I meant Adobe have exposed this method and you can use javascript to build the dialog from scratch. It can be done, but I have done it! If you do a search through the Acrobat (not LC Designer) reference documents for execDialog, you will see the methods that are available.
I use AcroDialog from Windjack Solutions. It is an Acrobat plugin that gives you a drag and drop approach to creating dialogs. You can then copy the javascript that AcroDialog builds for you and paste it into LC Designer, for example into a button event. Then you stitch in the logic, eg where user data inputting into the dialog ends up in a form field or some other action.
Hope that helps,,
Niall
Hi Bill,
No problem!
I use AcroDialog from Windjack Solutions (http://www.windjack.com) to generate dialogs. You can pass data from the form to the dialog and back again. This is relatively straightforward.
I have not create a dialog that connects to a database, however on http://www.pdfscripting.com (part of Windjack Solutions) they have a sample dialog that connects to a database. I can't share that dialog, but here is a screenshot.
Maybe if you contact Windjack directly.
Good luck,
Niall
Hi Paul,
Checked that the OLEDB will available if I launch Designer outside of workbench.
I also got a reply from Adobe support, they said that launching designer from workbench do not have OLEDB is as design, because you won't want to create DSN for every client.
I think they mean I will need to create the DSN for every client who use the from, because OLEDB will connect to the DB directly at client level.
I just have no idea why they try to make decision on what I want 
.
But anyway, thanks for the suggestion, because I am about to try install the standalone designer to see if it will get the OLEDB option, your suggestion saved me a lot of times.
Regards
Bill
