After you have downloaded a template survey form from the Trillion Trees Form Library and adapted it to your own survey, you can use this form validator to validate your survey form and ensure the structure of the form is the same as the template. This is necessary if your database is built on the template structure, to ensure that the data from this new form can still be integrated in the database.
How to adapt the template:
Survey tab:
Review the column "label" and make adjustments to the wording of the question if necessary.
Choices tab:
For the surveyor, district and village lists: edit the choices by updating the column "name" and "label". The "name" column for the choices should have no spaces and no special caracters. It is possible to add new choices by adding lines if needed.
For al the other choices list: review the column "label" and make adjustments to the wording of the choice label if necessary.
If necessary, you can add languages by adding "label" column, or remove the languages not needed.
However, you:
Cannot delete any colum (except for labels in languages not used)
Cannot delete any question/line from the survey tab
Cannot change variable names or types (columns 'name' and 'type')
Cannot change anything in the columns required, relevant, or calculation
Cannot group existing questions
To use the form validator:
1. Select the master template form that you used to create your own form. 2. Select and upload your own form. 3. Click on the Validate form button.
How to interpret the results of the form validator?
The list of errors is sorted from the 1st line of the form to the last line
Lines in black are changes that should not cause issues when using the form or transferring data to the database.
Lines in orange are changes that may cause issues when using the form.
Lines in red are changes that will affect the data integration, because the structure is different than in the template. If you are using a database that is based on the template structure, the data from a form with changes highlighted in red will not be transferable to the database.
Please make sure you are using the most recent versions of the form templates.
The form version and date of your template should match what is listed in the template forms of the validator.
Once your form is validated, you can:
Upload the form: In your KoboToolbox account, click on the blue button "NEW" and select "Upload XLS form". Drag and drop the form, then deploy it.
Share the form: Open the "Settings" of the form, select "Sharing" and click on "Add user". Enter "trilliontrees", select "View Form" and "View Submissions", and click on "Grant Permissions". Also add the user "ct_trilliontrees".