Routing Multiple Jobs

[Nestor]

Good Afternoon everybody,

Can somebody point me in the right direction in how to do this or if this is even possible.

I have a list of Products(item Numbers) in a portal, and im trying to route all jobs to their corresponding "artist". What i don't want to do is send 1 email per Item Number, because multiple Products (Item number) can go to the same artist.

I want to be able to route hopefully with one click all Products(item Numbers) under my portal to the Artist that's assigned 2.

Thanks in advance.

[mr_vodka]

If you go to the related records of the portal then you can sort the records by the Artist_ID and then run a loop to capture the Items number into a variable and send one email to each person.

Something like the following:

Go to Related Records [show Only Related]

Sort REcords [Arist_ID, Item_ID Asc]

Go to Record [First]

Set Variable [$AristID; Artist_ID]

Set Variable [$Items; Item_ID]



If [Get (Foundcount) = 1 ]

  Send Email

  Exit Script []



Else If [ Get (Foundcount) ]

  Go to Record [Next]

  Loop

    If [ $AristID = Artist_ID ]

      Set Variable [$Items; Item_ID & $Items  & ¶  & Item_ID]

      Send Mail

      Go to Record [Next; Exit After Last]

    Else

      Set Variable [$AristID; Artist_ID]

      Set Variable [$Items; Item_ID]

      Go to Record [Next; Exit After Last]

    End If

  End Loop

End If

*Edit: You reference your $Items variable in the send mail script body to send them the list of gathered ItemIDs.

Edited January 28, 2009 by Guest

[Nestor]

Thanks.

with a few changes i was able to make this work.

Thanks again.... :