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)
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.
Thanks,
Brendan
.
