<div>
Try these simple changes...<br />
fldLocationIP1 := @If(fldLocationIP1 = &quot;&quot;; 0; fldLocationIP1) <br />
<br />
You could also place this formula in the default value so that each field is automatically set to 0<br />

</div>


Try these simple changes...
fldLocationIP1 := @If(fldLocationIP1 = ""; 0; fldLocationIP1)

You could also place this formula in the default value so that each field is automatically set to 0


<div>
When I put that into the QuerySave event, I get the following error (when attempting to save the formula):<br />
<br />
No main or selection expression in formula &quot;<br />
<br />
Any ideas?<br />

</div>


When I put that into the QuerySave event, I get the following error (when attempting to save the formula):

No main or selection expression in formula "

Any ideas?


<div>
Thanks for trying, but that didn't work either.<br />
<br />
Here's what I finally got to work. &nbsp;I placed the following code in the InputValidation event for each field I needed checked:<br />
<br />
FIELD fldLocationIP1:=fldLocatio<wbr />nIP1;<br />
@If(fldLocationIP = &quot;&quot;; @Failure(@SetField(&quot;fldLoc<wbr />ationIP1&quot;;<wbr /> 0)); @Success)<br />
<br />
That seems to do the trick!<br />

</div>


Thanks for trying, but that didn't work either.

Here's what I finally got to work.  I placed the following code in the InputValidation event for each field I needed checked:

FIELD fldLocationIP1:=fldLocationIP1;
@If(fldLocationIP = ""; @Failure(@SetField("fldLocationIP1"; 0)); @Success)

That seems to do the trick!


<div>
<div class="content wysiwyg-content">
I have a form that has a set of fields, of type number, that need to be set to zero, if the user doesn't enter a number. &nbsp;I just wanted to write a formula on QuerySave to accomplish this. &nbsp;Here's what I did:<br />
<br />
fldLocationIP1 = @If(fldLocationIP1 = &quot;&quot;; &quot;0&quot;; fldLocationIP1)<br />
<br />
What might be wrong with this?<br />
TIA!
</div>
</div>


I have a form that has a set of fields, of type number, that need to be set to zero, if the user doesn't enter a number.  I just wanted to write a formula on QuerySave to accomplish this.  Here's what I did:

fldLocationIP1 = @If(fldLocationIP1 = ""; "0"; fldLocationIP1)

What might be wrong with this?
TIA!

Simple If Formula Question

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.