Hi there

FMPro10adv. Vista

I have 2 fields I would like to validate.

1) This is a text field and we input numbers but they must be 4 digits
eg 0412 or 1014. I want a message or warning if anything other than 4
digits is entered

2) I have a date field and in the validate section I can only find
"validate for 4 digit year". I just want to make sure there is a valid
date eg 12/11/2009 or 05/10/14. (Australia uses dd/mm/yy or dd/mm/
yyyy)

Thanks in advance

David

davepres <davidpreswick (AT) gmail (DOT) com> writes:

Validate by calculation: length( text ) = 4

FileMaker does this for you and will not accept other than valid date data.

Jens

--
FileMaker Konferenz in Zürich Mai 2010
http://filemaker-konferenz.com (german)

"Jens Teich" <spamtrap (AT) jensteich (DOT) de> schreef in bericht
news:m24oqgr1dm.fsf (AT) jensteich (DOT) de...
and make it numbers only



--
Keep well / Hou je goed

Ursus

Thanks Ursus

Both your answers are right but I still have a problem. These fields
are in a portal and I am updating existing records. Although I have
put the Length validation , it only alerts me if I click outside the
portal - it alows me to put in the data with no warning at all.

David


On Oct 4, 6:08*am, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:

Well that is to be expected. Filemaker normally only validates what you have
entered when the record is commited. This is the moment you click outside
the portal. On its own FMP has no way to know what you are entering and if
it is valid while you are entering data. You might start correct, but only
make a mistake on the last digit you enter. It is like calculations, they
also only update on commit record.

Since you have FMP10 you can built a field trigger. In this way a script is
run every time you press a keyboard-key when you are inside the specified
field. The script must then do the validation for you. Make those
validations as short as you can. You can easily see that a script with 100
lines of code, that fires with every key, will slow down your solution
intolerably.

Keep well / Hou je goed

Ursus
"davepres" <davidpreswick (AT) gmail (DOT) com> schreef in bericht
news:41bdfb00-7e86-43c2-9105-7f339f25a4c5 (AT) m7g2000prd (DOT) googlegroups.com...
Thanks Ursus

Both your answers are right but I still have a problem. These fields
are in a portal and I am updating existing records. Although I have
put the Length validation , it only alerts me if I click outside the
portal - it alows me to put in the data with no warning at all.

David


On Oct 4, 6:08 am, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:

Thanks Ursus,

All vey clear now. Much appreciated.

David