You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I have 4 fields (numeric):
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
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No worries. Yes using confiforms. I've tried using
fldTotalBudget:[entry.fldSummedBudget]
as suggested by Alex with no luck. :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.