Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8262 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

hello,

in the invoicing system i am working on, i am not using the FMP status area, i have made my own. on the Find layout i have duplicated the everything successfully but the 'omit' check box. maybe i am not getting the script steps in the correct order. i have a yes/no field called 't Flag Omit' and when checked i would like my search to use the 'omit' function in the search. i realize i need a if/then statement in my Perform Search script, but how do i go about doing this? thanks.

Posted

quote:

Originally posted by Ken Edwards:

hello,

in the invoicing system i am working on, i am not using the FMP status area, i have made my own. on the Find layout i have duplicated the everything successfully but the 'omit' check box. maybe i am not getting the script steps in the correct order. i have a yes/no field called 't Flag Omit' and when checked i would like my search to use the 'omit' function in the search. i realize i need a if/then statement in my Perform Search script, but how do i go about doing this? thanks.

After performing find add these script steps

code:


if(FlagOmit)

ShowOmitted

end if

Hope your FlagOmit is an global wink.gif

Also you should capture error since it's an FindScript:

Dj

Posted

Watch out here !

If you have LOCKED the status area as hidden then you can't use the omit - even when scripted.

I could have ripped Dominic Goupille's head off for that !

Posted

quote:

Originally posted by Mark Dore:

Watch out here !

If you have LOCKED the status area as hidden then you can't use the omit - even when scripted.

I could have ripped Dominic Goupille's head off for that !

If you wanted to say with multiple find requests than you're right. For single Find Request that is not a true!

Dj

Posted

quote:

Originally posted by dj:

Did you say Find Layout?

So you're already in find mode when trying to set FlagOmit to true?

Dj

yes i am in find mode already. i will give this a go tonite when i get time. that thing about the locked status area sounds pretty dumb. thanks for the info all.

Posted

dj, your solution works if you only have one find request. If you want "the full options" with as many find requests (omitting or not) you want, you could do as following:

(I suggest that you have a search script that activates the search mode an pauses for input).

you need a number field "one" (not a global!), filled with "1" in every record (is anyway usefull for many other things...). In your "find layout", put this field as a checkbox, performing the script:

set field ( one , Case(IsEmpty one) , 1))

omit record

have fun

Gerd

Posted

quote:

Originally posted by Gerd Muller:

dj, your solution works if you only have one find request. If you want "the full options" with as many find requests (omitting or not) you want, you could do as following:

(I suggest that you have a search script that activates the search mode an pauses for input).

you need a number field "one" (not a global!), filled with "1" in every record (is anyway usefull for many other things...). In your "find layout", put this field as a checkbox, performing the script:

set field ( one , Case(IsEmpty one) , 1))

omit record

have fun

Gerd

Right , but just one thing,

if you want to change the status of current find request (from omit to inclusion and viceversa) you should change script to

set field ( one , Case(IsEmpty one) , 1,""))

omit record

where "" stands for inclusion

[ April 15, 2002, 02:58 AM: Message edited by: dj ]

Posted

dj, both ways will be ok. Since you can leave away the default result in a case function, you will get a "" so or so.

And Mark: I tried this with the locked and hidden status bar: and it worked (FM 5.5v2 Mac). Probably, somebody at FM had the ears wide open smile.gif

have fun

Gerd

Posted

thanks everyone for their input. i been so busy working on other modules of this solution i have yet to get back to implimenting this omit feature. its on my 'to do' list. great help,. thanks!

This topic is 8262 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.