- 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.)
- Search a Grid Component that is Embedded into a UX component
Create a highly customized 'Search Part' for a Grid. Allows you to submit a UX component that
contains 'search' fields to compute a filter expression and then filter a Grid component that has been embedded into the UX component.
- Order Builder
The Order Builder lets you create powerful sort operations by navigating through an easy-to-understand dialog box.
- How to Export Selected Records to Excel in a Grid Component with a Checkbox Selector
/pages/HowTo/Grid/Export Checked Records to Excel.xml
Individual rows in a Grid Component can be exported to an Excel file using the Checkbox Selector Column to filter the Grid Component before performing the export.
- How to Import Data from an Excel or Ascii File into a Grid Component
/pages/HowTo/Grid/Import Excel or Ascii to Grid.xml
Data in an Excel file or comma delimited Ascii file can be imported into a Grid Component based on a table in a database.
- Default Values
Use Default mode field rule to fill a field in a new record with a default value.
- Clear a Search a Grid Component that is Embedded into a UX component
For use in conjunction with the 'Search a Grid Component that is Embedded into a UX' action.
Clears the search form in the UX and removes the filter from the embedded Grid.
- Filter Builder
When selecting records for a form, browse, report, mail labels, letters, or when performing operations, Alpha Anywhere uses a filter expression to determine which records to include. Filter Expressions evaluate to a TRUE or FALSE value. as Alpha Anywhere scans through a table, it selects the records where the filter expression evaluates to TRUE; it ignores the records where the filter expression evaluates to FALSE.
- The Auto-Suggest Builder
/pages/Guides/Mobile and Web Components/UX/Controls/Props/Data/Lookup/Lookup definition/Auto-Suggest Builder.xml
The Auto-Suggest Builder is used to construct Auto-Suggest style Lookup controls.
- Effects of Setting Filter and Order Properties
/pages/Desktop/Reference/Design/View/Form/Effects of Setting Filter and Order Properties.xml
In forms in which you have saved filter/order criteria, queries act differently. While queries can be used to change the order of records that appear, they cannot be used to include records which do not satisfy the filter criteria you saved in the form's layout.