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
MarkShnier__You
Qrew Legend
Qrew LegendHmmm, what if the user checks 10 boxes? Does this need to be a multi select field type. Can it be a Multiple choice field?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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
- 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
------------------------------- That is helpful. We will try this and see if we can make it work! Thank you!
------------------------------
Chasity Johnson
------------------------------
