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

Question

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.

Yogesh More · Accepted Answer

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

Hybin Joseph · Answer

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

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

Formulas

Aprendizagem relacionada

Mais ajuda