simple find/sort script help.

[ljscott]

Hi,
I don't know much about filemaker and need help creating a script.
I want to create a report of current employees and their departments and phone numbers.
I have created a layout that I want to show this information in.
I have a field called 'current employee,' whose value is either 'yes' or 'no.' How do i create a script that only shows records that has a 'yes' for this value?

thanks.

 

[jware]

Scott,
Before creating the script you will need to do a manual find of all records with 'yes' in the field.
Then create a script as follows:
Go to layout that has the 'Current Employee' field
FindAll
perform Find(Restore) Makes sure the restore checkbox is checked.

Close out the script and make sure 'Keep' find request is checked.

That will find all the records where the 'Current Employee' field contain 'Yes'.


Home this help
James

 

[Schlogg]

Sorry, James, but that won't work.
Simply do a (manual) find of 'yes' in the Current Employee field.
Then create a script with one step -
Perform Find (Restore) (Replace Found Set)
Close the script.
Done!
It is a good idea to include a comment stating the detail of the Find otherwise you have to print the script to see just what your find criterion was. This is unimportant with this particular, simple instance but you never know.

Cheers,
Paul J.

 

[jware]

Paul,
Thanks for cleaning up my answer. I guess I am better
at writing the code than explaing the code.
James