Re: Calculated Empty Field Still Showing in E-mail

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.

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.

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?

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?

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