Connection
|
Connection
|
Select from the list of existing connections. If you do not see the connection you need, you may need to click the Refresh  button or exit the Form Designer and create the new connection from the PerfectForms™ Connections Dashboard.
|
Creating PerfectForms™ Connections
|
Action
|
Select from the list of existing connection actions associated with the selected connection. If you do not see the action you need, you may need to click the Refresh button or exit the Form Designer and create the new connection action from the PerfectForms™ Dashboard.
|
Defining Connection Actions
|
Send Parameters
|
Name
|
Displays the name of the field as defined in the action (available from the PerfectForms™ Connections Dashboard).
|
Defining Connection Actions
|
Source
|
The value in this column represents the form field to pass via the send parameter. Click a cell in this column to select the field.
Note: Data passed cannot exceed 250 characters.
|
|
Formula
|
Select this check box to enable formula editing for the selected parameter. Once selected, you can click in the Source column to launch the Formula and Conditions Editor.
This option should be used if the data to pass from the form is not a simple field but an expression.
|
Using the Formula and Condition Editor
|
Return Parameters
|
Name
|
Displays the connection action field that holds returned data (available from the PerfectForms™ Connections Dashboard).
|
Defining Connection Actions
|
Target
|
The value in this column represents the form field that will accept the returned value. Click a cell in this column to select the field.
|
|
Items
|
When specifying a list or drop-down object as the object to return the data to, there are three check boxes available for selection. The options are as follows:
| • | Select the first check box to populate the caption. |
| • | Select the second check box to populate the value. |
| • | Select the third check box to tell the system that for the drop-down object, none of the items in the list should be selected by default. This check box is only enabled after either the first or second check box in the Items column is selected. |
|
|
Misc
|
Show Error Messages
|
Select this check box to have PerfectForms™ show all errors. If you clear this check box, then you will need to manage your own error handling.
You can inspect the error code after the command has run. Check for problems with the connection using a Branch command and inspecting the Special Value Last Command Was Successful and last command's error code.
| • | Generates a general connection error (Error Code 200) |
| • | Returns no data although the connection worked fine (Error Code 201) |
|
Connection Error Handling
|
Maximum Number of Rows
|
Specify the maximum number of rows that can be returned (the system limit is 1000).
|
|
Summary
|
Auto-Summary
|
Auto-summary refers to the text that will be shown on the command in the Behaviors canvas. By default, this check box is selected.
For commands that use a condition or calculation, Auto-Summary will display the formula selected in the Condition Properties. If no condition exists, nothing will be displayed.
If you wish to have other summary text display, clear the Auto-summary check box and type the custom text in the list box below. Your text will be retained if you later decide to enable Auto-summary.
|
|
[Summary Text}
|
This is where manual summary text can be entered when the Auto-summary option is not turned on.
|
|
