• $ROW$
• Please Select Name Phone / Fax Email Street Address City Postal / Zip State / Province / County Country Latitude / Longitude Date Fixed Number of Words Random Number of Words Auto-increment Alphanumeric Number Range Custom List Tree (parent row ID) GUID Composite Constant
•  
•  
•  

This data type randomly generates human names (mostly Western) according to the format you specify. You can specify multiple formats by separating them with the pipe (|) character. The following strings will be converted to their random name equivalent:

Whatever text you enter into the options text field will be used to generate telephone numbers. Capital X's will be converted to a random number between 1 and 9; lower-case x's will be converted to a random number between 0 and 9.

Select one of the values in the example dropdown for some ideas. Remember: anything other than the X and x character are left unconverted.

As with many of the other data types, to generate phone numbers in multiple format separate them with a pipe | character.

Generates a random zip or postal code. For greater control, use the alpha-numeric data type option.

Generates random Canadian provinces, states, territories or counties, based on the options you select. The Full Name and Abbreviation sub-options determine whether the output will contain the full string (e.g. "British Columbia") or its abbreviation (e.g. "BC"). For UK counties, the abbreviation is the standard 3-character Chapman code.

This data type generates a random latitude and/or longitude. If both are selected, it displays both separated by a comma.

This data type randomly generates a date between the dates specified, and allows for unique formatting of the result. See the table below for a list of viable formatting rules (these are cribbed from the standard PHP date() formatting options). Take a look at the example dropdown to select from existing formatting options.

This option generates a fixed number of random words, pulled from the standard lorem ipsum latin text.

This option generates a random number of words - the total number within the range that you specify (inclusive). As with the Fixed number option, the words are pulled the standard lorem ipsum latin text.

Generates a column that contains a unique number on each row, incrementing by whatever value you enter. This option can be helpful for inserting the data into a database field with an auto-increment primary key.

The optional placeholder string lets you embed the generated increment value within a string, via the {$INCR} placeholder. For example:

• ROW-{$INCR} -> ROW-1, ROW-2, ROW-3, ROW-4, ...
• {$INCR}F -> 1F, 2F, 3F, 4F, ...

This data type lets you generate random alpha-numeric strings. The following table contains the character legend for this field. Any other characters you enter into this field will appear unescaped.

This randomly generates a number between the values you specify. Both fields allow you to enter negative numbers.

Enter a list of items, separated by a pipe | character. Then select whether you want Exactly X number of items, or At most X items from the list. Multiple items are returned in a comma-delimited list in the results.

This data type lets you generate tree-like data in which every row is a child of another row - except the very first row, which is the trunk of the tree. This data type must be used in conjunction with the Auto-Increment data type: that ensures that every row has a unique numeric value, which this data type uses to reference the parent rows.

The options let you specify which of your form fields is the appropriate auto-increment field and the maximum number of children a node may have.

Generates a unique, random GUID (globally unique identifier) of the form: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX, where X is any hexidecimal digit).

The Composite data type lets you combine the data from any other row or rows, and manipulate it, change it, combine the information and more. The content should be entered in the Smarty templating language.

To output the value from any row, just use the placeholders {$ROW1}, {$ROW2}, etc. You cannot refer to the current row - that would either melt the server and/or make the universe implode.

Here are a few examples:

• Display a value from row 6: {$ROW6}
• Assuming row 1 and row 2 contain random numbers, the following are examples of some simple math:
  • {$ROW2-$ROW1} - subtraction
  • {$ROW2*$ROW1} - multiplication
  • {$ROW2/$ROW1} - division
• If row 1 contains the number 5, display "N/A", otherwise just display the number. {if $ROW1 == 5}N/A{else}{$ROW1}{/if}

Please see the Smarty website for more information on the syntax.

This data type lets you generate a column of data that has repeating values from row to row. Here's a couple of examples to give you an idea of how this works.

• If you'd like to provide the value "1" for every row, you can enter "1" in the Value(s) field and any value (>0) in the Loop Count field.
• If you'd like to have 100 rows of the string "Male" followed by 100 rows of the string "Female" and repeat, you can enter "100" in the Loop Count field and "Male|Female" in the Value(s) field.
• If you'd like 5 rows of 1 through 10, enter "5" for the Loop Count field, and "1|2|3|4|5|6|7|8|9|10" in the Value(s) field.

Try tinkering around with it. You'll get the idea.