After you click the Binding property button in the field where you want your result to appear, you add your functionality in the Binding Editor. Besides clicking and applying functions, you can also write your own calculations and conditional statements.
[screen capture: binding window]
- In the Binding Editor window, click the Wildcards/Fields button to see a list of fields in your form.
- Click to choose one of your fields. Its name appears in the Binding Editor window.
- Select the field.
- Click Functions and choose a function to apply.
For example, you might be using the Country dropdown field which produces a two character country code. If you wanted staff to see the full name of the country when they review applications, you would select the Country dropdown field and apply the function of "countryabrtofull" which converts an abbreviation to the full name and displays it in this field.
These binding functions can be applied to format your data. After you choose a function, an additional screen appears to make further selections.
|dateFormat||Format a date to the format specified, for example mm/dd/yy|
|timeFormat||Choose a time format mask such as hh:mm:ss|
|dateAdd||Add a specified amount of time to the date|
|getYearsOld||Display the number of years based on a supplied date|
|getDaysInRange||Return the number of days between two supplied dates|
|emptyValue||Specify a value to return if the given field is empty|
|Capitalize||Capitalize the first letter of a string|
|countryabrtofull||Convert a two digit country code to the full country name|
|uCase||Convert to upper case|
|lCase||Convert to lower case|
|ellipsis||Trim a long text string after a specified number of characters; defaultl is 30|
|plural||Add an s to a word if the given number is greater than 1|
|listFormat||Format a comma delimited list of options in either a bulleted or numbered list|
|paragraphFormat||Format user entered text to maintain line breaks|
|htmleditformat||Format a string using html entity characters|
|fileLink||Link to an uploaded file. It formats the field to create an anchor tag that when clicked will link to the file. Note: this function is only for use after form submission in autoresponders, emails, PDFs, and triggers.|
|showImage||Format an uploaded image for display, showing a preview. Note: this function is only for use after form submission.|
|length||Return the numeric length of a string|
|getsubstring||Extract characters from a string; default start and end positions are 1 and 5|
|numberformat||Format a number using a custom mask, for example 0,000|
|currencyformat||Format a number as currency; choose from Dollar, GBP, or Euro|
|round||Round a number to the given decimal; default is 2 decimal points|
|RoundUp||Round a number up|
|average||Choose a number of fields and calculate the average|
|exponent||Calculate the exponent with the selected field being the base value|
|min||Return the minimum numeric value based on a selection of fields|
|max||Return the maximum numeric value based on a selection of fields|
|median||Calculate the median value based on a selection of fields|
|mode||Calculate the mode based on a selection of fields|
|variance||Calculate the variance based on a selection of fields|
|standardDeviation||Calculate the standard deviation based on a selection of fields|
|square||Calculate the square root of a given value|
These are the functions you can apply to your fields. After you choose a function, an additional screen appears to make further selections.
|dateDiff||Returns the difference between two dates in the units specified (from seconds to years)|
|isDateAfter||Returns True if the given date is after another date|
|isDateBefore||Returns True if the given date is before another date|
|isDateBetween||Returns True if the given date falls between two given dates|
|isInList||Returns True if the given value is in the list of values|
|startsWith||Returns True if the given value starts with the specified string|
|endsWith||Returns True if the given value ends with the specified string|
|contains||Returns True if the given value contains the supplied string anywhere within it|
|addSelected||For use in checkboxes, radio buttons, and dropdown list fields; add all an option's bind values and return a numeric value|