This tutorial demonstrates how to setup and connect to an Access 2010 Database using Adobe LiveCycle Forms through an ODBC connection.
Code used:
xfa.sourceSet.DataConnection.first(); (assuming the Data Connection name is “DataConnection”)
Month: December 2011
Check for null value in JavaScript
One of my YouTube subscribers recently posted a question related to “bound” data fields. This reminded me of how data bound fields are often susceptible to being populated with null values if the database is empty. Here is a little function I wrote to remedy this possibility:
function checkForNull(v_String)
{
var v_Space = ” “;
if (v_String == null)
{
return v_Space;
}
else
{
return v_String;
}
}
So, all we are saying here is that if the passed in value (v_String) equals null then return a value of ” ” (one space). If not, then just return whatever non-null value is there. This small function is used to “test” the string values of data that is passed from a database to a bound field.
Signature Field Basics in Adobe LiveCycle ®
Here is a tutorial on the basics of using Signature fields in Adobe LiveCycle. It also covers how to “lock” a form when a digital signature is applied, and how to leave some fields (such as a print or email button) unlocked.
Producing a Random Sample in any Spreadsheet
In this tutorial I demonstrate a simple method for selecting a random sample from a table of data in any spreadsheet that can reference the “RAND()” function (Google Docs, Open Office, Microsoft Excel).
Advanced Master Pages in Adobe LiveCycle ®
Follow up tutorial to Master Page Basics demonstrating more advanced features such as: custom page sizes, header objects that reference form data, and form flow to specific master pages.
Code placed in the ready : layout event of “FORM.#pageSet[0].Page2.txtCustomer” & “FORM.#pageSet[0].Page2.txtSSN” fields of Master Page 2:
this.rawValue = FORM.Main.txtCustomer.rawValue;
Modified code used in the “FORM.#pageSet[0].Page2.txtSSN” field to carry over the SSN formatting from the Main page:
this.rawValue = FORM.Main.txtSSN.formattedValue;