[Vtigercrm-developers] Has anyone else had a problem with a user's date format preference interfered with a custom datetime field?

[Alan Lord]

I think I'd probably use a custom Event Handler rather than a workflow 
and make the field read-only and update it directly using a query when 
the triggering event occurs. You could add a simple test to say if the 
field is not null or not empty, then don't update it - ever.

HTH

Al

On 17/12/2024 17:27, Steve Kenow wrote:
> 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.
>
> 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.
>
> 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).
>
> I'm looking for a *fix.
> *
> *
> *
> 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.
>
> *RDS Logo*
> *Steve Kenow*
> Manager, End-User Services and Support - RDS MN 
> <https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System>
> Direct: (952) 392-2686
> Office: (952) 934-4001
> Email: skenow at rdspos.com
>
> Icon 1 
> <https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b> 
> 	Icon 2 
> <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> 
> 	Icon 3 
> <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> 
> 	Icon 4 
> <https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1> 
> 	Icon 5 
> <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> 
> 	Icon 6 
> <https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55> 
>
>
> ------------------------------------------------------------------------
>
> Support Questions/Issues? Email rdshelp at rdspos.com (non-emergencies) 
> or call (952) 934-4002 24/7
>
>
> _______________________________________________
> http://www.vtiger.com/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20241217/900e0b19/attachment-0001.html>