Creating a field with the duration time generated automatically

353
1
05-04-2018 04:24 PM
RogerMesen-Delgado
Occasional Contributor
3 1 353

In this case I been working in one survey for a local government in Costa Rica. They need the total time that the user spend doing the survey. So I Create a start and end type of fields(important: do not use the default values of now() ) Those kind of fields automatically generate the values. The time Start create the same value of the #now(), but the end is fill at the end of the #survey. Check the image. After create the start and end field you create the #calculation field with the following #formula 

/*

round(int(${Hora_Fin} - ${Hora_Inicio}) div (1000*60),0)

*/

This field is going to update automatically.

Enjoy creating forms and tell me if it works for your form. 

1 Comment
CalvinKwon1
New Contributor III

Awesome  Exactly what I was looking for. 

Do you know if we are able to prevent a form submission if the total time spent on the survey is less than X minutes? 

About the Author
Hi, I'm a GIS Specialist, Anthropologist is my base career and finishing my Msc in Geography. I like to help people to solve their issues with GIS. I've been working with different industries, like local governments and private companies. I also writing my thesis about risk and hazards. If I can help, let me know.