Need JavaScript Assistance with FM Form Validation

July 26, 200322 yr

Newbies

Ok,

I've been hacking at this for a while...and it's very annoying...

I've got a simple database I'm trying to have users "login" by verifying they're in

the database with 3 pieces of information.

Don't get me started about a single unique identifier -- the client wants it this way...

FMP will find against any field that's entered, even if the others are empty. So, to try and

counter this I turned to JavaScript - at which I'm admittedly a novice...so I searched the

web and webmonkey had a script that seemed to do the trick...

Then, getting the form to work with the WebCompanion properly is now my problem.

I've seen 2 references to making things happen upon form submittal:

1) in the FORM tag, use the OnSubmit="return myjavascriptfunction(formname);"

2) in the button itself, use an OnClick="myjavascriptfunction("formname")

If I use method 1, it never seems to validate the submission

If I use method 2 I get the warnings that stuff is left empty...

BUT (here's my problem) - either way, with fields left empty the -Find happens anyway

and I'm taken to my format file anyway - which is not what I want to do...

Dreamweaver's Javascript reference suggests to stick with the OnSubmit in the FORM

tag, but that one doesn't seem to be running the code at all and simply lets the form

submit as if I had no JavaScript embedded at all!?!?

Any assistance you all could lend me would be greatly appreciated...

I'm trying to get this one stickler out of the way for a presentation of the web work on

Monday AM.

oh, and my apologies if the solution is posted previously and my request is redundant,

but I've been spending hours searching and reading FM Forums and haven't located it...

Thanks, in advance for any assistance...

-Ty

Below is my code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Login JS Test</title>

<!--

// -----------------------------------------------------------------

// Function IsFormComplete

// Language : JavaScript

// Description : Checks if all elements in a form have a non-blank value

// http://www.goodnet.com/~sdorman/web/IsFormComplete.html

// -----------------------------------------------------------------

// Ver Date Description of modification

// --- ---------- --------------------------------------------------

// 1.0 08/31/1996 Original write

// 1.1 09/30/1998 CHG: Use standard header format

// -----------------------------------------------------------------

// Source: Webmonkey Code Library

// (http://www.hotwired.com/webmonkey/javascript/code_library/)

// -----------------------------------------------------------------

function IsFormComplete(FormName)

{

var x = 0

var FormOk = true

while ((x < document.forms[FormName].elements.length) && (FormOk))

{

if (document.forms[FormName].elements[x].value == '')

{

alert('Please enter the '+document.forms[FormName].elements[x].name +' and try again.')

document.forms[FormName].elements[x].focus()

FormOk = false

}

x ++

}

return FormOk

}

// -->

</script>

</head>

<body>

<br>

Last 4 Digits of SSN: <input name="Last4" type="text" id="Last4">

<br>

Birthdate mm/dd/yyyy: <input name="Birthdate" type="text" id="Birthdate">

</p>

</form>

</body>

</html>

July 26, 200322 yr

RE: FMP will find against any field that's entered, even if the others are empty.

Not with exact search in web security database or "==" search. Or you can make calculation field with all values.

To rely just on JS for filling form from web... hmm... what will happen if browser is with JS off?

July 26, 200322 yr

Use JavaScript to verify that data has been entered in each field. This way a JS-pop-up on the client side tells the client to fill in the blank and no load is put on the site to return an error page. If you use JS you can always put something at your opening to filter out clients with JS turned off.

Like Anatoli recommends, use the field contents match in your form in conjunction with each data input. I posted a two line sample here in the past 10 days.

Good luck.

July 26, 200322 yr

Author
Newbies

OK OK...

Nevermind this...I found your answer from an earlier post...

You can put the same field in the form as a hidden field with "==" as it's value...and then when it's

submitted the hidden and "real" form entry are combined to do the "==myentry" search in FMPro!

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB22&Number=66190&Forum=UBB22&Words=field%20content%20match&Match=Entire%20Phrase&Searchpage=0&Limit=50&Old=allposts&Main=65939&Search=true#Post66190

-Ty

---------------------------------

Ok,

So, yes, with JS off...the thing reverts back to being a small pain of finding only the first match of a

multiple hits (like the guy who types SMITH for last name and leaves the other fields empty...)

Sooooo...

Nosing into the CDML reference DB says the following under the -Op tag:

>You can use any FileMaker Pro Find operator by specifying the begins with (bw) parameter. E.g.,

>To specify the "Find Content Match" (==) operator, you would specify the begins with parameter (bw)

>and then you would place the characters "==" before the actual search criteria. The required lines

>would look like this:

This is great, so I should present my web form with 3 boxes with "==" pre-entered into them?

This will only serve to confuse the user, and make them want to delete the equal signs...

I've at least done a -Op with a value of "eq" but that still allows for "blank/nonentry" in the boxes to go through...

I guess it's time to whip out the security databases too? Argh.

-Ty

July 27, 200322 yr

Cheese and crackers. You must have mis-understood the syntax for a field contents match "==".

Of course, perhaps my statement that I had "posted a two line sample here in the past 10 days." misled you. By here I was referring in a broad manner to the Internet forums (I don't index my postings for the benefit of myself or others). The posting is actually in the UFO forum" here.

I trust you will find this thread useful to your understanding of the syntax.

You might also look at the various examples which are available in the Sample Files forum. Most of them are referenced with something about "web" or "CDML". And hey, good news, they are free.

Good luck in learning how to have fun with this stuff.

July 27, 200322 yr

Re-post: or you can make calculation field with all values.

That is work in FM for 1 minute. Then in login database if that field connect through relationship with people database with the same calculation field you have valid relation and you can simply test for value in login db "yes" or "no".

This way, with login database you can analyze what visitors are trying for log and do other analysis.