AnsweredAssumed Answered

checkbox set value filter

Question asked by ericjlindholm on Sep 24, 2014
Latest reply on Sep 24, 2014 by philmodjunk


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.