Split String
Split String is an advanced function used for splitting a string into its substrings based on a given delimiter/regular expression. It returns an array of strings after splitting an input string ...
05
April, 2018
03
January, 2018
Rename to Unique
To rename a file to a unique name, use the advanced function “Rename to Unique”. The function works by appending an underscore and the timestamp to the end of the filename, before the ...
12
December, 2017
SQL Lookup
The purpose of an SQL Lookup is to return additional data to an eFORMz project based upon a value in a data file. Normally this value is an indexed item to a table in a database. Step One: ...
22
November, 2017
Choose One Of
The ‘Choose One Of’ function can be used to choose a specific instance from an array by index or by matching against a parallel occurring variable. This function is particularly ...
22
September, 2017
Set Value from a Keyed Declared Constant
For examples on how to implement Declared Constants, consult the following: Declared Constants for Production vs. Dev/Sandbox Accounts A Keyed Declared Constant from an eFORMzCfg_User.xml file ...
21
September, 2017
Set Value from a Declared Constant
For examples on how to implement Declared Constants, consult the following: Declared Constants for Production vs. Dev/Sandbox Accounts A Declared Constant from an eFORMzCfg_User.xml file provides ...
16
March, 2017
Number to Dollars Function
As of eFORMz version 11.08, there is a “Number to Dollars” function which converts a decimal amount to a textual amount. There are two formats. The “Decimal Cents” ...
29
August, 2016
Breaking up a variable with city, state, and zip
You might have a difficult time breaking up a city, state, and zip code into three variables if they are on a single line because city names have variable lengths. This post shows an effective ...
09
June, 2016
Parse Date Function
The Parse Date function parses text representing a date or timestamp into a Julian timestamp that shows the number of milliseconds since 1/1/1970. The Date format field specifies the format of ...
06
May, 2016
eFORMz Table Lookup
Table lookup is a simple way to get one value from a row of a relational database. If you require multiple values, use SQL Lookup. In this scenario, you have invoices that eFORMz makes into PDF ...