BNS & NRGT Form Validator

After you have downloaded a BNS or NRGT template survey form 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: 

  1. Survey tab:

    • Review the columns "label" and "hint" and make adjustments to the wording of the question if necessary.

    • You can add questions if you want to. The 'name' of new questions should be in English, using the Camel convention : FirstLetterOfEachWordCapitalized.

  2. 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.

    • You can add new choices by adding lines if needed. The 'name' of new choices should be in English, using the Camel convention : FirstLetterOfEachWordCapitalized.

    • For al the other choices list: review the column "label" and make adjustments to the wording of the choice label if necessary. 

  3. 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.