Predefined Calculation: Northgate M3PP / Assure - Count property assets of type(s)
This calculation will count the number of assets that are of a type specified, for a particular property in M3PP / Assure.
The formula requires connection to a Jadu hubIS instance, which can be configured in the Integrations page. Your Jadu hubIS instance should be configured to connect to your M3PP / Assure instance. For help setting up and configuring hubIS, contact Jadu Support.
This formula requires the following inputs to be passed through to it:
- the name of the M3PP / Assure instance as configured in Jadu hubIS
- the UPRN of the property to check
- the asset type(s) to count
The mapped value for the UPRN must come from an address lookup question, using the property_identifier variable option.
|integer||The number of assets matching one of the specified asset types|
|false||If an error occurs|
Note: return values are case sensitive
A check is made to see if the integration has been enabled in the Settings > Integrations page. If the integration is not enabled the formula returns false.
A call is made to GetAssets passing in the UPRN input. This returns all the assets set on a property. If the call fails, the result is false.
All returned assets are examined to find any with an ASSETTYPE matching the asset type input.
The result is the number of matching assets.