Field Update using Workflow

Question

On a Agreement object I have End Date(date-data type) field , Auto Renew(checkbox), Terms months(number-data type), No of Terms(Data type-Number). End date should be updated based on Term month field when Auto Renew is checked.

For ex: If End date=14/07/2020 ,Contract Term Month= 12, no of terms=3, the end Date should be 14/07/2021 when Auto Renew is checked. On 14/07/2021 agreement should get auto renewed and end date should be 14/07/2022, on 14/07/2022 agreement should get auto renewed and end date should be 14/07/2023 and so on based on no of Terms value. No of Terms is for how many times it should get auto Renewed and based on that end date field should be auto updated with new value.

In Workflow condition I selected Formula evaluates to true and specified the condition i.e Auto Renew=True.Action part I gave the below condition. ADDMONTHS( End_Date_c, Term_month___c)

But I got stuck how to specify No of terms field.

Thanks in advance!

Answer 1

You need another field to keep track of which term the Agreement is currently in. Current fields:

End date = 14/07/2020
Contract Term Month = 12
No of Terms = 3

Add another field, for example:

Current Term = 1

So in your workflow, add another field update to increase the Current Term upon renewing the End Date. You renewal workflow then has to have a validation, only execute when Current Term < No of Terms.