Calculating the next milestone

You can direct Infor Public Sector to calculate which milestone will follow another milestone using a next milestone formula. For example, you could write a formula for a Finalized milestone that advances a rezoning application to a Completed milestone or advances an industrial application to a Certificate Issued milestone.

Next milestone formulas use the oPlanningApp object (an instance of the Hansen.CDR.Planning.iPlanningApplication class) to set NextState to a string value that is the exact name of the milestone that follows it. For more information about this object and for sample code, click the Information tab in the Formula Editor.

Example

This formula advances the application to a Pre-Reviews milestone if the application is for a new construction or advances to a Reviews milestone for any other work type.


If (oPlanningApp.WorkType.Code.ToUpper = "NEW") Then
  NextState = "Pre-Reviews"
Else
  NextState = "Reviews"
End If