Re: Calculated Empty Field Still Showing in E-mail

  • Profile Image
    Asked on December 20, 2020 at 10:10 PM

    The above form I use as an application. Based on certain responses, I have Hidden fields set to 'Calculate' responses for our Processors to know disqualifiers at first glance. (Example below).

    Some fields are calculated based on a number figure. For example, W-2 Income needs to be greater than $30,000. So anything <$30,000 calculates a hidden 'short answer' field to read as insufficient income. The problem I'm having is that of course when someone begins to enter a number, it will always be 'less than $30,000' until at least the 5th number entered. I'm assuming this is what's the populating the field on the e-mail notification even though I have another rule for re-calculating the field back to [blank] for anything greater than $29,999. Unfortunately - the field is still showing up in the form regardless of my numerous attempts to fix it.

    Any advice here on ensuring that the W-2 Income 'DISQUALIFIER' field will not show up?

    Tried Clearing Cache (no change)

    *Please note - I cannot use the "clear hidden fields" setting that I see offered in most cases here. I need this setting set to off so that the form user does not see these calculated fields . Only the notification email which my team receives should be showing these answers (the calculated fields). Therefore, I do not want to clear hidden fields upon submission

    Thank you in advance.



  • Profile Image
    Answered on December 21, 2020 at 02:48 AM

    Hi there - Thanks for explaining your issue in detail. We appreciate it.

    I cloned your form. Kindly allow me some time to conduct some tests on my end. I shall get back to you shortly.

  • Profile Image
    Answered on December 21, 2020 at 03:04 AM

    Thanks for patiently waiting. I tried unhiding the INSUFFICIENT W-2 INCOME field and it seems it's populating regardless of the answer to What is your annual verifiable W-2 Income? This is the reason why the INSUFFICIENT field always get included in the email.


    Also, I see the below formula on your form conditions.


    Could you tell us a bit more of what you're trying achieve here, please?

  • Profile Image
    Answered on December 21, 2020 at 11:21 AM

    Thanks for your response.

    My goal is for the INSUFFICIENT W-2 INCOME field to only populate when the value is <$30,000. It looks like my logic isn't working correctly since it's populating regardless of the input. Can you help me identify the correct logic to ensure that that field only populates with a value <$30,000? I was under the impression the below would achieve this - I must be missing something?


  • Profile Image
    Answered on December 21, 2020 at 02:05 PM

    Hi, gapfundingcc

    I have cloned and tested your form.

    The problem is because the field returns $ and all the separators in the condition. Due to this - the result is always true.

    I've added an additional field who copies the result from $ field but turns it to plain numbers. So, now it should work.

    Please, check my cloned form:

    If you have more questions - feel free to ask!