Versions Compared

Version Old Version 2 New Version 3
Changes made by

Paul Pasler

Paul Pasler

Saved on

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":"att77594625","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"}

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

The formula field facilitates custom calculations through:

  • Placeholders (e.g., {{fieldname}}) — Note that these are not Jira smart values.

  • Operators: addition (+), subtraction (-), multiplication (*), division (/), and parentheses (())

  • Number constants.

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

image-20240129-123952.png

There’s an autocomplete to add field placeholders. Just write “{{“ and see recommendations.

Info

Note that the number of allowed placeholder values is limited to 5.

image-20240129-125233.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

Info

Find out more: https://help-seibertmedia.atlassian.net/wiki/spaces/ACF/pages/41058312/Shared+stuff+DRAFT#Choosing-Color-based-on-Value

Field view and edit

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_10342 (Advanced Number) with the value 8 is inserted into the formula.

image-20240129-132035.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_10342 (Advanced Number) is unset (None), and therefore, it can't be used for a calculation.

image-20240129-132414.png

Error codes

No Value: This indicates the absence of a specified formula.

Invalid Value: This error arises when the designated field, possibly deleted, lacks placeholders, or if one or more field values remain unset. Furthermore, it occurs if the field value type is non-numeric.

Syntax Error: This signifies an invalid formula, rendering it unassessable. The error code is triggered by the use of forbidden characters; permitted characters include +, -, *, /, 0-9, ., parentheses, and spaces.

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 the screen.

image-20240129-125846.png

Preview

image-20240129-125612.png

Related Use Cases

Info

More use cases are coming soon. In the meantime, check out our other use cases.

Jira Service Management (JSM)

Warning

The Advanced Formula field is currently not available for 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"}