Help with finds in FM 8 [Beta-8 Advanced]

[aldipalo]

Description: I am a new user of Filemaker. Have been a Lotus Approach user since

version 1. I need help with finds and scripts for automated finds.

First, is there a way to do a straight out find for multiple records

in the same field? A basic OR search. I have a field named "Jobs."

It is a number field. I want to search my contacts for all those

people I have talked to about these jobs. In Approach I would click

on the "Jobs" field and type 190,192, 198, 202. It would return all

contacts with any of those ID's. How is this accomplished in FM? I

cannot find any discussion of "OR" searches.

Second, I have tried to make a script to search a "Follow_UP_DATE"

field where it would automatically search my contacts for those who

were to be followed within the last 30 days. All attempts have

failed. Can anyone help with a simple script or explanation.

Thanks in advance for your assistance.

Edited November 8, 2005 by Guest
removed forum info

[Fenton]

In FileMaker an "Or" search multiple "Requests". When you are in Find mode, each "New Record/Request" creates a new request. So your search above would be 4 requests, with an ID in each.

We can't say exactly why your Date search is failing. FileMaker 7/8 is pretty forgiving about date entry, so it's likely there's some kind of logical or syntax problem with the Find. In FileMaker 7 you can use the following (minimum steps only)

Enter Find Mode [no restore]

Set Field [ Date field; ">=" & Get(CurrentDate) - 30 & "<" & Get(CurrentDate)]

Perform Find [no restore]

It could be that you've got "Restore" checked on one of your steps, which means it'll run whatever it stored from when it was created.

(P.S. Hopefully you've already followed up with those >30 days, 'cause they're ignored by the Find.)

[LaRetta]

And you have Advanced. Run it through Debugger. It's amazing how the logic comes clear when you can easily see it in action. You can script date range also by using something like:

Set Field [ Date field; Get(CurrentDate) - 30 & "..." & Get(CurrentDate)]

LaRetta

[aldipalo]

Thanks to both of you for the quick reply. The script is working fine and I am now finding my follow ups. I guess I can develop individual scripts for just today,10 days and 20 days. I'm sure that could be set up in a case statement and have a reference field for what period of time I want to search. Anyway, thanks again.

As a follow-up to my other question are you saying there is no efficient way to do an "OR" search? Any ideas on how to solve that problem?

Thanks.