Performing finds in Scriptmaker

[Kermy]

Hi, I'm trying to do a "add new request" in find mode for my script. But I don't see this option available in Scriptmaker. I want to do a find in one field, and another find in some other field, but I want the results for both. Not if option 1 AND option 2, but if option 1 or option 2.

There's probably some simple solution out there.

Thanks,

Henry

[bobsmith]

Enter Find Mode

[ Pause ]

New Record/Request

Pause/Resume Script [ ]

Perform Find

[kenneth2k1]

Well, im not exactly sure what you mean by option 1 OR option 2. Tell us exactly what your db does and what fields you are searching for. You may be looking for something like this:

Allow user abort (off)

Set error capture (on)

Enter Find Mode [ ]

Set Field [Option1Field, "some criteria"]

Perform Find [ ]

If [status(CurrentFoundCount) = 0]

Enter Find Mode [ ]

Set Field [Option2Field, "some criteria"]

Perform Find

Else

Exit Script

IF [status(CurrentFoundCount) = 0]

Show message ["No records match your requests"]

Show all records

end if

end if

end if

I haven't tried this myself so I don't know if it works. But then again, i'm not sure what youre looking for.

In the mean time, when you are in Find Mode, the script step to add another find request is "New Record/Request." It can be found under the Records category. However, if you are still in Find Mode, it will ADD this request to the previous and therefore give you results of both find requests.

Ken

[harryk]

I'm not (yet) an expert in find operations, but if the values of those two fields you want to find are constant; i.e. predictable, you might consider making a calculation field that flags on/off depending of the values of those two fields, and searching on that calculation field. Depends on your situation.

Harryk

[kenneth2k1]

an excellent idea

[Kermy]

The database I'm working on contains information on professors and how much time they've worked and class enrollment information. What I'm trying to do is do a Find for professors who's classes has an enrollment of greater than equal to 120. There's 4 quarters so 4 fields.

What I do, if I'm doing it by hand is, go to the field: Winter and put in >= 120, then do add new request, and put in >= 120 in Spring, add new request again and do it for Fall and Summer. So I'll get a listing of professors who's classes has an enrollment of 120 for any of the 4 quarters. Not for all four quarters but for any.

Henry

[bobsmith]

Enter Find Mode

Set Field ["Winter",">120"]

New Record/Request

Set Field ["Spring",">120"]

New Record/Request

Set Field ["Summer",">120"]

New Record/Request

Set Field ["Fall",">120"]

Perform Find

[RussBaker]

Looking at what you're actually trying to do, wht don;t you just do your find "by hand" for the >= 120 in each of 4 find requests, execute the find and then create a new script called "Find Profs with >=120 in any Quarter". Filemaker will remember you find requests in the script.

[kenneth2k1]

Because thats too easy... where's the fun in that?