Solved: Capture duration of user spending time on form - Page 2

Ye_Myat_Aung · 07-07-2020 10:33 PM

Hi,

I’m creating a field survey with about 15-20 set of questions (data points). What I’m trying to achieve here is to record the time duration a field survey data collector (app user) would typically take to capture all data points. What I could think is to capture the start time (when the add button is pressed/form is loaded) and capture the time when form is submitted - and find the time difference between two.

How do I accomplish this on appsheet?

So far what I have tried is - created 3 columns in the Google Sheet, formStart, formEnd, and formDuration.

In the form design, formStart is DateTime with Now() - and I get the form opened time. I still can’t figure a way how to get formEnd.

LeventK

@Ye_Myat_Aung
[formStart] column shall be a Datetime type and the inital value set to NOW()
[formEnd] column shall be a Datetime type columns with initial value set as blank
[formDuration] column shall be a Duration type column with initial value and AppFormula set as blank

Add an action to this form’s table with Data: set the values of some columns in this table, select [formEnd] column and set the value as NOW(), select the [formDuration] column and set the value as

[formEnd] - [formStart]

Lastly, select this action from the Form Saved property of your form

View solution in original post