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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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