Jump to content
  • 0

'Freeze' Field When Given A Value


kpcollier

Question

I have Date/Time fields that take in a timestamp for each Status a record is updated to. This is so we can see how long it took to get to each phase of our work. The workflow I have works great, however, if an employee wanted to forge this value, they could quickly switch the status and switch it back, recording a new date for the status timestamp.

Is there a way to 'freeze', or disable, a field so that once it receives a value for the first time, that value can never be changed again?

I'm using Date/Time fields instead of Timestamps because these fields are based off a value from a dropdown and not just on update. There are many other fields that will be updated that would trigger the update timestamp when not intended to do so. Therefore, I need to stay away from Timestamp fields.

Here is the trigger that fills in the 'timestamp' fields. Here, you could see how vulnerable these fields are. They can easily be changed. I'm not sure if making the field 'readonly' through javascript would prevent the trigger from updating the field itself.

 

 

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...