Duration of interview

Support
1

hi i look for a way to calculate duration of interview.
thanks for help.

2

Welcome to the ODK forum, @Mor_Gueye! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. Thanks for adding your profile picture. It helps build community! Questions about how to do something in the app should be posted to #support and not #community.

When calculating durations there are several options:

  • You can use metadata to capture start and end and then calculate the total length in your data processing. Note that if the form is saved and the reopened for review before submission, this will change the end time.
  • You can use lightweight timestamping.
  • You can use a form audit log.
3

@danbjoseph thanks, i am a new user. i tried using the first option with start and end but it dose'nt work. no info on the database. see the document below. i miss something ?
time_record.xlsx (9.2 KB)

4

You need to include rows in your form for the metadata you want to record:

+-------+-------+--------------------+
| type  | name  | label::French (fr) |
+-------+-------+--------------------+
| start | start |                    |
| end   | end   |                    |
+-------+-------+--------------------+
5

@danbjoseph there are on. see the complete table below. but there are no value on my database for "end_t".
record_calcul.xlsx (9.8 KB)

6

I think the end metadata value is the last thing recorded when the form is closed and so the value is not yet available when end_t is calculated. Can you do the math in the exported data during your data cleaning and analysis stage?

You could also do a light-weight timestamping on the final question in your form, and use that instead of the end metadata for the end time of the survey.

1 Like
7

thanks, i wanted to do it automaticly but if it does'nt work, i will do it when i export datas. also i am gonna see the light-weight timestamping . thanks a lot

8

Hi, I am Lulu and i am having the same issue, i would like to do this calculation using start and end. However gathering from this discussion, this is not possible. Is there another way to do it in the form?

9

Welcome to the ODK forum, @Lucienne! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!

Please see the links in the second post of this thread for details: