There is a field (helper) which is choice type in a record with values "first", "second", "third". Based on the created date and current time, the value in that field is getting updated.
For example-
if date_created and current_time difference is 5 minutes then it should be set to "first". Similarly, if the difference is 10 minutes then the value in helper field will be "second", else "third".
How can I achieve this requirement?
I'm thinking of using scheduled job with every second update but this will have performance implications. Please suggest any alternatives to achieve this.
NOTE- This outcome should keep triggering automatically for all records without any condition. I tried using calculated field but that only triggers at form loading.
