Constraining find

script your find button
got to layout - > your layout for the find
enter new request
set Customer:Current = 1
goto field -> customer name

press return

presto!

and last proposal, replace the default menu search command by yours using a custom menu+ a script.
in this script silently add Customer:Current=1 to the user's query. you may check which layout is active if you don't want this everywhere but only in some layouts.

Consider replacing the find menu item with a call to a script that does something like what kraftyman suggests (more on that below) no button needed, or at least BOTH the button and the users that simply invoke command-F (or control-F) wll get the same result.

The script should really be more like this:

got to layout (your layout for the find)
enter find mode
set field (Customer::Current; 1)
go to field (Customer::Customer Name)
pause/resume script
perform find

... and some erorr checking might not be bad, as a second request would not have the Current field populated, etc.

that will disable find for other layouts...

Thanks Guys!

North2Alaska - bit lost on yours and not sure what further details you require. Customers are classified as current or not by a 0 or 1 flag in a checkbox field and I am looking for a one button solution to perform a customer find that will select from current customers only.

kraftyman - not sure what "enter new request means" but also can't understand why
Go to Layout Customers
Enter find mode
Setfield Customers:Current = 1
Go to Field Customers:CustomerName
And then performing the find request doesn't work

lesouef - Hi my fiend - how goes it?  Maybe yours would shed some light on this but I only have 8.5 pro, not advanced so I can't work with custom menus.

skeleton_key - tried all variations of pause/resume script that i can think of, but can't make it work.

Any further help or clarification much appreciated.

you probably don't need the "enter new request script step" actually
try this zipped fp7 file

you will need to change the extension from txt to fp7

Thanks Kraftyman and that's exactly how I thought it should work.

So why doesn't it work on my database (attached)? Script is "CustomerFind" and is first script in the pulldown menu. Only obvious difference I can see is that my Current field is a number field and yours is text.

I must be missing something really obvious....

your file is locked so I can't debug the find script
your customer find script puts a zero in the name field - why?

set up your script as I explained
enter find mode ( uncheck pause !)
set field "Current"  = " 1 " or whatever it happens to be for your current customer
go to field "name"

the enter key should then execute the find

Sorry, if you log in as Tony without a password you should have full privileges.

Otherwise the script should read as you suggested and as for the zero - good question....!

the script is not correctly written
try this ( screenshot uploaded)
you might want to customize the find button for comperes, customers, shifts, pulse and games,
I found myself clicking the find button rather than looking at the menu

Thanks but can you make this script work on my database? This is where I started some while back before trying more exotic solutions and I still get the same result: the "Current" checkbox remains unchecked and I get a zero in the Customer field. Same happens on the other computers sharing this database. If you can make this work and I can't, I can only assume my FM program is corrupt. By the way, the script is only a menu item while I am messing around with it.