Link Search Menu Expand Document
Mobile Data Collection toolbox

5.7.2 Adding media in form responses


TABLE OF CONTENTS


Why add media to your form ?

In addition to text questions or responses, it is possible to add pictures and audio recordings inside the form. The idea is to bring more clarity for both the enumerators and respondants in certain contexts or regarding specific aspects of a topic.

Here are a few examples where the use of media can be pertinent:

  • Pictures of different water treatment solutions (water and sanitation surveys)

    image info

  • Smileys symbols (e.g. when interviewing children)

    image info

  • Adding an audio recording in a question or a note (e.g. reminder of key expressions such as the definition of a household, the list of symptoms of a disease, etc.). The audio can be run by the interviewer only if needed as a reminder and would use much less space than a long text definition.

    image info

These are only examples. There are many more situations where the use of media in a survey can be relevant. Visual can be much more effective than words, especially in context where the level of education is limited.

How to add media to your form ?

Adding medias to your form requires handling XLSForm format. If you started to create your form with the online form builder, you want to export it to be able to modify the form and add media files: Click on your form > click on the “More Actions” button (symbol “…”) > Download XLS

image info

You can find here a video tutorial on How to Add an Image to your KoBoToolbox Form (it is likely the same procedure for audio or video type of media). In addition, here is the KoBoToolbox tutorial Adding Various Types of Media (image, audio, video) to a Form.

Once you have the XLSForm file, open it and create the questions where you want to add medias to.

  • To add pictures related to the label of a question > add a new column labelled “media::image” in the “survey” sheet

    image info

  • To add pictures for the responses of a question (e.g. when there is a list of responses to pick from) > add a new column labelled “media::image” in the “choices” sheet

    image info

  • To add an audio recording, the procedure is similar > add a new column labelled “media::audio” in the appropriate sheet (“survey” and/or “choices”)
  • Once the column(s) is(are) added, you need to fill up the cells with the name of the corresponding media file (not the path where the file is, only its name, such as “aquatab.jpg”).

Make sure that the name is the same (spelling AND case) as the actual filename otherwise the picture won’t appear. E.g. “aquatab.jpg” is different from “aquatab.JPG” or “Aquatab.jpg”.

image info

  • Once finished and saved, upload the XLS file into KoBoToolbox (through the homepage upload or by updating your previous project):

    image info

  • Make sure that you Deploy it.

    image info

  • Go to the Deployed section, select the form and click on “Settings” to display the advanced menu.

    image info

  • Upload the corresponding files as shown below (Settings > Media > Add document > Choose files). Make sure to click on “Upload” to import the files. You can import more than one file at a time.

    image info

  • Once your files have been uploaded, check that they are all listed:

    image info

  • Click on Save Changes and in the “Form” tab, click on Redeploy so that the survey is updated, and media files are considered in the process next time you run the survey.

    image info

    image info

  • Before downloading and testing the finalized form in your external device, you can perform a first check online to ensure that the media files are properly inserted: go to the FORM tab > Under “Collect data, click OPEN

    image info

    If the media is not displayed (and you see the icon below), you should:

    image info

    • make sure that the expected media is in the list of uploaded media
    • make sure that the spelling and letter case in the XLSForm is exactly the same as the filename (including the file extension).

Additional information

  • It is possible to display the media files without the label (by removing the text in the label column of your XLSForm).
  • Before uploading images as media files, you may want to check that they have the same size if they are part of the same question.
  • Video can also be included in a form (by creating a column media::video in your XLSForm) but it is not recommended due to the probable heavy size of video files.
  • It is indeed advisable to use small media files or compressed format (e.g. jpg) whenever possible to make their transfer onto the phones easier when the internet is not ideal.
  • Remember than adding medias will require a larger internet bandwidth which may not be available in the field. Make sure that it is relevant.
  • To avoid any issue, it is recommended to use short media filenames that don’t include any special character or space.
  • The following media type can be uploaded in a form:
    • Audio: mp3, wav
    • Image: png, jpg
    • Video: mp4, mov
  • When exporting an XLSForm from KoBoToolbox, the media files won’t be downloaded automatically. They must be downloaded manually (from the same menu where they are uploaded: SETTINGS menu > MEDIA > Existing Form files > Download). See this tutorial to know how to add output image to an Excel File.