<div>
First, check if the (notes)item exists. &nbsp;Then, if it exists, you can check for the empty string with a conversion to text (there are other possibilities)<br />
<br />
if doc.hasitem( &quot;YourField&quot; ) then<br />
if doc.getfirstitem(&quot;YourFiel<wbr />d&quot;).text = &quot;&quot;&nbsp;then<br />
' empty string ! ok ! &nbsp;This works for numbers, dates, strings, that are empty OR null<br />
doOK()<br />
end if<br />
<br />
else<br />
' no field - ok !<br />
<br />
doOK()<br />
end if<br />
<br />
sub doOK()<br />
' code to execute<br />
end sub
</div>


First, check if the (notes)item exists.  Then, if it exists, you can check for the empty string with a conversion to text (there are other possibilities)

if doc.hasitem( "YourField" ) then
if doc.getfirstitem("YourField").text = "" then
' empty string ! ok !  This works for numbers, dates, strings, that are empty OR null
doOK()
end if

else
' no field - ok !

doOK()
end if

sub doOK()
' code to execute
end sub

<div>
if doc.&lt;yourfieldname&gt;(0) =&quot;&quot; then<br />
msgbox &quot;it's empty&quot;<br />
end if <br />
<br />
Partha
</div>


if doc.<yourfieldname>(0) ="" then
msgbox "it's empty"
end if

Partha

<div>
all the answers are on target.<br />
<br />
Good going..
</div>


all the answers are on target.

Good going..

<div>
<div class="content wysiwyg-content">
I have a Script that I wan to check and see if a certain field is NULL, if it is not NULL I am going to write/print several fields from a Doc to a text file. If this one Field is NULL, I do not want to print/write, just go on to the next field I am checking .. <br />
<br />
I am not sure if I use the ISNULL or doc.field=NUL. I am having problems getting anything to work.. <br />
<br />
Rookie Here! Help!<br />

</div>
</div>


I have a Script that I wan to check and see if a certain field is NULL, if it is not NULL I am going to write/print several fields from a Doc to a text file. If this one Field is NULL, I do not want to print/write, just go on to the next field I am checking .. 

I am not sure if I use the ISNULL or doc.field=NUL. I am having problems getting anything to work.. 

Rookie Here! Help!


Checking if a Field is NULL!

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.