- Removing Selected Records from a Table
/pages/Guides/Desktop/Design/Data/DBF/Removing Selected Records from a Table.xml
You can remove selected records from a table based on the records in another table called a "remove list". This is useful, for example, in mailing list applications when you receive notification from recipients that they want to be removed from your mailing list.
- How to Export a Layout Table Report with Live Forumlas to Excel
/pages/HowTo/Reports/Live Excel Forumlae in Layout Table Reports.xml
When exporting a Layout Table Report to Excel, calculated fields can be configured to export as Excel Formulas, instead of static data.
- Prompt for a Field Name
/pages/Guides/Desktop/Design/Prompt/Prompt for a Field Name.xml
The Prompt for a Field Name action will prompt the user for a field name and store it in a variable.
- Updating Selected Records in a Table
/pages/Guides/Desktop/Design/View/Database/Updating Selected Records in a Table.xml
When viewing a form or browse, you may update selected records in the current table using an Update Operation or when viewing a table through a form or browse.
- Applying a Range to a Table
/pages/Guides/Desktop/Design/Data/DBF/Applying a Range to a Table.xml
To apply a range to a table while viewing a form or browse:
- Open a UX component to Edit Current Record in Grid, or add a new Record
Open an UX component in a pop-up window, or in a DIV on the current page, to edit the current row in a Grid component or to enter a new record.
(Only new Ajax Components can be opened. Old Dialogs in V10 and earlier are not supported.)
- Creating a Tree Control Based on a Set
/pages/Guides/Desktop/Design/Data/DBF/Creating a Tree Control Based on a Set.xml
This example shows how to create a tree control that shows the contents of a set. The set has four levels, as Described in this picture.
- Creating and Using a Summary Field
/pages/Guides/Desktop/Design/Data/FieldRules/Creating and Using a Summary Field.xml
The Summary Genie assists you in creating calculated fields that summarize various aspects of a field over a group of records or over the whole table. The Summary Genie will summarize over the child records for a given parent record if you select a field or expression based on a child record. It will summarize over the whole table if you select a field or expression based on a parent record. The following functions are supported:
- Prompt for a Folder Name
/pages/Guides/Desktop/Design/Prompt/Prompt for a Folder Name.xml
The Prompt for a Folder Name action will prompt the user for a folder name and store it in a variable.
- Prompt for a Filter Expression
/pages/Guides/Desktop/Design/Prompt/Prompt for a Filter Expression.xml
The Prompt for a Filter Expression action will prompt the user for a character filter expression. This type of expression evaluates to a logical value and selects records from the table.