Order Guide Notification using variables from the Order Guide.

[Adrian Weber1]

I have a request to add a "Requested For" field to an Order Guide, using a reference the sys_user table.  When the order guide is submitted, the end-user would like for "Requested For" to get a notification that their request is started.  They would also like to have a notification sent to "Requested For" when the Order Guide is completed.  

We currently have 2 notification in place that are doing this functionality, but that is based on "Opened by", and not based on a variable.  So, if I open and fill out the order guide for "John Doe", then I get the START and END notifications, and "John Doe" doesn't.  We would like to have both myself and "John Doe" get these.  

Additionally, they would like to have a certain group get these same notifications.  I can add the group to the already existing notifications, but I'm pretty sure that the notifications are for ALL Order Guides, not just this one specific Order guide, and we don't want every Order Guide to send notifications to this group. 

Any help would be appreciated, but I did find the below already, and based on that, I don't think that what is being asked for is possible... 

"Where are variables on an Order Guide stored?

They are not stored anywhere. Once submitted they are erased. 

What we do is we create same variables on Item. And then we cascade them. 

Make sure name of this variables should be same on both order guide and Catalog item. Also you should select cascade variable on Order guide.

You can even hide this cascade variables on Item."

Thank you all for any help you can provide! 

[Ivano B]

Hi Dave

First of all you need to start looking into this table sc_cart.

Usually the requester and the requested for user are parked there before creating the request and the request items.

As common approach followed by ServiceNow the system creates a cart item and from the info available there will create the request and the requested items.

The requested for user can be populated at the checkout and not using cascade variables.

Visible in the picture is a normal behaviour and also the cart populated

This is exactly what you have to look after.

Other interesting thing to know is what is explained in this HI article.

The 'requested for' info can be passed in the URL

https://hi.service-now.com/kb_view.do?sysparm_article=KB0725189

About the notification. Remember an Order Guide is a just a way to set a request with a certain amount of requested items.

If you need to set the notification of a specific group you need to recognise the list of items contained in the request and then if matches the Order Guide send the notification.

Not sure if this will solve the issue but pretty sure can help you

Cheers

R0b0