Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Four year old ConfiForms form is now displaying an error in a field when it should be blank.

Cynthia I'm New Here Jan 04, 2022

Hello,

I have a Confluence ConfiForms form that one of the fields have an error in it even though it is a read only and should be blank that point.

This field is supposed to display the total of four other fields (dropdowns of numbers), then depending on what the total is (1-10) a different field is supposed to display one of three messages.

It is not affecting the collection of data after a user hits the submit button and it is also not affection the forms ability to calculate, it just looks like an error to the user of the form. I developed this form four years ago and it has never done this before.

It is showing this error: com.udojava.evalex.Expression$ExpressionException: Unknown operator '+++' at position 2. The position number changes in the error depending on which one of the four fields you use.

It also occasionally shows this error: com.udojava.evalex.Expression$ExpressionException: Too many operators or functions at: +.

Once all four fields are populated with a number, the field that is displaying the error, stops showing he error, then calculates and shows the number correctly.  

When searching to see if I could figure this out myself, I was looking through the TEST Space and noticed a couple of the forms are throwing the same type of error.

This one: https://wiki.vertuna.com/display/TEST/Page+to+demo+score+calculation+using+2+methods and this one https://wiki.vertuna.com/display/TEST/Simple+calculation+with+formula+field.

Thanks for any help!

Cynthia

2 answers

Hi

It looks like you have a formula field that attempts to calculate a value when no values provided for fields it is using

You should probably use ZEROIFEMPTY("[entry.field_name]") for the fields that may be EMPTY

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

Alex

0 votes
Fabian Lim Community Leader Jan 04, 2022

Hi @Iloverick17__

Feel free to contact confiforms support directly and provide all the detials.  Copying @Alex Medved _ConfiForms_ 

Regards

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

6,311 views 11 57
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you