Jump to content

Routing Multiple Jobs


This topic is 5536 days old. Please don't post here. Open a new topic instead.

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

Link to comment
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
Link to comment
Share on other sites

This topic is 5536 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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