1 Reply Latest reply on Sep 24, 2014 12:46 PM by philmodjunk

    checkbox set value filter



      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.