<div dir="ltr"><div>I added a custom field to troubletickets a long time ago to get a date/timestamp for when the status was updated to 'Closed'. There's a workflow that was added to update that field with the current date and time when the status field changed to that value, and it was only set to trigger on the 1st occurrence. It was working great - until I discovered many tickets that were edited afterwards were having the value removed (set to 0000-00-00 00:00:00). I played around with permissions, field type, visibility. Finally, I just came up with SQL scripts to find the records that were affected and update them.</div><div><br></div><div>Later, it was becoming more of a  problem. That was when I found that the user's calendar preferences were the culprit. If they chose anything other than yyyy-mm-dd as their date format, that's when the field value would change. And it would change without triggering the workflow.</div><div><br></div><div>Workaround: auditing user preferences for the necessary date format. And, running a lot of other audit reports to make sure the field is properly populated because it is a criteria for a lot of other activities (like billing). <br></div><div><br></div><div>I'm looking for a <b>fix. <br></b></div><div><b><br></b></div><div>I would prefer the field be a non-editable field, like createdtime and modifiedtime. But, my main thing is that once set, it requires a deliberate action to change it, not just editing something else on the record.<br></div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width:60px;height:60px;margin-right:10px"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width:30px;height:30px;margin-right:10px"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div></div>