How to create an automation to update a custom date field in Product Discovery

Leah Maggin

I am trying to create an automation that will automatically set my custom field 'Target Finish Quarter' to be the value of the 'Target Start Quarter' in my Jira Product Discovery project.

First - I can't seem to find where the custom ID is for custom fields created in Product Discovery. 

Second: This is what I have set in the advanced field editing but it doesn't work.

 

{"fields": {"Target Finish Quarter": [{"id": "{{issue.TargetStartQuarter}}"}]}}

 

Bill Sheboy

Hi @Leah Maggin 

To find the smart value (or custom field id) of any fields which automation rules support, please try using this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

Essentially you identify an example issue with your field, call a REST API function with a browser tab, and then search for your field on the page, such as with CTRL-F.  If you find your field, the smart value and custom field id will be present.  If not, the field is not supported by rules.

 

Next, "date" fields in JPD are actually an array of two text values representing dates...or at least that is what automation rules can see.  (There isn't a lot of documentation on what does / does not work for automation rules and JPD.)

If those are both JPD "date" fields, I recommend first trying to set it directly by selecting the field from the drop-down list (in the Edit Issue action) and entering the smart value for the "Target Start Quarter" field's custom field id.

If that does not work, review what you saw in the how-to article for the field format, and then use the same to set it with advanced edit with JSON.  An example I saw for a JPD "date" field looked like this, which is essentially all text:

"customfield_12345": "{\"start\":\"2023-10-18\",\"end\":\"2023-10-18\"}"

And so you would need to try building it the same way from the source field.

Kind regards,
Bill