x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 4 replies
  • Subscribers 139 subscribers
  • Views 957 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
Zoey Mattison

Use notification to display all products (ITMREF) in an array

SOLVED
Posted By

Hello, two things!

I am trying to set up a notification that will send an email containing all the specifics of a customer return when it is created. However, The formula to call the product code from the array, in this case:|

|[M:SRH1]ITMREF(indice)|

(M:SRH1 is the screen reference) only returns the product code from the first line of the return. Without access to any programming files, is it possible to loop this formula to spit out the product codes for the rest of the lines? Is there some documentation where I could learn this?

Also, while I was writing this, the dropdown menu (Screen SRH1) where I found ITMREF disappeared, and now it just shows the screen name but is unclickable. What am I missing here?

Thank you,

Zoey

  • 0

    Hy Zoey,

    Sorry to ask the question, but your workflow type is header or line ?

    Can you send a screenshot of the general tab and message tab please ?

  • 0 in reply to GERALDES Adrien

    Thanks for your reply! Here it is;

    The condition is of type header, the parameter being set to only trigger if the creation site is the one I deal with. Also, I did find somewhat of a workaround to the question I had asked. I just wrote out 30 lines whereby the index is increased by one for every line. Since we don't really see returns of more then 3-4 lines max, this is fine in theory. In concept, it does still display the numbers and slashes in the email even if the index is not populated, which is very Ugly. Here's what that looks like, etc:

    Zoey

  • +1 in reply to Zoey Mattison
    verified answer

    Hi Zoey,

    Your Workflow type is Header, so you cannot read dynamically every line in the object.

    If you want to manage the case with 5 lines or more, I advise to you to inspire yourseft with this standard workflow rule

    Your data model must read line and after, in the message table, you can setup the line dynamically 

  • +1 in reply to GERALDES Adrien
    verified answer

    Thank you very much for your detailed description of how to call lines through a workflow rule, by changing the type to line and setting the data model to the table you want to call from. This answer includes a lot of vital information that I was lacking, and I was able to learn about mess in the process which I previously had no idea about. I've received a lot of learning from this, and used your example to further display the email exactly how I want.

    Thank you very much!

    My Line ended up looking like this:

    The resulting output is:

    1. ITEMCODE for product ITEM DESCRIPTION - 1 PK

*Community Hub is the new name for Sage City