Creating a field with the duration time generated automatically

05-04-2018 04:24 PM
Occasional Contributor
3 1 597

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