Show/Hide Toolbars

PerfectForms™ Help Guide

 

Set Table Rows Properties - Action - Advanced

The Main section enables you to select the rows to set when the command runs as well as to specify actions for those rows.

 

Object

[Object Selection]

Click Select to choose the table object whose rows will be set when the command runs.

 

To select the desired object, click the Select button, then navigate to the object you want to choose. (The OK button on the 'Select an Object' dialog will remain disabled until you've specifically chosen a Table object.)

 

Once a selection has been made, the value will be shown in the read-only text box to the left of the Select button.

 


Action

Add Row

Select this radio button to have the Set Table Rows command add a new, empty row to the selected table. If you choose this option, you can then specify where the row should be added in the table. Options include:

 

At Beginning - The row will be added as the first row in the table.

Before Current Row - The row will be added before the form user's currently selected row.

After Current Row - The row will be added after the form user's currently selected row.

At End - The row will be added at the end of the table.

To add multiple rows use the button to open the Formula Composer and add a set value in the 'Text or Number' box,take the value from a 'Field' on the form or use a formula.

NOTE: The maximum number of rows that can be added in this way is 5000.

If there are no rows in the table when this behavior is triggered then use the option to add rows at the beginning or the end only.


Delete Current Row

Select this radio button to have the Set Table Rows command delete the form user's currently selected table row.

 


Ask For Confirmation

If the 'Delete Current Row' radio button is selected, you may choose to select this 'Ask for Confirmation' check box. If selected, the user will be prompted for confirmation before the currently selected row in the table is deleted.

 


Move Current Row To

Select this radio button to move the form user's currently selected table row. Determine where the currently selected table row should be moved to by selecting one of the following options:

 

First Row

Previous Row

Next Row

Last Row


Delete All Rows

Select this radio button to delete all rows in the table when the Set Table Rows command runs.

 


Advanced

Advanced functions are included within the Set Table Rows command to return the following information from a specific column in the table:

 

Contains:

Returns 'true' if the column contains at least one row with the text specified in the 'Text' box, otherwise it returns false.

 

Count:

Returns the number of rows of the selected column that contains the text specified in the 'Text' box.

 

Replace:

Replaces any text in the column matching the 'Text' field with text from the 'Replace' field.

 

Delete:

Deletes any text in the column matching the 'Text' field.

 

Filter:

Filters the table data to return only those rows matching the 'Text' field.

 

 

Typical use:

Use a Simple Branch Command and the condition 'Behavior - Last Command was Successful' after the Set Table Rows command in conjunction with the Contains command.

 

Use the 'Behavior - Last Behavior's Return Value' in conjunction with the Count command.

 

Use a Set Field Command to pass these value into another field in the form.

 

Use * for wildcard in conjunction with the Filter command.

 

*x to return entries ending with x

x* to return entries starting with x

*x* to return entries including x

* to return all entries (To clear filters)

 

Note that the Filter command will not delete rows that do not match the filter but will remove them from view. These rows will remain available if other filters are subsequently applied.

 

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.