Q. Can I total values in a table, e.g. one amount in a number field per row?
To cover a related question, this approach should work for check boxes in a table which gave been allocated values
Assuming you have a table with repeating rows in place
You then need to open the script editor panel via the Window menu.
Select the field that will act as the grand total – in my example, this is called Total.
In the Object panel set value to Calculated Read Only
Set Value to Calculated Read Only
In the Script Editor panel choose calculate
Set the Language to FormCalc
Then in the panel add the following code – Use your table name, row name and field name. Read [*] as saying “for each instance of the object” “This” refers to the currently selected object, in this case the grand total field.
Save and test
Q. Can I auto-number my rows?
Yes you can, but you will need to be comfortable with adding some code. Please read this very good article here “Numbering rows in a LiveCycle Designer table or repeating subform” which also has a sample file.
I’d like to do a video on this, but due to time limitations, I wont make promises I can’t keep.
I want to cut down on paper forms, reduce errors and speed up processing – Where do I start?
Option 1: Acrobat Forms
All you you need is Adobe Acrobat Professional, which you may already have. With it you can:
- add form fields to existing forms (converted to pdf from MS Word or scanned)
- do basic calculations
- distribute either individually via email or a web site or send to a group of people at one time
- receive completed forms via email
Option 2: Adobe LiveCycle Designer
Very powerful, deep, deep tool which can integrate with Adobe server side products
- Developer type interface can be daunting for non programmers (if you have used tools like Photoshop, it wont worry you too much)
- Allows development of forms with optional sections that are only displayed to the user if needed – so a form can vary in length
- Allows saving of sets of related fields eg “Customer Information” for drag and drop reuse on later forms
- Allows adding code eg for complex calculations (but there is a interactions “wizard” like feature to help the non coder)
Option3: Adobe FormCentral
This option gives a lot of functionality to parallel the client side tools of LiveCycle Designer, but aimed more at a user with good PC skills rather than a coder/developer.
There are templates to explore and free basic trial version.
Resources to Explore
General Acrobat Forms
(mixture of Acrobat Forms and FormCentral)
- Create new PDF and web forms: start here and here:
- Adobe TV: Acrobat
- Forms, E-signatures etc
- Tutorials: Create and analyse forms
- Adobe TV: LiveCycle Designer http://tv.adobe.com/product/livecycle/
I needed to find a theme to explore, so driven by:
- cumbersome experience handling forms from insurance agents, recruiters and clients
- need to make information gathering more efficient in my own business
- looking for a theme to tie together study I have to do in a meaningful way!
- a theme for a series of tutorials to be created using my snazzy new Captivate template, that people will find useful.
I found a direction, so the theme is:
Forms, Data Collection and Processing
Across a range of tools explore the following aspects
- Ability to create forms using no code or as little code as possible.
- Adding fields
- Branding and Formatting
- Data Validation
- Controlling navigation (e.g. jump ahead based on a choice)
- Distribution and Security
- End User Experience
- Data collection options, Analysis and Exporting (eg to Excel)
I came across the solution at the article: Australian Spell Check in Adobe LiveCycle Designer at Mark Szulc’s Blog some time back. I had implemented the fix and then not having upgraded for a while had forgotten about the issue…
The basic problem is that there isn’t a dictionary for the spell check to use when the Australian locale is specified.
Using the UK locale gives the right dictionary but gives the pound sterling character for currency instead of the dollar sign.
However as I find myself doing more LiveCycle Designer training, the issue is coming up again.
Adobe LiveCycle Designer ES2 and earlier
- Read the Article
- Search for the file “SpellCheckLocaleMapping.xml” on your system (the path will differ from the article)
- when you find the file you may need admin rights to edit it
- As suggested in the article remove the comments and Save
The effect of the fix is to use the Canadian dictionary when the Australian locale is specified for a form.
I have tried this on an ES2 install recently and it works.
Adobe LiveCycle Designer ES4
The fix from the article doesn’t appear to work for ES4. (Have also tried it without success myself)
However I can suggest a work around
- Make a blank new A4 portrait form (you can repeat for landscape)
- File, Form Properties, Defaults, Set Locale to Canada, OK
- Save the form as a Live Cycle Designer format (*.tds) into a suitable folder
- Close the form
- Open, set files of type to Live Cycle Designer format (*.tds)
- From the resulting Dialog choose Copy this template into the Template Manager
When you need a new form: File, New, From a template, Other, then select your template
The Canadian locale will give you close to Australian English spell check, the “$” and DD/MM/YYYY dates
If anyone finds a catch with this choice please let me know.
- Flowed and Positioned Sub Forms
- Dynamic Tables
- Using drop down lists in formulas
- Repeating Rows
- Grand Totals
Please see also my tour of Forms Resources for more links
- How to Create Scripts for Online Forms with Adobe LiveCycle Designer
- FormCalc User Reference (116 page PDF)
- XFA-FormCalc Technical Reference at W3.org
General PDF resources
This Tutorial covers creating formulas in Live Cycle Designer forms where one or more fields is read only and contains a fixed value eg a price.
How to redisplay information already entered in a LiveCycle Designer Form. Three methods are demonstrated in this short tutorial.
Part 1. Using a button to add rows to a table – without writing code
Part 2. Using check-boxes to control the display of hidden fields on the form
A very quickly prepared tutorial to answer some Adobe LiveCycle questions.
i) volume levels will vary due to Windows 8/Captivate issues, Please adjust volume to suit
ii) I did this without notes or a script – you will hear the gears turning in my head as I roughly narrate this (the “umm” and “arr” ratio is too high). A scripted narration is always better! In this case it was a false economy not to do one….