Hi Soren,

Now nothing is working as it should. When I call this script it no longer puts **************** in empty "Must Enter fields" and no longer pays attention to the "NumberTestAnswer". It just goes to the Invoice file and does not make a new record. Here's the script.

Go to Layout [ “Field Validation” (Contacts) ]

Set Variable [ $flag; Value:1 ]

Set Field [ Contacts::ErrorField; "" ]

Go to Field [ Select/perform ]

Go to Next Field

Set Variable [ $stopValue; Value:Get ( ActiveFieldName ) ]

Loop

If [ Length(Filter(Get ( ActiveFieldContents ) ;"*")) ]

Set Field [ "" ]

End If

Go to Next Field

Exit Loop If [ $stopValue = Get ( ActiveFieldName ) ]

End Loop

Loop

If [ IsEmpty ( Get ( ActiveFieldContents ) ) ]

Set Field [ TextColor ( "**********************" ; RGB ( 0 ; 0 ; 0 ) ) ]

Set Variable [ $flag; Value:0 ]

End If

Go to Next Field

Exit Loop If [ $stopValue = Get ( ActiveFieldName ) ]

End Loop

If [ Contacts::NumbergTest1 + Contacts::NumberTest2 ≠ Contacts::NumberTestAnswer ]

Set Variable [ $flag; Value:0 ]

Go to Layout [ original layout ]

Clear [ Contacts::NumberTestAnswer ] [ Select ]

Go to Layout [ “Contacts-Entry” (Contacts_Entry) ]

End If

If [ $flag ]

Perform Script [ “Create New Voter Order” ]

Else

Set Field [ Contacts::ErrorField; "Fields with **** are required to continue!" ]

End If

Milo

The 3 extra "math" fields should be omitted from the tab order, since they serve a different purpose! In fact all fields needs to get scrutinized if they have anything to do with enty of data or are part of the hacker prevention.

Go To Next Field, follows the established tab-order, which the developer can modify if he/she wishes.

However does your description indicate that the looping is terminated too early, I would say you need to exploit the debugger and dataviewer here.

Further more would it be better that you post screendumps, because the indent's in loops and conditions, would reveal a too dyslexic put End Loop or End If, right away!

--sd

Edited November 2, 200718 yr by Guest

Hey Guys,

This is quite a conversation and I can see why it has 1165 posts. It gets us into areas and ways of calculations and scripting that you don't see that often. Now that 9 offers us so much more flexibility to SQL and PHP It's become a real adventure.

Milo I'd like to show you how smart I am by posting some Grandiose script, but the truth is Soren took all the fun out of it by his great scripting, the boy is good, you can tell by his smile! Who said it was a smile only a mother could love...

All You need to re-dress the script… Woo-Ha-Yee-Ha and just after you got back into men’s clothing. We like to keep our comments (did I say Comment) transparent around here so you could make that a Glass dress, now that bare’s looking into!

Here's your script and all I've done is changed the location of where the print invoice is called and I think it will work without a hitch.

Live Long & Prosper,

Harry

Hi Harry,

It works, I can’t believe I’ve been pulling my hair out trying to make this work and all I had to do was move the Perform Script step. Wow!

I never did get the script working I was just too embarrassed to send another post to Soren saying “IgotIt doesn’t GotIt”!

I take great issue however, with you talking about my wearing dresses. It was wrong and you were wrong! I never said I went back to men’s clothing!

Thanks; I can’t begin to tell you that this nightmare is over. Soren, Harry, everyone thanks so much.

Oops, a wind came in and blew my skirt up.

Milo

I was just too embarrassed to send another post to Soren

C'mon, it's part of the learningprocess not quite to get it the first time around ... this blog has some noteworthy point's to make:

http://www.anecdote.com.au/archives/2006/03/data_informatio.html

Continue to ask, it's not embarrasing - what sometimes could be felt a little tiresom is when context and purpose are kept secret... You Milo have been frank and open about yours, so there is absolutely nothing to hessitate about!!!

--sd

Hi Soren,

Thank you for the kind message, it was very gracious of you and much appreciated. I will be very happy when I learn more of all that is FileMaker and be able to help other as you guys have helped me.

Harry’s right about the smile, it tells volumes about the kind of guy you are and I’ll even bet you have a white hat!

Thanks Soren and all of you that give so much of your time to help others.

Milo

I’ll even bet you have a white hat!

No - it's part of the dress uniform, me and my inmates from the lunetic asylum, get's to use on special occations ... so technically does it belong to the asylum....

--sd