How to time stamp a field using a button.

Hi Luis!

This is because formulas are evaluated as they change, so Now() gets evaluated when the page is loaded rather than when the button is clicked, meaning if you leave the page open for 5 mins before clicking the button, the time being captured was 5 mins ago.

There is a way to capture the time that the button was actually clicked, however you'd need to leverage a Date/Time field rather than a Time of Day field. To do this you'd simply want to set the value of _fid_8=now where now is a text string rather than the function. That way, when the request is made you're telling the server to use the current time rather than the time that the page was loaded.

So within your finish button logic go ahead and change this &_fid_8="&ToTimeOfDay(Now()) to this &_fid_8=now"