Are two more than two levels of grouping possible?

[Victor Warner]

I am creating a database to record subscriptions and have set up fields to show

1. name of subscription;
2. period of subscription (yearly, monthly, 2 yearly);
3. type of subscription (eg work, domestic, software);
4. amount of subscription

among others.

I can see that one of the options is to group records. If I choose type of subscription and Multi-Column View then I can group on headings for work, domestic, software and choose and as a sort field type of subscription so that within each heading the subscription are sorted by the period.

As far as I can work out it appears is not possible to have 2 level Group by Records.

For example, rather than having

Work
domain registration,2-yearly,£9.99
tap forms, monthly, £150.00
365 office, monthly,£59.00
office insurance,yearly,£300.00
professional indemnity insurance,yearly,£1,500.00
Total £2,108.99

Instead:

Work
2-yearly
domain registration, £9.99
£9,99

monthly
tap forms,£150.00
365 office,£59.00
£209.00

yearly
office insurance,£300.00
professional indemnity insurance,£1,500.00
£1,800.00

£2,108.99

Is this type of 2-level grouping available in Tap Forms?

[Brendan]

That’s right, there’s only the 1 level of grouping in Tap Forms.

However, what you could do is create multiple Saved Searches that filter the records by another field so that you could have a 2nd level of grouping. So the first level of grouping is the Saved Search and the second level of grouping is achieved by the Group Records By option. You can also have a different set of sort options for each Saved Search. And a different set of fields displayed on the multi-column list view.

Thanks!

Brendan

[Author]

Posts