Jadu Connect - Case date for a specific case
- What is it? This formula will return a particular date from the specified Jadu Connect case.
Setup
The formula requires integration with Jadu Connect to be configured. This can be done under Settings > Integrations > Jadu Connect.
Inputs
This formula requires 4 inputs to be passed through to it:
-
the Jadu Connect case reference
-
the Jadu Connect case date field to return
-
whether to include the time
-
whether to run as the signed in user
This determines whether the request to Jadu Connect is sent using the signed in account, or the Jadu Connect API key permissions. The signed in account may have different permissions to the API key, causing the result of the formula to differ.
Caching
When retrieved from Jadu Connect, the case is cached by Jadu Central for the remainder of the current page load. This means that any subsequent formulae that need to access the case will not need to retrieve it from Jadu Connect.
Return values
| Value | Description |
|---|---|
| The specified date from the case | If the case exists and can be accessed. |
| An empty string | Otherwise. |
Note: return values are case sensitive
Formula Logic
-
The case with the specified reference is obtained from Jadu Connect
-
If the case is accessible, the result is the specified date from this case. Otherwise the result is an empty string.