Re: Calculated Empty Field Still Showing in E-mail

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

    https://form.jotform.com/203314571472147


    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.

    1608520044_5fe0116c2b905_


    1608519917_5fe010ed82a41_

  • Profile Image
    Sonnyfer
    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
    Sonnyfer
    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.

    1608537694_5fe0565e491d7_lasq.gif

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

    1608537731_5fe0568310db7_

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


  • Profile Image
    gapfundingcc
    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?


    1608567651_5fe0cb63522ef_

  • Profile Image
    Alexander_G
    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:

    https://form.jotform.com/203555309013952

    If you have more questions - feel free to ask!


    Best,

    Alex