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.