Hi,
I would like to add a hidden question which records the time near the end of an interview, ideally this should be non-editable once the survey has been saved for the first time.
I have set up a yes/no question as the last of the survey, 'Have you completed the survey', and based on that then use a calculate field with 'if(${Finished_YN}='','',once(now()))' to take a time stamp. This assumes that they enumerators will say they are finished and not change the answer at a later stage which will change the time stamp (as occurs with End Time).
I know there are Audit Logs but i do not want something as detailed and i need the end time to pulling into a database with the remainder of the data.
If anyone has any better solutions they have used, please let me know.
Thanks