Hi All
Just wondering is there anyway to sort the number in view so that the highest number is always at the top ? I tried sorting by creation date but the numbers on the documents jump so that 1 is always the first number…
Or if anyone has anyway other simple way of referencing that would be great
Subject: # in view
“# in View” is created BY the view after the documents are sorted. It’s just UI line numbering – there is no actual data behind it.
Subject: RE: # in view
Ok , thanks for that.Any suggestions on how to best reference documents ?
Thanks
Subject: RE: # in view
The best method is probably to use a computed-when-composed “reference number” field populated with the formula @Unique. That produces an 11-character string in the format:
SROS-1X2YZ3
where “SROS” is a user identifier (normally the first letter of the first name, the first two letters of the last name, and the last letter of the last name, but this will vary if there are “collisions” with other users), and “1X2Y3Z” is a Base36-encoded time stamp that is guaranteed unique for the user for each call to @Unique. BOTH parts of the result are required for a guaranteed unique value.
Ten significant characters in two groups separated by a hyphen is a good format for the users – it’s short enough and well-enough organized that they can keep the number in short-term memory long enough to search for it. If you use the identifier in a view column that is either the primary sort column or that is set to “Click to sort”, end-users can use the quick-find feature to get to the document they require.
Sequential numbering in Notes is not a very good idea in general. You CAN find code that offers a way to do it, but the best advice is DON’T – it only causes heartburn in the long run.
Subject: RE: # in view
Great stuff , that’ll do the job thanks for that