Allow Parenthesis and Exponents and Implement Order Of Operations For Calculation Fields

It would be very nice and would possibly save some fields and submission size to add ( ) and ^ as available operations for calculation fields and then implement the order of operations PEMDAS (parenthesis, exponents, multiply, divide, add, subtract).  This would give the ability to do a little bit more complex math on the fly in the app without having to stage values in multiple fields to produce the desired results.

24

Comments

11 comments
Date Votes

Please sign in to leave a comment.

  • This would be awesome - I'm constantly pulling stuff into a google sheet so I can do more math on it. Four upvotes in two days, seems like other folks have the same needs!

    7
  • I would also like to be able to find the minimum and maximum value of a field of input numbers

    2
  • Agreed. As a previous Canvas user (and possible return user) the problem for us is always the lack of exponents. Tough for the forms to demonstrate any (even basic) financial or engineering outputs without it. Love your software & support, Canvas, but please add.

    2
  • Hi Mike,

    Thanks for stopping by the Community to check in on this feature request! As a former (and hopefully future!) user, your input is valuable to us to understand what we can do better. We appreciate you sharing some background around what types of outputs would be ideal in your process in GoCanvas. 

    All the best,

    Siobhan

    1
  • I needed this again recently and wound up staging values in multiple fields again... it would be nice to just use a single field... it would save on submission size, sync speed, and simplicity as well...

    4
  • We are trying to build an app that is heavily dependent on Parenthesis for correct order of operations.  Has this been implemented yet?

    2
  • Hey Leroy,

    Thanks for checking in on this feature request! This is certainly a popular request and the relevant teams are excited to hear continued momentum behind this request. I will be sure to follow up when I have an update to share.

    2
  • I'm laughing now, but I remember being very frustrated with this. It definitely takes some abstract thinking when the order of operations doesn't apply.

    3
  • Agree - this is needed

    1
  • I agree with this feature request. In addition I would like to be able to have operator as a constant. Since I can't subtract from a constant (1-x) I now need to perform this calculation (x-1)*-1 but I can't multiply by constant negative number. So now I have to add a read-only constant field of 1 so I can go back to my original 1-x. 

    This is a 5 year old request as of this post, is there a timeline or priority ranking for this request? 

    1
  • Hey Tyler!

    Thanks so much for your input on this feature request. Unfortunately, there is not a timeline for this particular request at this time. We review the most popular requests by the number of votes given by the community. Please be sure to upvote this request so our development team can identify this as a priority and possibly consider it for future mapping.

    Troi Coleman, Learning and Education Specialist

    0

Didn't find what you were looking for?

New post