nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

formula field scoring

Kuanysh Belsariyev

@Alex Medved _ConfiForms_ Hello!

I need to set up value scoring.

I use the FORMULA field type.

After saving the form, everything is displayed correctly

But, I need the sum of all fields to be displayed before saving

For example:
Here I want to see the result

I use expression ([entry.s11]+[entry.s22])+([entry.s33]+[entry.s44])+([entry.s55]+[entry.s66])

how to make calculation before saving the form?

Accepted answers

Alex Medved _ConfiForms_

This usually happens when the references to field values, such as [entry.s11] result in empty values

Consider using ZEROIFEMPTY wrapping function

https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

(ZEROIFEMPTY("[entry.s11]") + ZEROIFEMPTY("[entry.s22]") + ZEROIFEMPTY("[entry.s33]") + ZEROIFEMPTY("[entry.s44]") + ZEROIFEMPTY("[entry.s55]") + ZEROIFEMPTY("[entry.s66]"))

Alex

All comments

Alex Medved _ConfiForms_

This usually happens when the references to field values, such as [entry.s11] result in empty values

Consider using ZEROIFEMPTY wrapping function

https://wiki.vertuna.com/display/CONFIFORMS/Supported+math+operators%2C+formulas+and+functions

(ZEROIFEMPTY("[entry.s11]") + ZEROIFEMPTY("[entry.s22]") + ZEROIFEMPTY("[entry.s33]") + ZEROIFEMPTY("[entry.s44]") + ZEROIFEMPTY("[entry.s55]") + ZEROIFEMPTY("[entry.s66]"))

Alex

Alex Medved _ConfiForms_

how to make calculation before saving the form?

Formula is calculated on submit

Use the "Set expression" rule instead, and not the formula field, but something like a read-only field

Kuanysh Belsariyev

@Alex Medved _ConfiForms_ thank you! Now it works well. I did it by "set expression"

In this scoring i have few statuses that depends on points

for example

<=5 -"take on the task"
<21 - "send to backlog"

<41 - "refine the idea"

So, how can I set up to automatically choose status that depend on points? Before saving the form

Alex Medved _ConfiForms_

Add 3 more rules with a “set value” as an action that execute for each condition, all bounded to the field that you set with a “set expression” rule

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

data-center

confiforms

confluence-data-center