In this article we will talk about database grouping. Which can be very useful for any database.
The given function is needed in those cases when it is necessary to link several fields with the same values. For example, if you are an owner of some shop and you want to see which goods have been purchased and by whom in the database. That is to put it in order, for instance, on the basis of the value of “A” product and look through the list of buyers who purchased that product. Or, otherwise, to make sorting on some particular client and see what he purchased. If you use new options of online form builder you will be pleasantly surprised and understand that using them you will be able to make sorting in the database in such a way that you will see information about a particular client, what he purchased and when. That is, you will be able to make the basic sorting on the client, the secondary sorting on the data and only then sorting on goods. Thus, you will see a sorted list of goods purchased by a particular user on a particular day.
How to use it?
First of all it is necessary to create a site online. Then go over to the “records” menu. After that click on the database grouping link. Further on, MyTaskHelper.com will offer you to specify the fields according to which sorting of data in the database will be made. If you want to put it in order you can choose one or several fields. Besides, there are ordering procedure settings that is descending or ascending. It is important to mention that it is possible to organize sorting on several fields simultaneously. Together with it you can specify sorting priorities. You can move the fields chosen for sorting up or down with the mouse, thus specifying their priority. If you use several fields for sorting it does not mean that they should have one and the same data ordering procedure as it is possible to make data extracts on every field separately according to their own settings.
This function is very convenient because it makes it possible to search and analyze the needed information precisely by means of sorting on several fields simultaneously. Together with it you can regulate the ordering procedure for every field separately.
Besides, developers have taken into account the variant of fields’ location change, which are also called table columns necessary for convenience and simplicity of search and analysis of information. For example, you can make the first column as the buyer’s name, the second â?? as the date of purchase and the third one â?? as the product purchased. Or it may be the product and then date.
