Friday, January 18, 2019

Display Row Numbers in Saved Search Results

1. Navigate to Lists > Search > Saved Searches > New
2. Select the Search type. (e.g. Transaction).
3. Enter a search name in the SEARCH TITLE field.
4. Under the Criteria tab, enter the preferred filters.
5. Under the Results tab, enter the preferred fields and include the following:

  • Formula (Numeric) field > Under the FORMULA column enter rownum.
Note: Select the Formula (Numeric) row and move it to the top by clicking the Move To Top button.

6. In the SORT BY field select Formula (Numeric) - leaving the DESCENDING checkbox unmarked.
7. Click Preview or Save & Run.

1 comment:

  1. thanks great help.
    I also select "Group" in "Summary Type" in one of my column and select "Count" in Formula(Numeric) to get this done.

    ReplyDelete