Condition to show signature field when total is greater than 4999 not working

  • Profile Image
    Tmarble21
    Asked on August 26, 2020 at 05:14 PM

    I'm trying to generate a required signature field if the purchase order amount is over $5,000. I've got the spreadsheet totaling up to Total Purchase Order Amount but can't get it to generate a required signature if the amount is $5,000.

  • Profile Image
    Sonnyfer
    Answered on August 26, 2020 at 09:50 PM

    Hi there - I checked your form and it seems the reason why your condition doesn't work

    1598492735con1232.png

     is that you have a dollar sign "$" in your Form Calculation Widget.

    1598492697dolr.png

    Kindly note that adding a dollar sign ($) as a prefix to the widget will make its input type to "Text" instead of "Number". Thus, your condition can no longer determine if it's more than 4999.

    To make your conditions work, you would need to remove the dollar sign prefix.

    1598492978work1.gif

    Give it a try and let us know if you need further assistance.