since ‎31-07-2006
‎10-12-2019
gkaiseril
Level 5
Re: Excel navigation
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
There is also a LiveCycle Designer tip for doing a DB lookup to populate a drop down list which is then used to lookup a selected record and populate 4 fields.http://partners.adobe.com/public/developer/en/livecycle/lc_designer_db_lookup_tip.pdf

Views

174

Likes

0

Replies

0
Re: Excel navigation
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
You have to use Acrobat JavaScript's "Statement" object to execute the SQL quires.Have you looked at LiveCycle's Developer Center's examples:http://www.adobe.com/devnet/livecycle/designer_scripting_samples.htmlScroll down to the "working with data sources"

Views

174

Likes

0

Replies

0
Re: Two Questions from a New User: Printing and Page Number
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
To print 2 copies you need to access the script for the "Print" button object and duplicate the line of code just below the present line of code.For the second item, you can use the systems JavaScript date and time object to get a unique number down to the millisecond.var oDateTime = new Date(); // get the date/time object$.rawValue = oDateTime.valueOf(); // set field value equal to the value of the date/time object.

Views

92

Likes

0

Replies

0
Re: Date Manipulation
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
For a rough approximation, divide by 365.25.For the whole shooting match in AcroForms JavaScript:function DateDiff(oEndDate, oStartDate) {/*Purpose: compute the years, months and days that have elapsed between the passed start and end dates.Inputs: oEndDate - JavaScript date object for the end dateoStartDate - JavaScript date object for the start dateReturns: array containing the years, months and days that have elapsed.Notes: the JavaScript date/time object is used so the functiondoes not need ...

Views

153

Likes

0

Replies

0
Re: Change Print Button to print only 2nd page of document
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
You can not modify the Toolbar's Print button nor can you modify the "File => Print" option, but you can modify a print Button on your form. The exact code will depend on the application you used to create the form.AcroForms:this.print({bUI: false, nStart: 1, nEnd: 1});LiveCycle Designer you would need to modify the default print button action:xfa.host.print(0, "1", "1", 0, 1, 0, 0, 0);

Views

119

Likes

0

Replies

0
Re: Determining object type
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
What about the JavaScirpt 'typeof' special operator or the '.type' of field property? But since one can not tell the exact format of a text field since this can be dynamic, that is changed on the fly during another scripts processing. One could always examine the "formattedValue" and try to sort out the fields formatting.The real solution is simply documentation or the use of PFN, Polish Field Notation.

Views

74

Likes

0

Replies

0
Re: margins
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Only the scaling of the PDF to the printer in the Printer UI. Acrobat has very few and very limited authoring abilities. You might get better help in one of the Acrobat forums and the LC Designer forum.

Views

85

Likes

0

Replies

0
Re: Can Designer Make forms that Calculate..Like Exell?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
For the use of controlled field names or loops see: http://forms.stefcameron.com/category/formcalc/

Views

159

Likes

0

Replies

0
Re: Need more info on LiveCycle Designer? Check out these sites...
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Please only post links to other helpful web sites in this anchored item.

Views

847

Likes

0

Replies

0
Re: why does the email button attach xml instead of pdf?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Default action of the application. If you want something different, you will have to either edit the button actions or create a button and provide the appropriate actions.You will probably need to download some of the LiveCycle Designer documentation from Adobe's support.

Views

106

Likes

0

Replies

0
Re: Dirive "date of birth" when ID number is entered
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Is the date of birth part of the ID like in the Florida, Illinois and Wisconsin Drivers Licenses or are the DOBs stored in a tab delineated text file or an SQL database. If in the ID just do the math, if it is in any text file LC Designer can not do it - look at Acrobat Forms, and if in an SQL database, including MS Access and MS Excel Named areas, you will have to create a data connection and then execute SQL commands to retrieve the data by the ID.

Views

106

Likes

0

Replies

0
Re: Simple
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Access 97 on can use SQL.Have you looked at "LiveCycle Designer Providing Interactive DataBase Lookup From Forms"?It has an Access database and sample form attached to the PDF.http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf

Views

264

Likes

0

Replies

0
Re: Submit by Email function
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Can you make an email group and use that for the "to" recipient?

Views

84

Likes

0

Replies

0
Re: Concatenate Field Values?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
If you have subforms will have to provide the full hierarchy object, object name and property for the subform field you need to access.

Views

291

Likes

0

Replies

0
Re: Converting Livecycle form to insert into previous pdf form doc
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Two completely different animals. LiveCycle Designer is an XML, eXtended Markup Language, document with minimal additional code to open as a PDF document but it is not a true PDF file, as a result one can not combine the 2 PDFs. This is one of the big reasons one must determine the requirements of forms being designed and which program will support the requirements best before creating the forms. One could print the LiveCycle Designer form to the Acrobat PDF printer and then recreate the form fi...

Views

487

Likes

0

Replies

0
Re: Database connection
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
A simple look up from a data connection see Stephen Cameron's "Selecting Specific Database Records", http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/ , for an example. There is also an example in the LiveCycle Designer Center, http://www.adobe.com/devnet/livecycle/designing_forms.html , "Providing interactive database lookup from forms" (PDF, 612k)Learn how to use Adobe LiveCycle Designer 7.0 to write data to and retrieve information from databases.

Views

101

Likes

0

Replies

0
Re: Simple
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Have you looked at the samples available in the LiveCycle Developer's Center?http://www.adobe.com/devnet/livecycle/designer_scripting_samples.htmlScroll down to the setion "Working with data sources and schemas" and there is the "Sample: Displaying specific database records on your form" (ZIP, 174K) Learn how to use LiveCycle Designer to filter records in a database and populate a form with the resulting data. Developed by Stefan Cameron (Jan. 22, 2007).You also might try Stefan Cameron's Blog, ...

Views

264

Likes

0

Replies

0
Re: Remote field
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
The easiest way is to put the price of the items in as the export value option for the item in the combo box, you can then access that value to set the price field.

Views

150

Likes

0

Replies

0
Re: Create A Field Template?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Have you looked in 'Help' for adding fields to the "Custom" tab in the Library palette?

Views

96

Likes

0

Replies

0
Re: Concatenate Field Values?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
LivCycle Designer has the built-in FormCalc function of "concat(s1 [,s2 ...])" to concatenate strings and JavaScript uses the "+" operator to concatenate strings.The 'switch()' statement is only available in JavaScript in LiveCycle Designer.One could use the following script in the "AboveAverage" field// array of field names used in the evaluationvar aFields = new Array(["Attendance", "Promptness", "Flexibility", ...]); // loop through the fieldsfor (i = 0; i < aFields.length; i++){switch (true)...

Views

291

Likes

0

Replies

0
Re: Concatenate Field Values?
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
What is wrong with processing the criteria as each field is completed?The first field would clear the fields on the second page and then figure if the current field should update any field on the second page. You would need to use the "concat()" funcition to combine the value of the second page field with the current field being tested.

Views

291

Likes

0

Replies

0
Re: Remote field
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
LiveCycle Designer has "global" fields that should be able to do this. See the "Scripting" help for more information.

Views

150

Likes

0

Replies

0
Re: Simple
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
At the point you you want to process the results of the all the selections or possibly depending on how you design your forms, yes. So, I would use JavaScript throughout. What JavaScript objects and methods you can use will depend whether you are using Acrobat forms or LiveCycle Designer. And since you might be populating the drop down boxes with JavaScript, I would use Acrobat forms and not LiveCycle Designer.

Views

264

Likes

0

Replies

0
Re: FormCalc question: How to count true/false answers
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
For the "True" number field you can the following calculation event":var Tsum = 0 // zero accumulatorfor i = 0 upto 24 step 1 do // loop through the fields if (Lower(True_or_False[i]) eq "true") then // if answer for occurrence i is true Tsum = Tsum + 1 // then add 1 endif endforTsum // post result

Views

188

Likes

0

Replies

0
Re: LiveCycle Designer 8 Adding Cells
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Have you tried:Sum(A[1], A[2])

Views

80

Likes

0

Replies

0
Re: Customizing PDF: Bookmarks, Nav Panes, hyperlinks...
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
You might get a better response in the Windows and Macintosh Acrobat forums, this if for LiveCycle Designer which is used to design forms.Most companies add bookmarks to help the end user navigate a PDF file or form. The degree of complexity and inter connectivity. should be based on the requirements of the end user. I have documents with no bookmarks, some with only internal, some with links to external PDF files on a server, some with links to other web sites, and others with any combination l...

Views

105

Likes

0

Replies

0
Re: How do I create a web link??
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
In Acrobat Standard and Professional there is a "Link Tool" that can be used to create links by drawing a link box around the object you want to appear under the link box. You will be provided a pop up window offering you the choice of the various types of link you can create.The "Link Tool" is on the "Advance Editing" tool bar. More information is available in the "Complete Help" under the menu bar "Help" option.

Views

75

Likes

0

Replies

0
Re: Calculation help needed
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
You have to use the equality operator, "eq" or "==", for testing in a logical expression and you have to test either the "rawValue" or "formattedValue" property of the field.

Views

92

Likes

0

Replies

0
Re: Not Print "Print Form" Button
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
Set the field's visibility to screen and no print.

Views

80

Likes

0

Replies

0
Re: Populate several text fields with one entry
Avatar

gkaiseril

gkaiseril
- Adobe LiveCycle
I would suggest using the zero based page numbering scheme for pages in variable names. This means the page would be zero. With this method one need only get the JavaScipt page number to programatically build the field name.

Views

79

Likes

0

Replies

0
Likes given to