169
I am looking for help related to the below. We use the Customer Service app to track our daily one-day projects using the Case entity. Here we have a Date & Time field “Deadline” where we keep the estimated date and time that we are planning to resolve the case. We are planning to lock this field so that a user will not be able to edit this field and another field 1 hour prior to the “Deadline”.
Is this possible and can you guide me with a few ideas if this is possible?
Thank you Dian (dian74). I tried this solution and the workaround works perfectly. This is very helpful and thank you for the prompt response.
Hi Henry,
You would be able to accomplish part of this with a work around where you would use a calculated field to determine how much time was left on the deadline and lock the deadline field based on that, but the issue with this is that if the time that is left in the deadline goes from 61 mins to 60 mins the field will not lock automatically, there would need to be a page refresh for this to happen. If you don't care about the locking of the field, and just don't want people to be able to change the data in the deadline field I would go with the following approach:
Lastly I would create a Realtime workflow that triggers after the 'Deadline' field has been changed with a check condition as shown below. This work flow will show an error if there is 60 mins or less of deadline time left.
Please mark verified if this helped solve your issue.
Yes it is possible and a common feature to set deadlines or sla limits. You would use powerautomate, logic apps or classic workflow. You trigger based on scheduled time or simpler run flow every 15 minutes or other interval checking for any date time that has passed and still have unlocked field. If unlocked then you add action to lock field.
Good luck and let me know if you need further support.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
