Jira Automation - handling empty fields on static rule

Ron Aisen

Hi,

I've created a jira automation that creates a table in the description field based on custom fields I added to the form, and I'm also calculating the sum of all items i.e if I have an order for 10 devices it will calculate each device type unit * price per table row and in the bottom of the table will post the total of all devices:

 

Here is the automation rule:

||*Needed Device*||*Quantity*||*Cost Summary*|| |{{issue.Needed Mobile Device New}}|

{{issue.Quantity New}}|{{#=}}{{issue.Needed Mobile Device New.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New}}{{/}}| |

{{issue.Needed Mobile Device New 2}}|{{issue.Quantity New 2}}|{{#=}}{{issue.Needed Mobile Device New 2.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 2}}{{/}}|

|{{issue.Needed Mobile Device New 3}}|{{issue.Quantity New 3}}|{{#=}}{{issue.Needed Mobile Device New 3.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 3}}{{/}}|

|{{issue.Needed Mobile Device New 4}}|{{issue.Quantity New 4}}|{{#=}}{{issue.Needed Mobile Device New 4.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 4}}{{/}}|

|{{issue.Needed Mobile Device New 5}}|{{issue.Quantity New 5}}|{{#=}}{{issue.Needed Mobile Device New 5.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 5}}{{/}}|

|{{issue.Needed Mobile Device New 6}}|{{issue.Quantity New 6}}|{{#=}}{{issue.Needed Mobile Device New 6.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 6}}{{/}}|

|{{issue.Needed Mobile Device New 7}}|{{issue.Quantity New 7}}|{{#=}}{{issue.Needed Mobile Device New 7.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 7}}{{/}}|

|{{issue.Needed Mobile Device New 8}}|{{issue.Quantity New 8}}|{{#=}}{{issue.Needed Mobile Device New 8.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 8}}{{/}}|

|{{issue.Needed Mobile Device New 9}}|{{issue.Quantity New 9}}|{{#=}}{{issue.Needed Mobile Device New 9.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 9}}{{/}}|

|{{issue.Needed Mobile Device New 10}}|{{issue.Quantity New 10}}|{{#=}}{{issue.Needed Mobile Device New 10.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 10}}{{/}}|

Total = ${{#=}}({{issue.Needed Mobile Device New 2.getValue().substringAfter("$")}} * {{issue.Quantity New 2}}) + ({{issue.Needed Mobile Device New 2.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 2}}) + ({{issue.Needed Mobile Device New 3.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 3}}) + ({{issue.Needed Mobile Device New 4.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 4}}) + ({{issue.Needed Mobile Device New 5.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 5}}) + ({{issue.Needed Mobile Device New 6.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 6}}) + ({{issue.Needed Mobile Device New 7.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 7}}) + ({{issue.Needed Mobile Device New 8.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 8}}) + ({{issue.Needed Mobile Device New 9.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 9}}) + ({{issue.Needed Mobile Device New 10.getValue().substringAfter("$").remove(",")}} * {{issue.Quantity New 10}}){{/}}

 

Problem is that this handles full 10 fields per each device, so if for example I'm only ordering one or two devices I get an error for the '*'  operand that the automation can't resolve it, any suggestions on how to solve it without creating massive if blocks per each situation?

Manon Soubies-Camy

Hi @Ron Aisen,

You can use | to provide automation rules with default values if your field is empty, for example:

{{#=}}{{issue.story points|1}} * 5{{/}}

If the Story points field is empty, then it'll be replaced with value 1.

Hope this helps!

- Manon