Hide Default Zero Values in Calculated Field

  • Resolved CParris

    (@cparris)


    5 years, 7 months ago

    Hello,

    I have a form that generates a part number. The number is composed of several selections by concatenating them together in a single calculation field. Default values of the selection fields are currently left blank. However, before any selections are made the calculation field result displays as a series of 0s. I’d like the form to load with the Part Number Field blank, then gradually fill in the part number as selections are made. Is there a character(s) I can put in the default value of each selection field that will show nothing rather than a zero? If not, is there a function that will suffice?

    Thank you! This form plugin has the best logic I’ve seen and the support here is exceptional!

    • This topic was modified 5 years, 7 months ago by CParris.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author codepeople

    (@codepeople)

    5 years, 7 months ago

    Hello @cparris

    If you want to get the raw values of fields instead of their pre-processed values (the plugin tries to pre-process the fields’ values for the mathematical operations) use the fields’ names with the |r modifier in the equation, like: fieldname1|r

    Best regards.

    Thread Starter CParris

    (@cparris)

    5 years, 7 months ago

    Hi Codepeople,

    Yes, I saw another post of yours previously. So I already have the modifier assigned in the calculated Field like this:

    CONCATENATE(fieldname3|r, fieldname4|r, ... . However the output of this shows as a bunch of zeros (one for each field). Like this: 00000000. How would I get these to start out blank instead?

    Plugin Author codepeople

    (@codepeople)

    5 years, 7 months ago

    Hello @cparris

    You can implement the equation as follows:

    
CONCATENATE(IF(fieldname3, fieldname3, ''), IF(fieldname4, fieldname4, ''), IF(fieldname5, fieldname5, ''), IF(fieldname6, fieldname6, ''), IF(fieldname7, fieldname7, ''))

    Best regards.

    Thread Starter CParris

    (@cparris)

    5 years, 7 months ago

    Wow, crazy how fast your reply was. Thank you! I will give this a try.

    Thread Starter CParris

    (@cparris)

    5 years, 7 months ago

    Yep, works perfectly! May I ask: Where would I find the documentation on this IF statement/function? You show 3 arguments and I’m not fully understanding how the logic works or what each argument represents.

    • This reply was modified 5 years, 7 months ago by CParris.
    Plugin Author codepeople

    (@codepeople)

    5 years, 7 months ago

    Hello @cparris

    The operation is described in the following link:

    https://cff.dwbooster.com/documentation#conditions-module

    The operation structure is:

    IF(condition, the result if the condition is true, the result if the condition is false)

    Best regards.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Hide Default Zero Values in Calculated Field’ is closed to new replies.