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

How do I write the validation rule for ensuring 2 fields match?

Bill Mills

I have 4 fields (numeric):

TotalBudget
subVendorBudget
subTranslationBudget
subOtherBudget

Logically, the 3 sub fields should total the TotalBudget fields (but not automactially calculate).

I have a 5th field (formula) called SummedBudget with this calculation and it works as desired:

("[entry.subVendorBudget]")+("[entry.subTranslationBudget]")+("[entry.subOtherBudget]")

Now I'm trying to create a validation rule to ensure TotalBudget equals SummedBudget but the validation error occurs even when they match, using these parameters:

Field name (or regular expression): TotalBudget

Condition: [entry.fldTotalBudget]:[entry.fldSummedBudget]

Action to execute *: Validation rule

Execute only on user action: unchecked

Validation rule: blank

Please help!!

Thanks,

Bill

Accepted answers

Alex Medved _ConfiForms_

Hi @Bill Mills

The condition should be something like

fldTotalBudget:[entry.fldSummedBudget]

And you should specify "Message to show..." parameter in your validation rule (nothing else is necessary)

Alex

All comments

Florian Bonniec

Hi @Bill Mills

What is the validator you are using, what app does it come from ?

Regards

Bill Mills

Hello, the numeric fields are on a confluence form and completed by the user. Sorry I'm not sure what you mean by validator; I'm a low intermediate user at best.

Thanks!

Florian Bonniec

My bad had JIRA in mind due to the field and validator thing.

WHat do you use for form in Confluence ? It does not support forms without app, are you using Confiform ?

https://marketplace.atlassian.com/apps/1211860/confiforms-data-forms-workflows?tab=overview&hosting=datacenter

Alex Medved _ConfiForms_

Hi @Bill Mills

The condition should be something like

fldTotalBudget:[entry.fldSummedBudget]

And you should specify "Message to show..." parameter in your validation rule (nothing else is necessary)

Alex

Bill Mills

Hi @Alex Medved _ConfiForms_ thanks I've tried this but have the same issue. If I don't inlclude ! at the beginning of the condition it accepts all entries even if they don't equal. If I do include ! it won't accept any entries even when they do equal.

Could this be due to fldSummedBudget is a formula field type and fldTotalBudget is numeric?

Bill Mills

No worries. Yes using confiforms. I've tried using

fldTotalBudget:[entry.fldSummedBudget]

as suggested by Alex with no luck.

Alex Medved _ConfiForms_

Could be (I have not had a chance to verify this myself yet), as the value for the formula field gets recalculated only on form submit

Not in UI (form view)

Alex

Bill Mills

Thanks Alex, that answer actually helped me figure it out. I changed the validation condition to: !fldTotalBudget:(fldVendorBudget+fldTranslationBudget+fldOtherBudget) and it works.

Thanks for your help!

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