Jump to content

Tricky Sorting


This topic is 7579 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi! Not even sure if this would be a "scripting" issue or not... confused.gif

Here's my question...is there a way to do a sort within a sort?

Example: I have twenty records to display. Each record has a 'title' field, a 'part' field, a 'status' field, and 6 different 'date' fields (date1, date2, date3 etc).

Is it possible to sort by title, then depending on what the status field says, by the appropriate date field?

i.e. the first 8 sorted records are for the title "Eagles"

The first 3 of those 8 records are status="A", which would need to be sorted by the date2 field...The next 4 records are status="B", which would need to be sorted by the date3 field, etc.

Then the next 3 sorted records are for the title "Owls", etc etc etc.

Does that even make sense? Any help greatly appreciated!!

Link to comment
Share on other sites

Perhaps this might work--

Add a new calculation field called "Sort Date" which results in a date.

The calculation would be:

Case(Status = "A", date2, Status = "B", date3, Status = "C", date4, ... [and so on]

Then, sort the records by:

Title

Status

Sort Date

Link to comment
Share on other sites

This topic is 7579 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.