Multi-Text field and Total fields
I have a field that is Multi-text that has words and numbers. I need for when the box is checked that has the name and amount to total into another field anyone have any idea how to make this work? ...
Forum Discussion
Kind of a pain if you have a bunch of choices, but you can use a formula field and define a numeric variable for each option, then sum those variables.
So for example:
var text options = totext([CHANGE ORDER - LIST OF ITEMS NOT READY]);
var number optionA = if(contains($options, "TERMINATIONS"),2000,0);
var number optionB = if(contains($options, "EQUIPMENT SET UP"),2000,0);
var number optionC = if(contains($options, "GREENHOUSE"),3000,0);
and so on. And then after you declare all of the variables, the formula is sum($optionA, $optionB, $optionC, ...)
------------------------------
Tyler Jablonski
------------------------------
So for example:
var text options = totext([CHANGE ORDER - LIST OF ITEMS NOT READY]);
var number optionA = if(contains($options, "TERMINATIONS"),2000,0);
var number optionB = if(contains($options, "EQUIPMENT SET UP"),2000,0);
var number optionC = if(contains($options, "GREENHOUSE"),3000,0);
and so on. And then after you declare all of the variables, the formula is sum($optionA, $optionB, $optionC, ...)
------------------------------
Tyler Jablonski
------------------------------
That is helpful. We will try this and see if we can make it work! Thank you!
------------------------------
Chasity Johnson
------------------------------
------------------------------
Chasity Johnson
------------------------------
