AnsweredAssumed Answered

Trying to create an open jobs report using a dropdown selector.

Question asked by shawnmberkeley on Jul 20, 2017
Latest reply on Jul 20, 2017 by shawnmberkeley

The idea is to have a drop down menu which is used to select a single staff person, and then a button to run a report of all open jobs for that staff person.

 

I created JOB::ContactID_StaffReport number field with an assigned dropdown menu showing values from Contact_ContactID_StaffList value list.  This value list displays values from CONTACT::ContactID_StaffActive (number) and CONTACT::ContactIDStaffNameFullActive (text).

 

Selecting a staff member from the dropdown enters the person’s ID number in JOB::ContactID_StaffReport and name in JOB::NameFull_StaffReport.

 

Then I created a Run Report button that runs the following script:

 

Enter Browse Mode [ Pause: Off ]

Freeze Window

Enter Find Mode [ Pause: Off ]

Set Field [ JOB::ContactID_Designer ; JOB::ContactID_StaffReport ]

New Record/Request

Set Field [ JOB::ContactID_Editor ; JOB::ContactID_StaffReport ]

New Record/Request

Set Field [ JOB::ContactID_Programmer ; JOB::ContactID_StaffReport ]

New Record/Request

Set Field [ JOB::JobStatus ; “Complete” ]

Omit Record

Perform Find []

Go to Layout [ Report ; Animation: None ]

Sort Records [ Restore ; With Dialog: Off ]

Adjust Window [ Resize to Fit ]

 

This unfortunately returns every open job, rather than just those of the staff member selected. 

 

If I change the Set Field values such as the following:

 

Set Field [ JOB::ContactID_Designer ; JOB::ContactID_StaffReport ]

to

Set Field [ JOB::ContactID_Designer ; 481 ]

 

the script correctly finds all open jobs for designer #481.

 

 

The relevant relationship is set up the same as all the similar fields, like JOB::ContactID_Designer.  It is

 

CONTACT::ContactID_Staff = JOB::ContactID_StaffReport

 

CONTACT::ContactID_Staff is a calculation – Case ( PatternCount ( ContactType; "Staff" ) ; ContactID ) – where ContactID is an Auto-enter Serial Number.

 

Any help would be appreciated.  Please let me know if you need anything clarified.

Outcomes