Adding Grouping to your online database views allows you to organize records into groups. Each group of records displays on your screen with a Group Header Title and may also include Subtotals such as Sum, Average and so forth. The views become instant "reports" online for quick decision making. If you need a hardcopy report, you can use GroveSite's Open In Excel capability for easy printing.
Let’s say you have created a technology assets online database using GroveSite. You want to be able to see the entries in your database grouped by category.
This can easily be done in your online database using GroveSite's Grouping, or Group By, capability. All you need to do is add a Group By definition in a custom view within the GroveSite Database Editor. (Note that you can group by up to three fields within your data set.)
When that custom view displays on your screen, you will see all of your assets grouped by their category. In the example below, we created a custom view named Category, and Grouped By one field, Category.
Once you have grouping, learn how to add Subtotals, Grand Totals,and other aggregate functions to your online database views!
Ready to get started? Read step-by-step instructions on how to add Grouping to your online database views on our Help Desk. Don't have a GroveSite Online Database yet? Request a free trial! As always, please contact us with any additional questions.