Edit Submissions

With this feature you can change the value of up to 50,000 questions per template across any number of submissions. In the template, each row represents a question you want to change. This means if you want to change the value of ten questions in one form, you need ten rows. If you want to change fifteen questions across fifteen forms, you need fifteen rows.

The template is structured this way:

• Case_Id - The case id related to the submission you want to change or edit

• Form_Id - The form id refers to the form of the question you want to edit. The form id can be found in the form section of the

• Field_name - The field name refers to the name of the question that you want to edit. The name of the question is the same value as the name field of the ODK/Kobo form. If the question appears as part of a group, the name of the group is included as a prefix to the question name seperated by a forward slash. (see below for an example)

• New_value - This is the new value you want to change that question to. Please keep in mind that this value needs to be formatted the same way as ODK/Kobo reads data. This means that for select-one and select-multiple type questions the value should be the choice name as given on the choice list.

Examples

Let's take a look at some examples to make this clearer. The below table will make changes to five questions across two submissions. The form is same for all the edits.

The Field_name is demographics/age because the question age is within the group "demographics". The field name "name" has no prefix because it is not located in a group. The new values are given in the final column.

This is the survey sheet of the form that is being edited

This is the choice list of the form that is being edited