Calculating whether to add a detail

You can use an AddOnCondition formula to calculate whether to add a detail to an application, inspection, review, or hearing. For example, you could write a formula that requires a seating capacity application detail for any construction involving a theater or cinema, or a formula that requires an environmental review detail that records the results of an environmental study.

AddOnCondition formulas use the oPlanningApp object (an instance of the Hansen.CDR.Planning.iPlanningApplication class) to set AddOnCondition to either True or False.

You can also use properties and methods of the detail objects in your formula. For example, you might want to specify the detail types that the formula applies to. To access detail properties, select the ApplicationDetail, HearingDetail, InspectionDetail, or ReviewDetail node under PlanningSignature in the Methods and Properties tree. You must also use the AssociatedRecordType node to indicate the type of record, such as AssociatedRecordType.InspectionDetail.

For more information, and for sample code, click the Information tab in the Formula Editor.

Examples

This formula adds an item if the declared value recorded in the application is greater than $250,000:

AddOnCondition = False
If (oPlanningApp.DeclaredValuation > 250000) Then
  AddOnCondition = True
End If

This formula adds an item if the application is for commercial construction:

AddOnCondition = False
If (oPlanningApp.OccupancyType.Code.ToUpper = "COMMERCIAL") Then
  AddOnCondition = True
End If

This formula adds an item if the application is for a remodel:

AddOnCondition = False
If (oPlanningApp.WorkType.Code.ToUpper = "REMODEL") Then
  AddOnCondition = True
End if