Solved

manditory field script

Posted on 2008-10-16
3
258 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

Industry Leaders: 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

Suggested Solutions

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…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

740 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