Latest posts for the topic "Email Notification and Custom Field"

Email Notification and Custom Field

scottybhoy — GMT

Hi

I have been customising our Email notification. We have two Custom fields and instead of the Email notification pulling in the values, I can only get the actual Key ID.

I have pasted the code below if anyone would be able to help and highlighted the line of code I am having trouble with. (Lines 4 & 20)

Also, on another note, when using HTML with the Email notifications, the PHP "IF" statements to hide items that have no entries, i.e. noted and attachments seem to cause a blank email to be generated, however, removing the PHP "IF" statement resolved this issue.

Any ideas on both issues:
1) Custom field Text Value in Email Notifications
2) "IF" PHP statement in HTML Emails

Any help appreciated.

[code]
IT Support Service Request

[color=red]${sr.getAddonFieldValue("custList2")}[/color]
???HELP???Branch

${Urgency}
Requested Priority

${Priority}
Resolution Expected

${Status}
Current Status

${AssignedTo}
Support Technician

Service Request Information
Requested By: ${RequestUser}
???HELP???Preferred Contact Method ${sr.custList1}
Title: ${Title}
Category: ${Category} > ${SubCategory}

Problem Description
${Description}

Notes
${Notes}

Solution
${Solution}

Attached Files
${LinkToAttachments}

Total Queued Requests: $Total_Active_Requests
[/code]

Re:Email Notification and Custom Field

SylvainG — GMT
Hi, how do you edit the email notification? Through the Customize / Customized Notifications or through another way?

Notifications have their own if/else scripted statements, not sure how it will handle scripted PHP code.

See [url]http://www.ilient.com/help-page.htm?helpPageId=4250&edition=1&version=v8.1.02[/url]

Re:Email Notification and Custom Field

scottybhoy — GMT
Hi

I'm using the Customize>Notifications method to change the emails. Have the HTML working without the IF statements which will do I suppose

Only really need to know how to add the Custom field value to the notification instead of the KeyID showing. Any help on how to do that would be appreciated.

Re:Email Notification and Custom Field

SylvainG — GMT
In line 3, you have (line 4 is just text so I'm assuming you meant line 3) :

${sr.getAddonFieldValue("custList[b][color=red]2[/color][/b]")}[/color]

and in line 20 you have :

Preferred Contact Method ${sr.custList[b][color=red]1[/color][/b]}

Is this a typo? Shouldn't be '1' or '2' in both location?

Re:Email Notification and Custom Field

scottybhoy — GMT
Ok, to confirm (as it looks as though I have made a typo with regards to the lines):

${sr.getAddonFieldValue("[color=red]custList2[/color]")}[/color]

This line should show the Branch name of whoever submitted the ticket instead of the key value. We see the Key value instead of the Branch Name. I was trying different methods to pull in the text string, hence why the syntax is different on both lines, but none of them pull in the text string.

In this line:

Preferred Contact Method ${[color=red]sr.custList1[/color]}

this is the preferred contact method - we give them the choice of telephone or SysAid (Tel has the KeyID of 1 and SysAid has the KeyID of 2). The problem is, on this notification, instead of seeing "Telephone" or "SysAid" we see "1" or "2".

Ideally, both lines should show follow the same Syntax. I will upload latest code below. Hope I am not over complicating matters

Re:Email Notification and Custom Field

scottybhoy — GMT

${StatusNotification}

[color=red]${CustList2}[/color]Branch

${Urgency} ${DueDate}
Requested Priority

${Priority}
Resolution Expected

${Status}
Current Status

${AssignedTo}
Assigned Technician

Service Request Information
Requested By:${RequestUser}
[color=red]Preferred Contact Method: ${sr.custList1}[/color]Title: ${Title}
Category: ${Category} > ${SubCategory}

Problem Description
${Description}

Notes
${Notes}

Solution
${Solution}

Attached Files
${LinkToAttachments}

Total Queued Requests: $Total_Active_Requests

Re:Email Notification and Custom Field

SylvainG — GMT
Sorry, that's all the help I can give. Open an incident with Ilient, they can probably help.

Re:Email Notification and Custom Field

scottybhoy — GMT
Thanks - no worries - at least you tried!

Re:Email Notification and Custom Field

SA Consultant — GMT
I also have this issue with the custom fields created through Entities.
the code: ${sr.getAddonFieldValue("CustomColumn71sr")} shows the key and not the value.
Did anybody get a resolution??

Re:Email Notification and Custom Field

scottybhoy — GMT
remove the "sr." from the custom field and that should fix it - worked for me. Good Luck.