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; } } }

Confiforms Checkbox Group Values

Randy Frennette

Hello, having some trouble. I have a bunch of fields and they are all Checkbox group (ID 1, Label=Yes, ID 2, Label=No) I simply want a field definition rule that will "Set Value" in my Total Field instead of it showing the formula. The formula evaluates correctly so I was expecting Total to equal 1 + 1 for a total of 2? The formula I cannot create is to calculate the number of checkboxes with "Yes" checked. I am aware the formula will go into "Value to Set" Total = (EQUALS("[entry.Response1]", "Yes") + EQUALS("[entry.Response2]","Yes") + ....) where sum is all of the fields that are equal to "Yes" which I thought may evaluate to 1 if true and 0 if false.

Any direction would be appreciated.

Thanks,

Accepted answers

Alex Medved _ConfiForms_

Hi @Randy Frennette

If I understand you correctly then you will need to use the "Set Expression" rule instead and have someting like

Total=([entry.Response1] + [entry.Response2])

Alex

All comments

Alex Medved _ConfiForms_

Hi @Randy Frennette

If I understand you correctly then you will need to use the "Set Expression" rule instead and have someting like

Total=([entry.Response1] + [entry.Response2])

Alex

Randy Frennette

Gives me the following: error com.vertuna.confluence.plugins.confiforms.util.Expression$ExpressionException: Too many operators or functions at: +

However I got it working with this:

Total=ZEROIFEMPTY("[entry.Response1.label:Yes]") + ZEROIFEMPTY("[entry.Response2.label:Yes]")

Please confirm the following:

ID appears to be the value of the label. I thought it was just a key. For example. I have Checkbox Group ID 1 = Label Yes and ID 0 = Label No. In Set Expression rule above it adds up to 2 which is perfect. If I change ID 2 = Label Yes it add to 4. This is wonderful to evaluate different weightings of questions. I could say Response1 answer yes is worth 1 point where a more important Response2 could be worth 3 points.
The adding of ZEROIFEMPTY got rid of an error on total line when form loads and nothing checked yet.

Alex Medved _ConfiForms_

Well, if you allow empty values then - Yes, you need to account and handle that and ZEROIFEMPTY is a good helper function

ConifForms stores IDs that you define for your choice based fields

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms