Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4803 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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

Posted (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 by LaRetta

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.