Forum Discussion
ChasityJohnson
3 years agoQrew Member
I would need to have it where I can check multiple items and then have the amounts total into the CHANGE ORDER - ESTIMATED COST to TSC field is there another way to accomplish this?
Chasity Johnson
Mercury Tech Partners LLC
Office 828-465-7348 Ext. 4243
Cell 540-748-1141
TylerJablonski1
3 years agoQrew Trainee
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
------------------------------
- ChasityJohnson3 years agoQrew MemberThat is helpful. We will try this and see if we can make it work! Thank you!
------------------------------
Chasity Johnson
------------------------------