Ingoring a field if it's left blank

  • Profile Image
    Asked on June 12, 2020 at 11:19 AM

    How do have I have my Formula Widget ignore a field if it is left blank? I currently have a couple of fields in which if left blank, it adds numbers to the result. Works great if I add a number because it has a subtraction formula within but if left blank, I'd like it to ignore the field because leavin it blank means that it doesn't apply. Example here:

  • Profile Image
    Answered on June 12, 2020 at 12:00 PM

    I checked your form and noticed that you use multiple Form Calculation widgets. There are some Form Calculation widgets, which you use only to pass value from other fields. I would suggest you to reduce the number of the widgets.

    Can you please try to merge the formulas from the widgets from your example (from the video) in one Form Calculation widget?

    Please try to apply this and let us know if you need any further assistance.