Column Sorting
Deutsche
Version - French
Version *links to another site
Today's tip covers one of those things that us "long time Notes users" just assume everyone understands, sorting columns. However, I was recently working with a group of users that they did not know you could do this, so I thought I'd go over it.
Let's look at a Notes database where the view shows documents containing specifications about product inventory. The columns list various product properties such as color, shape, and size. In the image below, the documents are sorted by the date and time "descending", meaning newest documents are at the top, with older documents following as shown by the red arrow.
Notice in each column heading there are "triangles" next to the column's title. These "triangles" allow you to resort the documents in the view based on the values in the given column that you click on.
For example, next to "Date"
you
see a triangle pointing up. Clicking on this will cause the documents
in the view to be sorted "ascending" based on date, meaning the
oldest documents will be shown at the top, and the newer documents will
follow. I've resorted the view as shown below, and you can see that
the "triangle" is now solid, indicating the sort option is "enabled".
If you click on the triangle again, it will be disabled and the
view will go back to the default sort order.
The sorting option in the Color column is pointing down
,
this allows you to click on it to have the view resorted with documents
"descending" based on the value in that column.
In the Shape column,
,
the developer has provided sorting options in both directions, ascending
and descending.
In the Size column, there is a special sorting action that looks like an arrow
.
When you click on this, instead of resorting the current view,
Notes instead switches to a new view. The application's developer
defines which view that is, but it is almost always a view based on the
value from the column which you clicked on. For example, clicking
on the "Size" column could take you to a view sorted and categorized
by Size as shown below:
Which (or any) sorting options are available is controlled by the database's developer.
That covers the options for sorting views based on column values. In my next tip I'll cover changing the width, and the order of the columns.
Tweet
Today's tip covers one of those things that us "long time Notes users" just assume everyone understands, sorting columns. However, I was recently working with a group of users that they did not know you could do this, so I thought I'd go over it.
Let's look at a Notes database where the view shows documents containing specifications about product inventory. The columns list various product properties such as color, shape, and size. In the image below, the documents are sorted by the date and time "descending", meaning newest documents are at the top, with older documents following as shown by the red arrow.
Notice in each column heading there are "triangles" next to the column's title. These "triangles" allow you to resort the documents in the view based on the values in the given column that you click on.
For example, next to "Date"
The sorting option in the Color column is pointing down
In the Shape column,
In the Size column, there is a special sorting action that looks like an arrow
Which (or any) sorting options are available is controlled by the database's developer.
That covers the options for sorting views based on column values. In my next tip I'll cover changing the width, and the order of the columns.
Tweet
