In the menu under "Survey data" you can select the survey questionnaire to access the data for this questionnaire, in figure 1 an example is shown for the Inspection data.

 

Figure 1, questionnaire data

Data grid columns

In the data grid there is the header Registration, in the columns under Registration the registration data is shown. on the left, the registration data is shown for the questions Grower, Location, Field registration, Crop, Variety, Variety type, Class and Field size.On the right hand side of the grid there is the header Inspections, in the columns under Inspections the inspection data is shown.

Other than the questions for the registration and Inspections there are the following columns shown in the grid:

1. Column 1: Deleted-column of registrations, when the value of this column is 1 it means the registration is deleted
2. Column 10: Deleted-column of inspections, when the value of this column is 1 it means the inspection was deleted
3. Column 11: Archived-column of inspections, when the value of this column is 1 it means the inspection was archived

Data filtering

Data in the grid can be filtered using the cell under the header of the columns, as can be seen in the figure below filtering is done for the Crop column showing only crops that have the letters So. Also note that by default the delete columns (column 1 and 10) are filtered to show only not deleted values

Hiding columns

You can hide columns by clicking on the three horizontal lines in the header of the column, this will open the popup window as shown below. Here you can seletct the columns you want to show or hide.

 

Save the state of the grid

By using the filters and showing and hiding columns you can fine tune the way you as an administrator want to see the data in the data grid. To save these settings click on the Save button above the data grid where it says GRID, after doing this everytime you open the data grid it will apply your settings. You can also save grid settings for mobile users who log into the website by clicking on the SAVE USER button. The LOAD and LOAD USER buttons will load the data grid settings for you as an administrator or for mobile users.

Create, edit and view survey questionnaire data

To create a new survey questionnaire select in the grid a row with the registration data for which you want to create a new survey questionnaire, the survey questionnaire will open in a popup window as shown in figure 4 below. To edit or view an existing survey questionnaire select in the grid the row you want to edit or view and click on the VIEW or EDIT button.

Figure 4, creating a new survey questionnaire

Copy a survey questionnaire

It is possible to copy a survey questionnaire with the answers given to the questions in the survey questionnaire. To do this you select the survey questionnaire you want to copy in the grid and click on the COPY button under SURVEY above the data grid. Note that only the answers of questions for which the copy value properties of the question is set or all the questions in one page for which the copy value is set for that page. On how to set the copy value for a question or page see the Properties values tutorial. 

Creating an empty survey questionnaire(s)

To create a new empty survey questionnaire select in the grid a row with the registration data for which you want to create a new empty survey questionnaire,and click on the SINGLE EMPTY button above the data grid. If you want to create an empty survey questionnaire for all registration dataentries that do not have a survey questionnaire click on the MULTIPLE EMPTY button.

 

Reset or delete a survey questionnaire

It is possible to delete and un-delete questionnaire data, deleted questionnaire data will not be shown on the mobile app. To delete questionnaire data, select the row for which you want to delete the data and click the RESET button above the data grid. This will set the delete value of the survey questionnaire to 1, this will hide the survey questionnaire in the grid because the delete row is set to show only delete values that are set to 0, for more information on filtering the data grid see the data filtering section of this tutorial. To undelete the questionnaire data select the row and click on the RESET button.