You need to sign in to do that
Don't have an account?
Shravya 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.
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.
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
You can achieve above requirement by Time-Based Workflow Rule.
Regards,
Yogesh More
more.yogesh422@gmail.com || Skype:-yogesh.more44
The minimum time denomination for Workflow time trigger is hour and is not accepting decimals. But requirement is in minutes.
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
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