Actions

Specify actions to take when a button is clicked.  See Actions for details.

Redirect

Configure page redirection action to take when button is clicked.  See Redirect for details.

Send email

Configure email(s) to send when button is clicked.  See Send Email for details.

Add row to

Add a new record to the database.  Processing does not wait until a final “Submit” or “OK” button is clicked.

Apply search and filter to

Applies the current filtering criteria, including a search, to the control.  This operation is normally used for the “Go” button in a search panel or a dropdown filter.  The search term is entered into a separate text box field.

Custom

An application-defined custom command is executed when the button is clicked.  When clicked, the button will emit an event by this name, which can be intercepted in a code extension to your application and processed.  See Calling a custom function when a button is clicked for details.

Delete current record

In Show Record panels, the selected record is deleted from the database immediately.  Processing does not wait until a final “Submit” or “OK” button is clicked.

In Edit Record panels, the selected record is removed from the control so that it is no longer displayed.  The record is deleted from the database and the transaction committed only after a final “Save”, “Submit” or “OK” button is clicked.

Note:  The ‘Delete current record’ command will only delete the designated record.  It will not delete related records that refer to the deleted record.  See Deleting related records for details.

Delete selected row from

In Table Report panels, the selected record(s) are deleted from the database immediately.  Processing does not wait until a final “Submit” or “OK” button is clicked.

In Edit Table panels, the selected record(s) are removed from the control so that they are no longer displayed.  The record(s) are physically deleted from the database and the transaction committed only after a final “Save”, “Submit” or “OK” button is clicked.

Note:  The ‘Delete selected row from’ command will only delete the designated record(s).  It will not delete related records that refer to the deleted record(s).  See Deleting related records for details.

Export data to PDF from

Create a PDF report using data from the associated table.  A file selection dialog is displayed when the button is clicked, prompting the application user for a file name.

Export data to Excel from

Create a Microsoft Excel file containing data from the associated table.  A file selection dialog is displayed when the button is clicked, prompting the application user for a file name.

Export data to CSV from

Create an ASCII CSV file containing data from the associated table.  A file selection dialog is displayed when the button is clicked, prompting the application user for a file name.

Export data to Word from

Create a Microsoft Word report using data from the associated table.  A file selection dialog is displayed when the button is clicked, prompting the application user for a file name.

Import data from

Imports data into the selected table from ASCII CSV, Microsoft Excel and Microsoft Access files.  A wizard is displayed when the button is clicked, prompting the application user for a file name and other details.

You must specify a ‘Go to specific URL’ action (via the Button Action Wizard) to launch the Import Wizard and designate the database table to receive the imported data.  The URL has the format:

../Shared/SelectFileToImport.aspx?TableName=Categories

SelectFileToImport.aspx is the Import Wizard.  ‘Categories’ is an example of the database table receiving the imported data.

Pagination

Perform the selected table pagination operation.

Refresh page

Restores the current page (or form) to its last presented state.  For Add Record pages, the input fields are cleared of any data entered into them.  For Edit Record pages, the data fields are restored to their original values from the database.

Refresh page causes record controls and table controls to refresh their data from the database, even if the fresh data was from a concurrent modification by another user.  I.e., the most current data is always retrieved from the database.  It does not restore from the web browser’s local cache.

Note: Refreshing a page does not reset the filter settings or clear the search text box.  To clear the filters and search text box, simply redirect to the same page using the “Go to a specific URL” Button Action option.

Save data on page

Any input data and edited values on the page are updated (saved) into the database.  Any deleted records are removed from the database.

Save data on table or record

Any input data and edited values in the selected table or record are updated (saved) into the database.  Any deleted records are removed from the database.

Sign out

Sign out of the application.  The application user is logged out.

The Sign Out event is always consumed by the Page unless some form of code customization is employed relating to this event.

Update related panel(s)

Button triggers post back on the related panel (such as Enhanced table with detail below)

None

Button does not trigger any action

Enable client-side data validation

The data entered into the page is validated by the application.  All data in each data entry control on the page is validated.

Go back to the previous page

Redirects to the previous page in the navigation history. For example when you click ‘Cancel’ or ‘Save’ button on the Edit record page you get redirected to the table page you came from.

Close the browser window

Closes current browsers window or tab. This is useful if you opened a page in the pop-up window or new tab.

Navigate to a specific URL within a modal pop-up

Opens new page in the modal pop-up on top of the calling page while disabling its content. Modal pop-up does not affect or update the page it was called from unless you specify control to be updated. For example you can open Add record page in the modal pop-up. See Part I: Getting Started > Customizing Web Page Behavior > Using Modal Pop-up pages for details.

Navigate to a specific URL within a new window

Opens new page in the new browser’s window or new tab depending on the browser’s settings. When page is closed it does not affect or update the page it was called from unless you specify control to be updated. See Part I: Getting Started > Customizing Web Page Behavior > Using Modal Pop-up pages for details.

None

No redirect action is applied.

The Table Report pages created by the Application Wizard contain Edit and Show icons (notepad and magnifying glass, respectively) that are not connected to pages.  You may optionally remove the Edit and Show buttons, or connect them to pages.

Send email for

Send email for selected set of records. There are 3 options available:

Email address

An email address can be a simple text string, a substitution variable or a field value.  Text string email addresses are used exactly as specified in the Constant field.  Substitution variables are placed in the Constant field and are evaluated after the button click at application run-time.  When evaluated, a data value is substituted for the substitution variable.

See Button Actions - Substitution Variables for further details on how substitution variables are handled.

Email display name

The email display name is optional.  If nothing is specified, the display name is the same as the email address.

Display names can be simple text strings, a substitution variable or a field value.  Substitution variables are placed in the Constant field and are evaluated after the button click at application run-time.  When evaluated, a data value is substituted for the substitution variable.

See Button Actions - Substitution Variables for further details on how substitution variables are handled.

Subject

Specifies the email’s subject line.  Use the “Insert variable...” button to insert substitution variables into the subject line text.   The substitution variable will be evaluated at application run-time after the button click and data from the table or record control substituted in place of the variable.

Body Content

Images

Specifies how to display images used in the email body.

Javascript

If your email content contains javascript, the email has a greater chance to be filtered and put into the spam folder. Therefore you have an option to remove or retain javascript when emailing.  The default selection is 'Removed from email'.