Calculations, String concat and date value manipulations on fields in designer
Would be nice to have the ability to perform calculations on fields/to set fields automatically in designer.
e.g. If I have 2 number type fields, I can add a 3rd field as a calculated of the 2 previous number fields. i.e.
pc cost: $250 (field 1)
monitor cost: $100 (field 2)
total: $350 (field 2 auto calculation)
e.g. 2 for String/text type fields.
First Name:John (field 1)
Surname: Smith (field 2)
Full Name: John Smith (field 2 auto calculation)
e.g 3 for Date values (also factor in time)
Start Date: 29/07/2016 (field 1)
End date: 30/07/2016 (field 2)
Total Day(s): 1 (field 3 auto calculation) with the option of having return days, weeks, month, year , minutes, seconds
Date calculations could also be add/subtract days, minutes, hours etc from a given date
-
Dave Ball
- Jul 29 2016
- Awaiting Release Assignment
Related Feature Suggestions
this has raised it's head again today where another customer would like the ability to be able to total together the values in a number of defined fields
I have another customer who is also asking for similar calculation functionality on the screen. Examples above are relevant and would apply particularly those that allow date calculation. E.G. number of secs/mins/hours/days between dates. We would also need to include the variable of (now) to do calculations such as "don't allow a implementation date that is less than 5 days from now.
We are currently investigating this for use in CB Tasks, would allow Users to apply Transforms from the 'then Create Action' option.
Also in workflow branching tasks.