Selective sorting

[Pablo Ramirez]

Hello

I have a database with about 253 records. How can I sort them in such a way that it only shows me the 6 more recent ones in a layout.

Thanks in advance

Pablo Ramirez

[Kurt Knippel]

Well, what I would do is to first make sure that you have fields in the DB for CreationDate and CreationTime. Then sort by CreationDate - Descending and CreationTime - Descending. Now you have them sorted most recent to last.

Then if you only wanna see 6 of them, create a list view layout, where you modify the Header, Body and Footer, such that only 6 Records will show in the screen. Alternately you could setup a relationship sorted as above and format a portal to show only 6 records.

[jasonwood]

Here's another way... it's not a sort but it will show the most recently added 6 records as a found set.

Script the following:

Show all records

Go to record [last]

omit record

omit record

omit record

omit record

omit record

omit record

show omitted

Go to layout [list view]

Then you just have to have a list layout that will fit all 6 records.

[Pablo Ramirez]

Thanks a lot. I'm gonna try it right away

Pablo