Newbies Mehbastan Posted October 19, 2011 Newbies Posted October 19, 2011 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
Lee Smith Posted October 19, 2011 Posted October 19, 2011 Automatic message This topic has been moved from "FileMaker Product Family → FileMaker Pro 10" to "Database Schema & Business Logic → Managing Scripts".
LaRetta Posted October 19, 2011 Posted October 19, 2011 (edited) 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, 2011 by LaRetta
Recommended Posts
This topic is 4803 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now