Is that Field Empty?
As a form designer, you can be almost certain that there will be a time when you’ll need to check a field to see whether its value is empty (whether the form filler has specified a value).
For longest time, I had been doing it like this in JavaScript:
if (theField.rawValue == null || theField.rawValue.length == 0)
// field is empty
else
// field has been filled
That served me quite well until yesterday when I found myself needing to do the same, but this time in FormCalc. Theoretically, the following should’ve worked:
if (theField == null | theField == "") then
// field is empty
else
// field has been filled
endif
But for some reason, the FormCalc interpreter was giving me a hard time with the null keyword (maybe it’s because I don’t use it very often and it was upset at me, I don’t know — if you’re a developer, you’ll understand that sometimes, code can have feelings and a mind of its own 😉 ) so was forced to try and find some other way to check if a field’s value is null in FormCalc and I found one:
theField.isNull
The isNull property (of the XFA Scripting Model’s node object) “indicates whether the current data value is the null value”, as stated on page 422 of the Adobe XML Form Object Model Reference (located in the XML section).
This means that the following JavaScript expression checks whether a field’s value is empty:
(theField.isNull || theField.rawValue.length == 0)
And in FormCalc:
(theField.isNull | theField == "")
Posted by Stefan Cameron on May 19th, 2006
Filed under Scripting
Both comments and pings are currently closed.
I have also used HasValue(theField) for FormCalc
I had a problem with a script that I wrote recently. I typically check (theField.isNull || theField.rawValue.length == 0) but for some reason with this text field (that is exactly like all of the other text fields settings-wise) I was getting an error thrown into my try/catch block that theField doesn’t have a property called rawValue when it was empty. Now, if I put a string into the field and deleted it then it would succeed. If I never touched the field it would fail. This is in LiveCycle Designer 7.1
So my solution in javascript was:
if ((theField.isNull) || (theField.rawValue == undefined)) { … }
I tested a couple of different versions out and this one seems to be the most reliable.
Hi I needed a help, I got fields:
Name (Text Field)
Total (Number , sum of other fields)
Commission
GrandTotal ( Number calculated, Total – Commission)
Now what I want is, if Name is Blank then Commission should be 0, if we enter any thing in field name then Comission should be 15% of total.
Your help will be appreciated.
Khalid,
You could use a Calculate script on the Commission field:
What is the syntax for is NOT Null?
Thanks.
Mike,
To check if a value isn’t null, you can do this (in JavaScript)
or this (in FormCalc)
Hello Stefan,
You have helped me with some other items in the past I hope you can help again, you do great work.
I have a drop down field that fills in information in an email based on the item they select. I have 2 specific items that if they are selected will add a statement stating they need to use a specific part number to order more of that part. I have it set up also if they select a yes or no answer the email will either read no problems were found, select “Yes” all the information is pulled and populate in to the email.
To my point, if they select No the 2 specific items show up on the email as Null, is there a way so that the Null word does not appear, I am looking to have absolutely nothing appear if those fields are blank.
Thank You for your help
@Todd,
Thanks…
Can you post the script in question? If “null” is showing-up in the text, it’s usually because you’re including the value of some variable in a string and that variable is null. There must be something going wrong when the selected answer is “No” vs “Yes”.