Grids are found throughout the application and look similar to a table; grids are used to organize large sets of data to easily search and filter.
Each grid consists of rows, columns, cells, headers, filters, and search fields.
Rows
Represents an individual data source record
Columns
Is a set of data values of a particularly simple type, one value for each row
Cells
Used for displaying and editing values of data fields.
Headers
Represents the type of data for a column.
Filters
It allows a user to filter data by values of individual columns. To filter a column, click the Filter icon right of the column header and select a value from the dropdown.
Sorting
To sort the column data, click next to the Filter icon to change from ascending to descending.
Search Fields
It allows a user to type in a value and generate a list of all records containing that specific value. To use the search, type in a keyword value and press Enter.
Using column headers to filter and sort
Column Headers are drag-able which allows you to …
- Group-By Column Header – This Groups the current section by the column dragged into the group by the field at the top of the section
- Re-order Columns – Drag and Drop Column headers in the order in which you want them to appear in the grid
You can also expand/reduce column size by simply clicking and dragging the borders of the column to your desired size
When Clicking the Column Header, you can Sort By
- Ascending – Which sorts the column in an (a-z) / (1-100) / (Last – First) manner
- Descending – Which sorts the column in an (z-a) / (100-1) / (First – Last) manner
Filters can be applied to columns by clicking on the Funnel Icon in the column header and selecting the information in which you want to filter by.
Using the column to search
– There is also another option below the column header where you can search or select from…
- Column Search – Allows you to search that specific column for certain information
Within this field, you can click on the magnifying glass to set what type of parameters you want to be applied to your search.
* The options differ depending on the data’s structure
– If the data is in a Date/Time Structure it will have the following options
- Equals
- Does not equal
- Less than
- Greater than
- Less than or equal to
- Greater than or equal to
- Between
- Reset – Clears the column search field
– If the data isn’t in the Date/Time Structure if will have the following options
- Contains
- Does Not Contain
- Starts with
- Ends With
- Equals
- Does Not Equal
- Reset
- Column Drop Down
Within this list, you can select which item from the list below to produce in your column’s results
Note:
Not all Tabs / Features in Omnidek have these options, but if you want to see which options are available in each one please see the list below *
- Form Hub – Saved & Submitted – Keywords Search
- Inbox – Section Search
- Insights Tab – Section Search
- Insight Module – Column Headers * Except Re-Ordering Columns and Re-Sizing Columns* | Column Search Field
- Workflow Tab – Section Search
Admin Tab
- Users – Section Search | Column Headers | Column Search Field
- Crowds – Section Search | Column Headers | Column Search Field
- Assets – Section Search | Column Headers | Column Search Field
- Data Security – Section Search | Column Headers | Column Search Field