Viewing data - Projects with multiple forms
The previous instructions introduced both the map and the tabular view for viewing data. We will now briefly go through the method for viewing multiple form projects and this will be based on our Schools2 demo project.
As a reminder, we expanded the single schools form to add two additional forms within a hierarchy (one-many)- one for teachers and one for pupils. This allows us to collect and automatically assign a number of teachers per school, and for each teacher a number of pupils. Furthermore, we introduced branch forms which allow the addition of further forms which are 'branched' out to from within a form in the hierarchy, allowing any number of entries to be gathered. We demonstrated this by designing a 'sickness' form which allowed the gathering of sicknesses taken by teachers.
We have initially, for the schools form utilised the same schools as previously, however we extended our data gathering to collect information on teachers within a school and also pupils per teacher. Our hierarchy therefore is as follows:
For the purpose of demonstration, we have also added a photo field to both the teacher and the pupil form.
Similarly to when viewing a single form project, the initial view shows the form name and the option to show all entries or to filter based on a value entered as in the following screenshot:
The Schools2 project is available at: http://plus.epicollect.net/schools2
You can view all entries for a particular form by clicking 'View all' which will produce the tabular view as previously. Clicking on 'View all' for the Schools form produces the following view:
As previously, for the schools table, you will see all data presented in tabular format and , because we specified a Location field within our form, a 'Map' tab is available to view data on a map. However, because we have linked our Teacher form to the Schools form, an additional column is present in the tabular view (indicated above as (1)). This column contains the number of entries in the form below this one in the hierarchy - In this case, teachers.
In the table above, the second School Entry - Hogwarts - is indicated to have four Teacher Entries and a link to 'View Entries' is given. Clicking view entries for Hogwarts will display all teachers that are linked to this school as in the following screenshot:
As you can see, any teacher entry that was added to the hogwarts school entry is displayed - the key field from the School form is indicated also (What is the name of the school?'). You will also notice that the final column lists the number of entries in the form below in the hierarchy (in this case the Pupils form). This final column indicates how many pupils have been added to each teacher.Clicking the 'View entries' link for a particular Teacher will list and display those entries added.
For example, clicking the 'View entries' in the Pupil Entries column for the first teacher - Minerva McGonagall' will display pupils linked to this entry as in the following screenshot:
As we can see, three pupils were entered and are displayed and again, the keyfield from the teacher table is included.
In essence, the view displayed in each of these views is the same but contains only the data requested via clicking a school, then a teacher and then a pupil.
Note: You can of course view all entries for a form at one time (eg all pupils from all schools)' from the initial view when loading the project homepage. You can navigate back to the initial view by clicking the breadcrumb links above the table.
We will now show how you can view branch Form data using the Schools3 project