Assume when the status is 'hot' on order object. After 30th day the order will be deleted.
Is it possible to create formula field as date. When ischange status is hot the formula field value update TODAY() + 29.
Thanks in advance
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
I don't think formula field is the solution for this as Formula fields are calculated at run-time which means if you use today()+29, Everytime you open a record the formula field will show the date 30 days later.
What you can rather do is, You can right a process builder which checks for "if status is changed to Hot', If yes, Then It will update a date field as Today()+29 .
To delete a record, you can right a Flow, this flow you can call from the process builder that you have created.
Hope it answer your query!