Creating a recurring project
We have some projects that are "service contracts". The customer wants some work to be repeated at set intervals, e.g. every 6 months or every 12 months.
I want to automate this handling in the project board:
- If the "start date" of a project is less than 1 month from current date, move the project to project phase "soon to be started".
- If the project phase is "done", move the project phase back to start and calculate a new start and end date.
I have created a custom field "interval" in projects which holds the number of months.
This should be a relatively simple automation. The problem however i am facing is that there seems to be no possibilty for "scripting" in the workflow automation. For example this automation would require some simple date calculations (new start date = current date + interval). It seems this is not possible currently.
How should i go about to solve this task?