On 2008 Sep 24, at 2:58, Tim Mansour wrote:
On 24/09/2008, at 3:08 pm, Richard S. Russell wrote:
The data are not being auto-entered. They're being typed in by the
end users. Sometimes, out of habit, they indicate that they're
done typing in a field by hitting the "return" key instead of the
"tab" key.
Yeah, I realise that. If entering into a FirstName field where the
auto-enter calculation is:
= Substitute ( FirstName, "ΒΆ", "" )
then returns will be stripped from the field on record commit. You
need to make sure the option "Do not replace existing value" is off.
Cool! It would never have occurred to me. Thanks! This trick is gonna
get a lot of use.
I can't figure out how to be a hard-ass on some things and offer
gentle guidance on others with what appears to be only the single
"check by calculation" validation method.
Yes I can see how your example poses a problem. Don't know if it's
practical for you but have you considered using a plug-in to
validate by script? (eg, DoScript, ScriptFire, zippScript)
I was hoping to avoid that and find what I need right within
FileMaker, since I do volunteer DB development for about 20 different
non-profit organizations and I don't want to have to install "extras"
on all those sites just to perform a simple data-entry validity check
(well, 2 checks, maybe not so simple). But, with the auto-enter trick
you showed me above, now I probably won't have to. Thanks again!
