A common misconception is that you must display all fields in the ActionGrid for which you have created a filter. Sometimes you just want to filter on a given field but not necessarily display the field because of limited screen space.
ActionGrid was designed for you to create as many filters as you need but not necessarily display the associated fields. Here is an example scenario: You are viewing a grid of Opportunities and you want to only see the records with a percentage value greater than 60%. You can temporarily add the Percentage (%) field to the grid, set the filter, then remove the field from the grid.
Follow these steps:
- Click in the object list.
- Click the drop-down arrow next to and click .
- Select the check box. You will remove it later. For now, you must display it in order to create a filter.
- Click the Probability (%) column header. icon in the
- Click .
- Select , and enter a value of .
- Click Filter icon indicates that a filter has been applied to the field. . An orange
- Click and drag the field off the grid to hide it.
- The entire list view of Opportunities is still filtered by a probability of 60% or greater even though the Probability (%) field is now hidden. To verify this, click the drop-down arrow next to Filter Logic screen shows all of the current filters. and click . The