Two Live Cycle Designer Questions

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

Form with Table prepared , rows and fields renamed
Form with Table prepared , rows and fields renamed

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

Set Value to Calculated Read Only

In the Script Editor panel choose calculate

In the Script Editor panel, choose Calculate
In the Script Editor panel, choose Calculate

Set the Language to FormCalc

Set language to FormCalc
Set 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.

this=sum(Table1.DataRow[*].Amount[*])

Save and test

Use tab key to move from field to field
Use tab key to move from field to field. This will trigger the recalculation of the total.

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.

Best Wishes

Steven

Acrobat Forms Reading List

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)

FormCentral

Digital Signatures

LiveCycle Designer

Train-A-Scope YouTube Channel Theme for 2014

Welcome

I am Steven Knight and my business is computer training.

I train in SharePoint, Acrobat, Captivate and Office for leading training providers around Australia

This year I am following a theme for most of my YouTube channel content.

That theme is forms.

Why Forms?

End users are increasing looking for tools to enable them to

  • Collect data from internal or external clients efficiently
  • Export that data to Excel
  • That requires no coding
  • And are Low or no cost

I will still have content on other topics with forms being the ongoing theme. Continue reading “Train-A-Scope YouTube Channel Theme for 2014”

Focusing on Forms

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)

Continue reading “Focusing on Forms”

Getting Started on Acrobat and Digital Certificates

A quick post in response to questions on where to start reading on Acrobat and Digital Certificates.

Adobe provide a couple of starting points:

Give me 27 minutes to help you with Tables, Repeating Rows and Formulas in LiveCycle Designer

 Latest Video

Featuring:

  • Flowed and Positioned Sub Forms
  • Dynamic Tables
  • Using drop down lists in formulas
  • Repeating Rows
  • Grand Totals

Additional Resources

I have had a lot of questions recently seeking additional resources regarding FormCalc and Javascript.

Please see also my tour of Forms Resources for more links

FormCalc

Javascript and PDF

General PDF resources

http://www.planetpdf.com/

Regards

Steven

 

Resources to help with Acrobat Forms

Resources mentioned in the presentation:

  Continue reading “Resources to help with Acrobat Forms”

Adding Rows and Showing Optional or Alternative fields in LiveCycle Designer

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.

Notes:
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….

Creating PDF from Word Series

My Creating PDF from Word tutorials from my YouTube channel are now gathered together in one convenient PlayList.

Presentation at B.A.U.G. Brisbane Adobe User Group – Acrobat XI Detailed Overview

Last week, I had a chance to attend a B.A.U.G. Brisbane Adobe User Group meeting where Richard Turner-Jones (or here) walked us through the new and updated features of Acrobat XI.

The good news is that it is an enhanced version of Acrobat X.

The features that stood out for me were

  • integration with Echo Sign for digital signing
  • shift to Form Central for forms (LiveCycle Designer is now available as a separate product)
  • improved SharePoint integration
  • custom tool panels
  • enhanced export options

Motivated by Richard’s presentation, I have just created a virtual machine with Acrobat XI trial to explore the possibilities.

I’d recommend the user group to all levels of Adobe product users (that this was my first user group meeting for over 12 months is not a reflection on the quality of topics covered). There is a mailing list at the  B.A.U.G. Brisbane Adobe User Group site

Regards

Steven

Document Signing, Acrobat and Alternatives

This topic came up on a recent Acrobat session, raised by people discussing cutting and pasting signatures into documents to simulate signing. Which led to a discussion on digital signatures and Acrobat and a run through of the process (using a self signed certificate).

So I thought I would dig up some light reading on how to get a proper digital certificate for document signing. Continue reading “Document Signing, Acrobat and Alternatives”

Not Happy Adobe! Activation Issues

About 10 days ago I moved to the Adobe E-Learning Suite 2.5 using the subscription model. After carefully reviewing the licence agreement, I determined I would be able install on my main desktop PC and the laptop provided both were not to used at once (there is only one of me- so this is unlikely)

So I signed up, downloaded and installed on PC and laptop.

All good and ready for me to do a couple of projects with Dreamweaver and Captivate and to prepare for the Acrobat X and Captivate 5.5 exams.

Except now I can’t use any of it on either PC. Continue reading “Not Happy Adobe! Activation Issues”

Acrobat X – How do I add an Image to an existing PDF?

Folks

This is a short silent video which illustrates adding an image to an existing PDF. Continue reading “Acrobat X – How do I add an Image to an existing PDF?”