checkbox set value filter
I have a table of times associated with a schedule. There is a checkbox set with each time to assign one or more users from set labor pool. I have a global checkbox set that I use to control all the associated times and labor. I have a script that will add a user to the assigned labor field in all the associated times. it looks like this.
Set Variable [ $labor set to; Value:Event Day_Schedule::Labor Time Set ]
Go to Related Record [ From table: “Event Day_Schedule Times”; Using layout: “Schedule Date_Times” (Schedule Date_Times) ]
[ Show only related records; New window ] Go to Record/Request/Page
[ First ] Loop
Insert Calculated Result [ Schedule Date_Times::Assigned Labor; ¶ & $labor set to ]
Go to Record/Request/Page
[ Next; Exit after last ] End Loop
Close Window [ Current Window ]
Set Field [ Event Day_Schedule::Labor Time Set; "" ]
I would like to write one that works the other way and removed the selected value from the times without erasing the other labor records listed. I played with some filter functions but i am not having any luck.