I have created an app for a very detailed and long survey in our company. In this app, I have a category field called Survey Status, which is a required field and has two options "In Progress" and "Completed". By default "In Progress" gets selected while creating a new entry in the app. This category field is the last field in the survey app. So once people complete the survey, they will mark it as "Completed".
The idea is that people will select the first field called "name" and then save the entire form. This will give me the moment(@Created On) value. Then they will open it again and start filling up the remaining fields until the last field called Survey Status where they will change it to "Completed". It can be used to capture the end time for the survey.
var start = moment(@Created On);
var end = moment(@Survey Status=='Completed');
Can somebody suggest me a better way to do this? Maybe my entire thought process is incorrect.