Form Calculation Widget: Request for calculation field with logical operators and Excel formulas support

  • Profile Image
    harpbelle
    Asked on November 21, 2019 at 07:28 PM

    Maybe like =IF(), =AND(), =COUNTIF(), =ISBLANK() etc etc. Also logical arguments like TRUE, FALSE etc. Basically all functions under https://support.office.com/en-us/article/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188 if it doesn't conflict with your current setup.

    -

    Yes, I know they work using those methods. I was thinking if I could simply use Excel formulas directly in the widget rather than having to rely on a creating a few hidden fields and a formula for each field in order to make a final calculation, which is what we have done. It would be a minor improvement to reduce clutter on the form.

    E.g. 125*(1st field value) + Not(isblank(1st field value))*25 + 100*(Not(isblank(2nd field value))

    Great support by the way. I always get quick responses for everyone question I get. Thank you.

     

  • Profile Image
    Mike
    Answered on November 21, 2019 at 07:38 PM

    Thank you for the provided details. We have raised a feature request ticket regarding the logical operators and Excel formulas support in calculation fields. We cannot provide an ETA on when or if it can be implemented, but we will let you know if we have any updates on this.