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

Avatar
Nathan H

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

Sort by Date Votes
  • Avatar
    Sara Kaplow, Community Manager

    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
    Comment actions Permalink
  • Avatar
    Eric Willis

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

    2
    Comment actions Permalink
  • Avatar
    Mike Cain

    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
    Comment actions Permalink
  • Avatar
    Siobhan Tabatabai

    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
    Comment actions Permalink
  • Avatar
    Nathan H

    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
    Comment actions Permalink
  • Avatar
    Leroy Coffman

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

    2
    Comment actions Permalink
  • Avatar
    Lauren Sunday

    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
    Comment actions Permalink
  • Avatar
    Keith McQuait

    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
    Comment actions Permalink
  • Avatar
    Chase Cason

    Agree - this is needed

    1
    Comment actions Permalink
  • Avatar
    Tyler Martin

    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? 

    0
    Comment actions Permalink
  • Avatar
    Troi Coleman

    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
    Comment actions Permalink

Please sign in to leave a comment.