+ Start a Discussion
Shravya Rama 9Shravya Rama 9 

Auto Updating Picklist value in all the records based on current time.

Hallo all,
Is it possible to change the picklist value automatically, if current time exceeds the start time field(DateTime Datatype) value by 15 minutes. This condition should be automatically updated to all the records of the object.
Thank you.
Best Answer chosen by Shravya Rama 9
YogeshMoreYogeshMore
Hello Shravya,

You can use formula DateTime field where store 45 min before the actual datetime. Then use Time Based Workflow Rule after the 1 hour of formula DateTime field.

Use Following formula.
Date__c - (1/32.0)

Let us know if it helps you.

Regards,
Yogesh More

All Answers

YogeshMoreYogeshMore
Hello Shravya,

You can achieve above requirement by Time-Based Workflow Rule.

Regards,
Yogesh More
more.yogesh422@gmail.com || Skype:-yogesh.more44
 
Shravya Rama 9Shravya Rama 9
Hello Yogesh,
The minimum time denomination for Workflow time trigger is hour and is not accepting decimals. But requirement is in minutes.
hybin joseph 2hybin joseph 2
Hi Shravya,

U can take a look at this blog... Its pretty Awesome it shows u how to the 15 minute thing using Time Based workflow : 

https://sftipshack.wordpress.com/2013/10/21/the-5-minute-time-based-workflow-or-15-minute-or-30-minute/

Let me know how that went and if u have any questions
YogeshMoreYogeshMore
Hello Shravya,

You can use formula DateTime field where store 45 min before the actual datetime. Then use Time Based Workflow Rule after the 1 hour of formula DateTime field.

Use Following formula.
Date__c - (1/32.0)

Let us know if it helps you.

Regards,
Yogesh More
This was selected as the best answer