Arithmetic Expression in Forms
Allow the use of arithmetic expressions in forms. This would be used to either populate cabinet fields with form fields or work out calculations on the forms.
Shawn Cartwright
shared this idea
-
J Pendleton
commented
Also need the ability to calculate based on another field. So I have a from location and a to location. I want to fill the field with the miles from the employees Home if the From Location or the To Location is Home. Using Table Calculations. I thought I saw it demo'd but when I went to try it there isn't a way to do this.
-
Eric Bosworth commented
My first idea to use calculations in forms was to replace our excel out of town expense report with a form. The first problem I ran into was that I need to calculate from the departure date and return date the number of dates in the trip. This isn't an option yet. I can do it in a workflow but I can't do it in the form. Arithmetic expressions would fix this issue as well as some other issues I am running into with this project.