PerfectApps ® Help Guide

The setting section enables you to select the table, perform actions on rows in the table and to use the advanced options.

Set Table Rows Settings

Object

Details

Additional Information

[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 app user's currently selected row.

•After Current Row - The row will be added after the app 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 app 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 app 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 app 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

Select this option to activate the advanced table manipulation features.

Column

Select the column in the table to perform the function on.

Function

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 app.

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)

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.

Text

Click the button to open the formula editor to select the text used in conjunction with the functions.

Replace

Click the button to open the formula editor to select the text used in conjunction with the Replace function.

The summary section includes the option to override an automatically generated summary with your own comments.

Object

Details

Auto-summary

This option is selected by default, the system will automatically generate a summary that is show in the lower half of the object based on selections made.

Un-check this box if you want to add your own text instead.