Discussions

 View Only
  • 1.  Multi-Text field and Total fields

    Posted 01-24-2023 12:49
    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
    ------------------------------


  • 2.  RE: Multi-Text field and Total fields

    Posted 01-24-2023 12:50
    Hmmm, 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
    ------------------------------



  • 3.  RE: Multi-Text field and Total fields

    Posted 01-24-2023 12:53

    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

     






  • 4.  RE: Multi-Text field and Total fields

    Posted 01-24-2023 13:12
    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
    ------------------------------



  • 5.  RE: Multi-Text field and Total fields

    Posted 01-24-2023 13:25
    That is helpful.  We will try this and see if we can make it work!  Thank you!

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