Predefined Calculation: Whitespace PowerSuite - Street Complete
This formula will returns true or false, depending on whether a street has any InCabLog records for the given date.
This formula requires 4 inputs to be passed through to it:
the USRN of the property
The unique identifier of the street to search for.
the Date From
A date to use as the beginning of the search period, in YYYY-MM-DD format. This date can be populated from the Date Plus/Minus Days Logic
the Date To
A date to use as the end of the search period, in YYYY-MM-DD format. This date can be populated from the Date Plus/Minus Days Logic. Whitespace PowerSuite Web Services will set the time on any date you pass into it to 00:00:00. In order to check street collections for today are complete you will need to set Date To to tomorrow.
|true||If there are InCabLog records for the given date period and USRN|
|false||If there are no logs, or an error occurred.|
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 N/A.
A call to Whitespace PowerSuite's GetInCabLogs endpoint is made, passing the USRN, Date From and Date To inputs.
If some logs are returned, the return value is true. Otherwise, false is returned.