AnsweredAssumed Answered

Portal showing schedule filtered by current record

Question asked by mcemond on Nov 6, 2014
Latest reply on Nov 6, 2014 by mcemond

Title

Portal showing schedule filtered by current record

Post

Hi! I have a table workOrder that is related to another table crewAssignment. Relevant fields:

workOrder::workOrderStartDate (date)
workOrder::property
crewAssignment::schedule (date)
crewAssignment::crewName

When I am on the workOrder layout, creating a new work order, I enter a date for workOrderStartDate and I have a portal on the layout based on crewAssignment. In this portal I would like to show crewName, filtered by schedule where schedule matches workOrderStartDate. So basically I choose a date that I'd like to start the work and a list generates that shows me who is already assigned to work orders that day (and where - workOrder::property).

So far my attempts at scripting an effective filter for the portal have failed. 

Any help would be great. Thanks!

Mike

Outcomes