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.

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, 200917 yr by Guest

Thanks.

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

Thanks again.... :