Setting sort fields

Viewing 5 reply threads
  • Author
    Posts
  • July 8, 2019 at 12:17 AM #35674

    tonyt
    Participant

    Hi
    I have a simple to do form. I want the uncompleted tasks at the top and when completed I want them forced to the bottom. I also want the starred records which are uncompleted to be arranged from 3 stars down to no stars. I can only get them to display the other way round, from 1 star down to three. I know this is muddled but hope you can help me! Maybe it is not possible as whatever I try I can’t get the right result!
    Cheers….

    Attachments:
    You must be logged in to view attached files.
    July 8, 2019 at 1:58 AM #35679

    Brendan
    Keymaster

    Your sort settings suggest you’re sorting the first and second fields in descending order, but the sort triangles on the fields themselves suggest it’s sorting in ascending order.

    Try refreshing the records and see what happens. And quit and re-launch.

    July 9, 2019 at 1:03 AM #35684

    tonyt
    Participant

    Hi Brendan,

    No luck! The best I can get I have attached. One thing seems odd in that with the star rating (H/L) field sorted descending the records with no sta rating are sorted above the ones with a star rating, which are indeed sorted descending – if you see what I mean?

    Hope you can help me some more soon.

    Cheers….

    Attachments:
    You must be logged in to view attached files.
    July 9, 2019 at 3:57 AM #35687

    tonyt
    Participant

    Hi Brendan
    In addition to the above, more info. The problems above relate to a saved search. When I looked at ALL the records they are displaying as I expected – that is uncompleted events sorted by star rating at the top and completed events pushed to the bottom of the list.The sort field settings seem to be the same but I am getting two different results?

    Attachments:
    You must be logged in to view attached files.
    July 10, 2019 at 12:04 AM #35698

    Brendan
    Keymaster

    Would you be able to send me an archive of this form so I can experiment with it?

    Have you tried grouping your records by the H/L field to see if that makes a difference? You wouldn’t need the sort field on H/L in that case as grouping will automatically sort on them.

    July 10, 2019 at 10:50 AM #35707

    tonyt
    Participant

    Hi Brendan
    Sorry for the late reply. For whatever reason things are all working as expected, so I shan’t bother you anymore … until the next time!
    Cheers….

Viewing 5 reply threads

You must be logged in to reply to this topic.