Predefined Calculation: Whitespace PowerSuite - Next Collection Date


This formula will return the next collection date for a particular service at a given property.


This formula requires 2 inputs to be passed through to it:

Next Collection Date Inputs

  • the UPRN of the property

    The mapped value must come from an address lookup question, using the propery_identifier variable option.

  • the Service ID

    This input should be set to the ID of the Service to check against in Whitespace PowerSuite.

Return values

Value Description
The next collection date If there is one found for the Service, in YYYY-MM-DD format
An empty string If there is no date found, or an error occurred.

Formula Logic

  1. 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 an empty string.

  2. A call to Whitespace PowerSuite's GetSiteCollections endpoint is made, passing the UPRN.

  3. The returned collections are iterated over until one has a ServiceID property which matches the Service ID input.

  4. If a matching collection is found, the NextCollectionDate property is returned. Otherwise, an empty string is returned.

results matching ""

    No results matching ""