Jump to content
Sign in to follow this  
Nestor

Routing Multiple Jobs

Recommended Posts

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.

Routing_Jobs.jpg

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

Thanks.

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

Thanks again.... :

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.