Bartec Collective - Check Service Requests
- What is it? This formula will determine if a property already has an existing service request matching a particular status, bin type and request type.
Setup
The formula requires integration with Bartec Collective to be configured. This can be done under Settings > Integrations > Bartec Collective.
Inputs
This formula requires 4 inputs to be passed through to it:
-
the UPRN of the property to check.
This should be mapped to the property identifier element of an address lookup question.
-
the bin type to check against
-
the service request type to check against
This is used only to populate the options for the status input.
-
the status to check against
Return values
| Value | Description |
|---|---|
| Yes | If the property specified has a matching service request of the specified status, request type and bin type |
| No | If not |
| error | If an error occurred querying Collective |
| Note: return values are case sensitive |
Formula Logic
-
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 error.
-
The formula calls ServiceRequests_Get, passing the UPRN and status.
-
For each record returned, the ServiceCode parameter is passed to ServiceRequests_Detail_Get.
-
If this is returned successfully, the extended data fields from it are processed, to find one with a Name of 'FeatureType'.
-
The value of the 'FeatureType' extended data field is compared to the specified bin type in a case-insensitive manner. If they match, the result of the formula is Yes.
-
If no returned service request record has a matching feature type, the formula result is No.