Solved

manditory field script

Posted on 2008-10-16
3
259 Views
Last Modified: 2012-05-05
I need a script to that will check to see if the user has entered a value (including zero) in a field before the rest of the script will run. the problem is as this is a numerical field if the user leaves it black the computer recognises it as 0.
0
Comment
Question by:imounch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 3

Accepted Solution

by:
D0N earned 500 total points
ID: 22737404
Use the function IsEmpty to determine if the field has nothing in it.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 22738314
it will recognize as 0 in calculations, but not is you test the content as above or <> "" (there is not equal sign on mac).
for a better understanding, it is better to test numeric fields as > 0 except if 0 is expected as relevant data.
if 0 is relevant, use getastext(field)<> ""; this way you're sure to test the text content of the field
0
 

Author Closing Comment

by:imounch
ID: 31506885
D0N, Thanks for your help, I didnt realise there is an IsEmpty function, This will come in really handy.

Thanks again.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question