Multi-Text field and Total fields

Question

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?

------------------------------
Chasity Johnson
------------------------------

markshnier__you · Answer

Hmmm, what if the user checks 10 boxes?&nbsp; Does this need to be a multi select field type.&nbsp; Can it be a Multiple choice field?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

chasityjohnson · Answer

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 · Answer

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
------------------------------

chasityjohnson · Answer

That is helpful.&nbsp; We will try this and see if we can make it work!&nbsp; Thank you!------------------------------Chasity Johnson------------------------------

Forum Discussion

Multi-Text field and Total fields