Hi Everyone

Please help me figure this out. I have a database that I schedule my photographers to photograph schools. I have 21 photographers who need to know where they have to be on any particular day. Here is some of the fields I have:

School name

Shoot date

retake date

photographers

Confirmed

Tentative

Main_Retake_Cal (This is a calculation field for fining Main shoot or Retake purposes)

Start_date

End_Date

I wrote a script that will find the schools that their retake date has be scheduled and confirmed and the script will no longer show the original shoot on the list. (Awesome if the shoot has happened already)

However I need it to show the shoot date as well as retake date if the shoot date has not yet happened.

This is my script:

Enter Find Mode [Restore]

Set Filed[school_Info::Main_Retake_Cal;School_Info::Start_date::&...&School_Info::End_Date]

Perform Find[]

Please help

Thanks

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Pro 10" to "Database Schema & Business Logic → Managing Scripts".

Hi Mehbastan,

If you want to apply the same search to another field, it is considered an OR search. You add a new find request similar to (portion in blue):

Enter Find Mode [Restore]

Set Filed[school_Info::Main_Retake_Cal;School_Info::Start_date::&...&School_Info::End_Date]

New Record/Request

Set Filed[school_Info::Main_Shoot_Cal;School_Info::Start_date::&...&School_Info::End_Date]

Perform Find[]

But I have a few questions ...

1) Is School Info Start and End dates global dates? If not then your script will not work because you cannot set a field to a value of other fields while in Find Mode. You need to capture the value into variable or use global fields so its value will be accessible even in Find mode from any table.

2) What is in that Restore on the Enter Find Mode[]? Whatever is in it will be nulled by the Set Field[] step right after it. If you wish to further restrict a User entry behind the scenes use Constrain Found Set[].

Added: And remember to include a Set Error Capture [ on ] right before your Perform Find[] and handle the error yourself.

Edited October 19, 201114 yr by LaRetta