Show/Hide Toolbars

PerfectForms™ Help Guide

This is a list of some useful values that are not form fields but you may find yourself wanting to access in a formula or condition.

 

Form - Stage

The current workflow stage.

Form - Role

The role of the user viewing the form instance.

Form - Instance Name

This is the form instance name as defined in the Form Instance section of the Form Properties.

Form - Instance Number

Each form instance for each form has its own unique Instance Number, which is a sequential number starting at 1 and incrementing by 1. The number is only created once the form instance is submitted by the user. This is to prevent holes in the numbering sequence

Form - Instance ID

Each form instance has its own unique ID, which is a random alphanumeric ID created when the instance is first submitted.

Form - Instances Count

This will show the number of instances that have been submitted for the current form at the time that the current instance was opened.

Form - URL

This will show the URL for the current form instance. This will be a combination of the server address and the unique Instance ID.

Form - Parent Instance Name

This is the form instance name of the current form’s parent instance. This is only relevant if the current form instance was created as a child of another (parent) form instance.

Form - Parent Instance Number

This is the form instance number (unique sequential number) of the current form's parent instance. This is only relevant if the current form instance was created as a child of another (parent) form instance.

Form - Parent Instance ID

This is the form instance ID (unique alphanumeric ID) of the current form's parent instance. This is only relevant if the current form instance was created as a child of another (parent) form instance.

Form - Child Instance Names

If the current form instance has any child instances, the names of these will be listed here.

Form - Child Instance Numbers

If the current form instance has any child instances, the instance numbers of these will be listed here.

Form - Child Instance ID's

If the current form instance has any child instances, the instance ID's of these will be listed here.

Form - Is in Read-Only State

Returns true or 1 if the state of the form is Read-Only and returns false or 0 if the state of the form is not Read-Only. True and false are returned to text input fields, 1 and 0 are returned to numeric input fields. The viewing state of a form instance is set in the advanced section of form properties.

Behavior - Last Command was successful

Returns true if the last behavior was successful and false if an error occurred.

Behavior - Last Command's error code.

Returns the error code if the last behavior was not successful or returns the value of 0 (zero) if the behavior was successful.

Behavior - Last Behavior's Return Value

Often used in conjunction with the Exit command which can provide a value. The value provided by the Exit command can then be used in the next behavior triggered.

Util - Current Time

Returns the current time from the local machine of the person viewing the form instance.

Util - Current Date

Returns the current date from the local machine of the person viewing the form instance.

Util - Server Date

This will show the server date. Use this variable along with the existing functions to obtain other date related variables such as year, month, day etc.

Util - New Line

This inserts a carriage return and line feed, typically into a string of text that will end up in a text field.

User - First Name, Last Name, etc.

These user entries contain personal details of the PerfectForms™ user currently accessing the form. These details are passed from the Personal Details view on the Settings Dashboard.

Gateway – HTTP USER

Identifies the current user if authenticated but not a PerfectForms™ user. Domain user name is returned as special variable in order to identify the authenticated user. Single sign-on gateway must also be installed and inside an Active Directory environment. See also Single Sign-On.

Workflow - Stage "name"

Specific stages may be included in conditions and if the stage name is changed the condition will automatically change.

Note: If a workflow stage is deleted and replaced with another stage bearing the same name, then the links between the stage and existing conditions will be lost.