List View Button
The List View button opens a modern, grid-based interface designed for efficient business data management. Replacing the old Browse option, it introduces a powerful, interactive table that lets users search, filter, sort, and perform actions on records quickly. The columns are displayed based on the Data Dictionary (DATA DICT). Only fields with a valid browse or lookup order are displayed in the list view. Any field assigned an order of 0 or 999 is excluded from the view. All visible fields follow the configured order, and a default view can be set either at the company level or per user.
To set the Default View at Company Level
- Open the User Permission Wizard (PERMWIZ).
- Go to the Screen With Default Permissions tab.
- In the List View Enabled column, check the box for the required screens.
- Click Save to apply the settings.
Note: This sets the default for all users unless overridden individually by user preferences.
To set the Default View at User Level
- Navigate to the screen you want to configure.
- Click the Default View icon in the top-right corner of the screen.
- Choose either Form View or List View.
Note: The selected option is remembered for future sessions for that screen.
To search Records in List View
- Use the Search button on the toolbar to select a column, or directly use the auto-row filter beneath each column header.
- Enter your search keyword and press Enter.
- Click Advanced Filters to add multiple columns and apply filter conditions such as equals, contains, greater than, or less than.
Note: A maximum of 10 filters can be active at a time. All active filters are displayed in the search bar for quick visibility.
To save and share layout
- Open Column Settings to configure your layout:
- Drag columns to reorder them.
- Re-size columns by dragging the borders.
- Use check-boxes to show or hide columns as needed.
- Use Column Settings to define and apply conditional formatting (e.g., highlight rows or fields based on values).
- Sort records by clicking on any column header. Click again to toggle between ascending and descending.
- Use the pagination controls at the bottom of the screen to move between pages.
- Select the number of records per page using the Page Size drop-down: 100, 200, 300, 400, or 500.
- Apply filters using the Search button or auto-row filters.
- Click the Save icon to save your current layout and filters.
- Enter a name for your saved layout and confirm.
Note: You can set a saved layout or filter as the default. Use Remove Default to clear it.
- Open the Saved Searches menu to view your saved configurations.
- Select the desired saved filter or layout.
- Click Share, then choose the users you want to share it with.
Note: Saved layouts retain the full configuration including column order, column visibility, sorting, page size, active filters, and conditional formatting, but only if explicitly saved.
To export records in List View
- Click the Download icon in the toolbar to open the Download Options dialog.
- In What to download, choose one of the options:
- Selected Rows — exports only the rows you explicitly selected.
- Filtered Rows — exports all rows that match your current filters.
- All Rows — exports the entire records available in the table.
- Choose a File Format from the dropdown (.xlsx or .csv).
- .xlsx preserves Excel formatting and is best for full-featured spreadsheets.
- .csv is plain text, useful for simple imports or systems that require CSV.
- Review the Preview Download area before exporting:
- Confirms how many rows will be exported.
- Shows the chosen file format (e.g., Format: XLSX).
- Lists the columns that will be included in the export.
- Click Download to start the export.
To access Related Forms and Reports
- Click on More Actions in the toolbar.
- The drop-down will show links to any Related Forms or Reports available for the selected record or screen.
To Open Form in the Same Tab
- Hover over a record in the List View.
- Click the Tab icon (appears at the end of the document number).
To Open Form in a New Tab
- Hover over a record in the List View.
- Click the hyperlink on the record (appears on the document number).
Note: The Tab Icon and Hyperlink are displayed for the column with a Browse Order of 1 as defined in the Data Dictionary (DICT).