Sort Records by

Viewing 1 reply thread
  • Author
  • November 14, 2023 at 11:46 AM #50129

    Glen Forister

    Can you explain the difference between
    Sort Records by (3 categories)
    Group Records by (at the bottom and not explained on that page in the manual)



    November 15, 2023 at 12:19 PM #50132


    Hi Glen,

    The Group Record By is actually what’s sorted by first, then the First Sort Field, then Second, then Third.

    Imagine you had a Movie Library and you wanted to group your records by Genre. Tap Forms will display the full name of the Genre in each section heading. The records will first be sorted by Genre (ascending or descending), then by First Sort Field, Second, then Third.

    Without the Group Records By option, Tap Forms will just display the first letter in the section heading of the First Sort Field’s value.

    So they’re similar, just that you get the full value displayed in the section heading. So you want to choose a field that will make sense for that to show. That is, make sure the values in the group field are not all unique. If they’re all unique, you’d end up getting a section header for every record. Probably not what you want.

    Hope that explains it ok.



Viewing 1 reply thread

You must be logged in to reply to this topic.