I have a custom list that is being used as a "ticket" system for requests from users to our technical group. We have 3 different "departments" who work these tickets, each with a corresponding "status" field with choices for "not started", "in progress" and "complete".
I would like to add 3 timestamp fields (one for each department) that populate the date and time when the status is changed to "complete" for that particular group. This timestamp needs to be "locked-in" so that it doesn't change when the form is modifed by others. I've experimented with the date and time functions (including "today") but am unable to keep the field from changing on subsequent form edits.
The caveat to this is that the powers-that-be in our organization have blocked SharePoint Designer from being used with the sites, so no customization or custom workflows (we're limited to Approval and Three-State!). I have managed to get InfoPath though, so there's at least some flexibility. I am assuming that this can be accomplished with some code? If so, I would appreciate some help getting pointed in the right direction please.
Many thanks in advance!