Creating a field with the duration time generated automatically

Blog Post created by rogermesengeotec on May 4, 2018

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.