How to Add a Number of Days to a Date

How to add a number of days to a date

To set this up you will need access to the Raw JSON editor

If you don’t have access to this feature, please your system administrator or email us at connect@rise-x.io

For this functionality we will be using the data pipelines functionality

What are data pipelines?

These are automatic operations that run in the background while work it happening
In this case an operation will run and take one date, add a number of days to it, then automatically populate another date component with this new date

Step by step guide

Go into the advanced editor properties panel then swap to raw json
Scroll all the way to the bottom and find the “dataPipelines”: [] property
Create a new data pipeline in the raw json properties panel

You can create a new data pipeline by typing in {} into the square brackets then let it auto save and pre-populate some of the data pipeline

Add “name” directly underneath the first “id” property
If

“stepType” defines what the type of operation is

For this example it should be “WORK_DATA_PATH_EXISTS”

Need to add a dataPath in the payload (this should be the original date component dataPath)

Then

Need to add in {} into the square brackets first and then let it autosave and it gives it a unique id automatically
Add in “stepType” property underneath “id” and set the value to “ADD_DAYS”
Add in “payload”: {} property underneath “stepType”

Add in “fromDataPath”: “”, and “toDataPath”: “”, and “numDays”: “” into the payload

Set “fromDataPath” value to be the dataPath of the original date component
Set “toDataPath” value to be the dataPath of the date which will have the added days
Set “numDays” to be the number of days to add (e.g. “60”)

Then you need to add in another {} after the “ADD_DAYS” part because you need to add another step type

Add in “stepType” property underneath “id” and set the value to “TRY_SAVE_DATA”
Add in “payload”: {} property underneath “stepType”

Add in “jsonPath”: “”, and “sectionName”: “”, and “withCalculate”: false

Set “jsonPath” value to be the same as the “toDataPath” value
Set “sectionName” value to be the task name of the task that the “toDataPath” dataPath sits on

You can find the task name by navigating to the task in the advanced editor and then copying the value from the “name” property

Set “withCalculate”: false (don’t include “” around false)

Then can add another step type (“TRY_SAVE_DATA”)

The “watchPaths” is what it is watching for to change so that the calculation runs when’s the data path changes

So for this example you would put in the original date dataPath in quotation marks

e.g. “watchPaths”[

“$.task.dateOriginal”

]

Done! You can now publish the workflow and when you enter a date into the original date component the other date component should then show the original date + 14 days

Example from raw json in the properties tab

"dataPipelines": [
      {
        "id": "505d17b4-fff6-43e0-ae94-d17a26f440a3",
        "if": {
          "id": "09e9070e-3df5-40b6-aa6a-258bab3ebbae",
          "stepType": "WORK_DATA_PATH_EXISTS",
          "payload": {
            "dataPath": "$.task.originalDate"
          }
        },
        "then": [
          {
            "id": "09e9070e-3df5-40b6-aa6a-258bab3ebbaf",
            "stepType": "ADD_DAYS",
            "payload": {
              "fromDataPath": "$.task.originalDate",
              "toDataPath": "$.task.date14Days",
              "numDays": "14"
            }
          },
          {
            "id": "09e9070e-3df5-40b6-aa6a-258bab3ebbag",
            "stepType": "TRY_SAVE_DATA",
            "payload": {
              "jsonPath": {
                "jsonPath": "$.task.date14Days",
                "sectionName": "UntitledTask/Generated-a773f114-1b71-4c71-9114-e2865b8f61b8",
                "withCalculate": false
              }
            }
          }
        ],
        "else": [],
        "watchPaths": [
          "$.task.originalDate"
        ]
      }
    ],