How to Edit a Record with Fields that are Auto-Calculated

[mykrobinson]

I have a tracker app where workers will enter some notes to document some interaction with patients, currently being used to log outbound calls for things like attempting to reschedule cancelled appointments and such. In my initial build, I had the initial value of the Start Time and End Time columns set to NOW() but be editable. The main doctor wanted it to be automatically calculated in order to shave a little bit of time off the process of logging, so i still have the initial times of both values set to NOW(), the columns hidden, and a save form action that changes the End Time value to NOW(), which will subsequently trigger the duration column value to calculate the time spent on the task, provided the person performing the task is aware that this is how the duration is calculated.

my argument at the time was that this will ultimately lead to more work anyways because you WILL end up with situations where people are needing to modify these records because they were distracted and may have started the timer to log a call but not actually started the call yet. Anyways, he wanted to roll the app out to a few folks today to start testing, and right out of the gate, this is exactly what happens. I want to move back to manual entry of start/end times with automatic duration calculation, but he would prefer to keep it as is, but allow editing of records.

My initial though is you can't have it both ways, but i may be wrong due to limited experience with AppSheet.

How do i go about allowing users to edit records after the fact? I suppose I can just expose the values, still leave the initial value set to NOW(), and still have the form save action to update the End Time value, but that presents a problem in that it will update the end time value again upon saving the edited form, will it not?

I'm open to suggestions....

NOTE: the patient info in the image is a dummy test patient, no privacy regulations are being broken here