Sort by day

Viewing 1 reply thread
  • Author
    Posts
  • January 14, 2015 at 9:42 AM #12664

    kenclarkeis
    Participant

    Hi

    I have been using a tap forms database to record client attendance. I see individual clients on a particular day every week. I want to be able to sort or group clients by days of the week. I currently store the day of the appointment as text, ‘Mon’ or ‘Tue’ and this can only be sorted alphabetically. Is there any way of storing a day and sorting by days of the week. I could put a number in front of each day, ‘1 Mon’ ‘2 Tues’ etc but this looks messy. Is there a better way to do this.

    I use a pick list for days, can the order of items in the pick list be used to sort?

    Thanks

    Ken

    January 16, 2015 at 1:23 AM #12686

    Brendan
    Keymaster

    Hi Ken,

    I’m afraid your only solution will be to add numbers as a prefix to you days to get the kind of sorting that you need. There’s no way to sort by the order of the pick list values.

    Thanks,

    Brendan

Viewing 1 reply thread

You must be logged in to reply to this topic.