Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Appanvil karma designer
summary Advanced Formula The Advanced Formula field empowers you to perform custom calculations with ease, utilizing field value placeholders, operators, and number constants. It features auto-complete for simplicity, enhanced error hints for troubleshooting, and supports custom rendering.
page{"premium":true,"name":"page","children":[{"id":"lfi8jBK4QX7bZqV_gWgeY","params":{"padding":0,"gap":10},"children":[{"id":"4CbdZ7_dJ3MWntvqkjFGj","name":"row","children":[{"id":"Ml3GxyZGc0_1glcmlCN5T","name":"column","children":[{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"letterSpacing":0,"text":"Advanced Formula","fontFamily":"unset","fontWeight":700,"color":{"light":"#ffffff"},"fontSize":38,"lineHeight":"38px"}],"align":"left"}]}]},"children":[],"id":"D-3o-sTBlkZadeqUR9Lvu"},{"name":"text","params":{"templateId":"simple paragraph","value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"fontSize":16,"letterSpacing":0,"fontFamily":"unset","color":{"light":"#ffffff"},"lineHeight":"24px","text":"The Advanced Formula field empowers you to perform custom calculations with ease, utilizing field value placeholders, operators, and number constants. It features auto-complete for simplicity, enhanced error hints for troubleshooting, and supports custom rendering.","fontWeight":300}]},{"type":"paragraph","children":[{"fontSize":16,"lineHeight":"24px","color":"#555","letterSpacing":0,"fontFamily":"Open Sans, sans-serif","text":""}]}]}]},"children":[],"id":"qKhLt_zHxxujmz0UxfE5d"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"rbN56ddPTY151_82JQ3aq","name":"column","children":[{"name":"image","params":{"templateId":"full-width rounded","alignment":"center","position":"center center","borderRadius":{"all":0,"bbl":0,"bbr":0,"btl":0,"btr":0,"isIndividualCorners":false},"image":{"value":"att101416969","target":"_blank","type":"attachment"},"shouldOpenDialog":false,"width":280},"children":[],"id":"IHu1TOIZOzh3zv5Knf1fu"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"A8gNlWXe1IOREb1gCyZgH","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"7tfYpIybnZmE7i-vXXYHG","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"6TF--QtVlrhBL6e_JEMgp","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}},{"id":"ZDmuwcveLIDZdH2zmRUrN","name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"}}],"params":{"layout":[1,1],"gap":10,"minHeight":420,"padding":50,"borderRadius":25,"size":"full","backgroundColor":"#592360bf","backgroundImage":{"value":"att55345153","target":"_blank","type":"attachment"}}}],"name":"section"}],"id":"SK_jc3s-_GRiwqh2cB5Tn"}
Info

Be aware that the syntax of the field has been recently modified.

Since the we are using Jira Expressions for the formula. Find details on this page below.

On this page

Table of Contents
minLevel1
maxLevel2
include
outlinefalse
indent
excludeOn this page
typelist
class
printablefalse

Field configuration

Info

Before starting the field configuration, please follow the instructions for creating custom fields

Create a Custom Field

Step 1: Set a name and description

Provide a good name for the new custom field. Make it descriptive, concise, and easy to understand for others who will use it. Avoid using ambiguous or overly technical terms.

image-20240129-122910.png

Step 2: Add formula

To derive a numerical result from a formula, you can employ Jira Expressions for calculation.

For instance, the formula (issue.customfield_10060 + 5) * 2 will be computed with the issues' field value of customfield_10060 (e.g. 8) to yield (8 + 5) * 2 = 26.

The outcome of the calculation must be a numerical value. Any other results will result in a validation error.

Info

If you configured the field using the old syntax {{customfield_10060}}, it undergoes on-the-fly migration. Simply saving the configuration again resolves this issue.

image-20240221-105826.png

There’s an autocomplete to add field placeholders. Just write “issue.“ and see recommended number fields.

image-20240221-110426.png

Step 3: Setup output format, size and color based on value

The decimal toggle lets you switch between integer and up to two decimal places.

The field allows you to choose from a pre-defined set of field sizes.

You may also set different colors for different values.

image-20240129-123346.png

No edit mode

Values are derived from other issues' field values, and users cannot modify the calculation settings.

However, users can observe the calculation process. In this instance, the customfield_10060 with the value 4 is inserted into the formula.

image-20240221-110831.png

Formula validation

On the other hand, users receive hints in case of an error to understand what went wrong.

In this case, the value of customfield_10060 is unset (None), and therefore, it can't be used for a calculation.

Info

You may resolve this by providing a default value by using boolean operators like this (issue.customfield_10060 || 17).

image-20240221-111230.png

Not available in create issue

As you cannot edit the value manually, you can’t set it when creating a new issue. Better make sure it’s not displayed in this screen.

image-20240129-125846.png

Preview

image-20240129-125612.png


Use nested field properties

There are custom fields of type 'object' that contain nested numerical properties you may wish to leverage. For instance, by utilizing the value of another Advanced Formula field. The data structure is outlined below: https://help-seibertmedia.atlassian.net/wiki/spaces/ACF/pages/edit-v2/77037570#Data-Structure-(Automation).

image-20240221-113537.png


How to find custom field key?

If you intend to utilize field values of a type other than a number, these fields will not appear in the autocomplete. However, you can manually add them by determining the custom field key. This can be accomplished as follows:

  • Go to: Settings > Issues > Custom Fields

  • Choose the desired custom field and click edit

  • You find the id in the URL

  • Now you can add the field in your formula like this: issue.customfield_<id>

image-20240221-112435.png


Related Use Cases

Filter by label (Content by label)
showLabelsfalse
maxCheckboxfalse
showSpacefalse
reversefalse
excerptTypesimple
cqllabel = "advanced-formula" and parent = "50233365"

Jira Service Management (JSM)

Note

Please note that this field is interdependent, relying on other field values or subtasks. It is essential to populate or update the field initially through loading the issue view of the request, typically performed by an agent. Failure to do so will result in these fields remaining empty and consequently not displayed on the request view.

Info

Before you can add a custom field for Jira Service Management (JSM) projects, you first need to setup the custom field

https://help-seibertmedia.atlassian.net/wiki/spaces/ACF/pages/edit-v2/77037570#Field-configuration

Then follow this guide to use the field in the request form or the portal view

Add Custom Fields to Jira Service Management


JQL expression

Note

The value is calculated just in time and saved as a field value, but there may be a delay in updating when a placeholder field value changes.

The sum field is an object type with a property Formula Result.

Code Block
${fieldName}.Formula Result: number
Info

Find further information here https://support.atlassian.com/jira-software-cloud/docs/find-specific-issues/

Example: a search for all issues with a calculation result greater than 5

Code Block
"Advanced Formula.Formula Result" > 5

Data Structure (Automation)

Info

Use custom fields with automation

Note

As the value is calculated, we don’t recommend to edit it manually or by automation!

To set the value via automation, you need the following object structure

Code Block
{
  "value": number
}
Appanvil karma designer
summary We Are Here To Help Live Demo Reach out to our product team to explore how we can turn your use case into reality together. SCHEDULE FOR FREE Support Our dedicated team is here to assist you with any questions or challenges you may encounter. CONTACT US Feature Request Got an idea for a custom field, a new feature or a particular use case? We're delighted to hear about it! SUBMIT YOUR IDEA Happy? Please let the community know! If you're enjoying your experience with Awesome Custom Fields, we'd love to hear about it! Your feedback helps us grow and improve. RATE US ON THE ATLASSIAN MARKETPLACE
page{"premium":true,"name":"page","children":[{"params":{"background":"#ffffffdb","padding":25,"gap":10},"children":[{"name":"row","children":[{"name":"column","children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"We Are Here To Help","fontFamily":"unset","fontWeight":700,"fontSize":28,"color":"#061D28","letterSpacing":-1}],"align":"center"}]}]},"children":[],"id":"kWu6dge9G0gVC5soph63Y"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"TA7C-YTgUAGxaY7Ee1gRb"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"3i3tuA9baYMqpBLTOLUVc"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"h6cp_tv_STHfWn5o3lxmV"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"EGTJWjOhl3e0azF9InNKw"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"_aGWOlhpSc1ZY65NzVdAm"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"center"},"id":"9giTj4HKBu8xiguLdZzzj"}],"params":{"layout":[1],"gap":95,"minHeight":100,"padding":0,"borderRadius":0},"id":"8WDed0wGD_SmsvGJ2_kN1"},{"name":"row","children":[{"name":"column","children":[{"name":"card","params":{"gap":5,"padding":40,"borderRadius":{"all":25,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#061D280d","hover":"none","isMediaFullSize":true},"children":[{"name":"icon","params":{"shape":"none","color":"#592360","alignment":"center","size":40,"icon":"message"},"children":[],"id":"Z1Y44UTZStMftN5ADWiVY"},{"name":"spacer","params":{"space":0},"children":[],"id":"677H5JgBfLb8m28Mtebd4"},{"name":"text","params":{"value":[{"type":"paragraph","align":"center","children":[{"fontWeight":700,"text":"Live Demo","fontFamily":"unset","letterSpacing":-1,"color":"#061D28","fontSize":24}]}]},"children":[],"id":"mpRVFLlCI25vevGb3eJCv"},{"name":"spacer","params":{"space":0},"children":[],"id":"8XXoV2IrTUIn8gdAR7Hl1"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Reach out to our product team to explore how we can turn your use case into reality together.","lineHeight":"22px","fontSize":16,"fontWeight":300,"fontFamily":"unset","color":{"light":"#061D28bf"}}],"align":"center"}]},"children":[],"id":"bWSJwQIvn3Ie-4z6u4yYf"},{"name":"spacer","params":{"space":10},"children":[],"id":"kIzR6deJ2rDxjfzPYiYPO"},{"name":"button","params":{"label":"SCHEDULE FOR FREE","size":"medium","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":{"light":"#592360"},"label":"#ffffff"}},"hover":{"colors":{"background":"#061D28","label":"#ffffff"}}},"link":{"value":"https://seibert.biz/acf-jira-demo","target":"_blank","type":"link"}},"children":[],"id":"Q9dYEVl9px0gdQ1WnYKX8"}],"id":"2Po0kyK2zYZXZqa9LqP0o"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"qqolZyQAzfI5BSIxawq_4"},{"name":"column","children":[{"name":"card","params":{"gap":5,"padding":40,"borderRadius":{"all":25,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#061D280d","hover":"none","isMediaFullSize":true},"children":[{"name":"icon","params":{"shape":"none","color":"#592360","alignment":"center","size":40,"icon":"video"},"children":[],"id":"iKb4T95bSuayqtVU2WvT2"},{"name":"spacer","params":{"space":0},"children":[],"id":"C9E-5DbXFfOePqxgaVv59"},{"name":"text","params":{"value":[{"type":"paragraph","align":"center","children":[{"fontWeight":700,"text":"Support","fontFamily":"unset","color":"#061D28","letterSpacing":-1,"fontSize":24}]}]},"children":[],"id":"42fnG42m1q63TAHqlatD8"},{"name":"spacer","params":{"space":0},"children":[],"id":"Up3Dlqu3WzfWUFEHhDzzQ"},{"name":"text","params":{"value":[{"type":"paragraph","align":"center","children":[{"lineHeight":"22px","fontSize":16,"fontWeight":300,"fontFamily":"unset","color":{"light":"#061D28bf"},"text":"Our dedicated team is here to assist you with any questions or challenges you may encounter."}]}]},"children":[],"id":"RdMlkf8DDAywMUhigVewc"},{"name":"spacer","params":{"space":10},"children":[],"id":"VjOP2jLer2IJDhjjFrkh4"},{"name":"button","params":{"label":"CONTACT US","size":"medium","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":"#592360","label":"#ffffff"}},"hover":{"colors":{"background":"#061D28","label":"#ffffff"}}},"link":{"value":"https://seibert.biz/acf-support","target":"_blank","type":"link"}},"children":[],"id":"zWdNPa1-8fPFrITd5CRWQ"}],"id":"sdFCdxMvutzMPkQrayBRo"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"cRM7MP2uZbvz8GDQqBk4O"},{"name":"column","children":[{"name":"card","params":{"gap":5,"padding":40,"borderRadius":{"all":25,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#061D280d","hover":"none","isMediaFullSize":true},"children":[{"name":"icon","params":{"shape":"none","color":"#592360","alignment":"center","size":40,"icon":"lightbulb"},"children":[],"id":"E3plCsiLcHFR7kdTZ3uh0"},{"name":"spacer","params":{"space":0},"children":[],"id":"aFplX1cwDLXAhvY46q-W2"},{"name":"text","params":{"value":[{"type":"paragraph","align":"center","children":[{"fontWeight":700,"text":"Feature Request","fontFamily":"unset","fontSize":24,"color":"#061D28","letterSpacing":-1}]}]},"children":[],"id":"BcuoiAmvhSjjm22Xlx-Zi"},{"name":"spacer","params":{"space":0},"children":[],"id":"5SPT1m3nSbGpRkzUSGkNQ"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"text":"Got an idea for a custom field, a new feature or a particular use case? We're delighted to hear about it!","lineHeight":"22px","fontSize":16,"fontWeight":300,"fontFamily":"unset","color":{"light":"#061D28bf"}}],"align":"center"}]},"children":[],"id":"FXZlRMJIo04iEApkTJ5uf"},{"name":"spacer","params":{"space":10},"children":[],"id":"G0aEXlwfOQg5pPmdG769l"},{"name":"button","params":{"label":"SUBMIT YOUR IDEA","size":"medium","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"background":"#592360","label":"#ffffff"}},"hover":{"colors":{"background":"#061D28","label":"#ffffff"}}},"link":{"value":"https://seibert.biz/acf-jira-canny","target":"_blank","type":"link"}},"children":[],"id":"TndEd3qGeLVoOfTV-UK0M"}],"id":"vJKyOjRwZT793hiF3jpaW"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"Vcp-xCpiaOJ1OgpCcUmrK"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"U2x4wTqqD7e8zKQGsJMit"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"w-pJgS03czaf-7VsNnicx"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"goqg8VQFURBruWHQix_u9"}],"params":{"layout":[1,1,1],"gap":30,"minHeight":200,"padding":10,"borderRadius":0},"id":"ttMxbhfEeDSEE5J9b1ylq"},{"name":"row","children":[{"name":"column","children":[{"name":"card","params":{"gap":5,"padding":40,"borderRadius":{"all":25,"isIndividualCorners":false,"bbl":0,"bbr":0,"btl":0,"btr":0},"background":"#F4A638","hover":"none","isMediaFullSize":true},"children":[{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","children":[{"text":"Happy? Please let the community know!","fontFamily":"unset","fontWeight":700,"fontSize":28,"letterSpacing":-1,"color":"#061D28"}],"align":"center"}]}]},"children":[],"id":"FEw7soDxxpAUoLhcd9h2L"},{"name":"spacer","params":{"space":10},"children":[],"id":"ZJFO7V_OyKEr9aqQpqjf_"},{"name":"text","params":{"value":[{"type":"paragraph","children":[{"type":"paragraph","align":"center","children":[{"lineHeight":"22px","fontFamily":"unset","fontWeight":300,"text":"If you're enjoying your experience with Awesome Custom Fields, we'd love to hear about it! Your feedback helps us grow and improve.","fontSize":16,"color":"#061D28"}]}]}]},"children":[],"id":"fis3eCnZ4Rk06ocER71aI"},{"name":"spacer","params":{"space":10},"children":[],"id":"lu9ZtKSJwVKaQJPzC4nF8"},{"name":"button","params":{"label":"RATE US ON THE ATLASSIAN MARKETPLACE","size":"medium","shape":"rounded","alignment":"center","states":{"idle":{"colors":{"label":"#061D28","background":"#FFFFFF"}},"hover":{"colors":{}}},"icon":"atlassian","link":{"value":"https://seibert.biz/acf-jira-review","target":"_blank","type":"link"}},"children":[],"id":"EY2XBenZv6D87mKtPV1P9"}],"id":"XY5jSIYepg1dSLnlYX_DI"}],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"KFn73jQI2GT_KYb3ObEFy"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"aNF1fisyXhPE46rSL_Dcp"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"zgolu1bSBaJkCWExZ2ZNG"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"q81-aXYsVxiqUuHX8YeZb"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"9ey56XpyhDK4P8mR0hgZ1"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"O7forrBOsWYxlm3Akj6lw"}],"params":{"layout":[1],"gap":10,"minHeight":200,"padding":10,"borderRadius":0},"id":"qdowOjlJr1wH8GsbFPLpY"},{"name":"row","children":[{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"ya1QFmMoDBOLD-iC7rr4R"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"emiYPcj7_m0x6UHFHX9B8"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"lYVjH6TEpYfsS-sPAnc4u"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"bXpBRoo3xp_HsOUPjwZGN"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"DP9_7qYIKbNqA-Uyauxnv"},{"name":"column","children":[],"params":{"borderRadius":{"all":0,"btl":0,"bbl":0,"btr":0,"bbr":0,"isIndividualCorners":false},"padding":0,"gap":20,"verticalAlignment":"top"},"id":"K8vjA2q828pLEsByMS7ss"}],"params":{"layout":[1,1,1],"gap":10,"minHeight":100,"padding":10,"borderRadius":0},"id":"LZ2-LqKoaOBoZ-pM6l_SX"}],"name":"section","id":"75I95QtLPK9ThfFXu_B3-"}],"id":"SK_jc3s-_GRiwqh2cB5Tn"}