/build/static/layout/Breadcrumb_cap_w.png

Auto populating user data in custom fields

I want the user information to be visible in the Ticket itself. Can the system 'auto populate' custom fields with user information when a new ticket is created via email? Is this possible?

0 Comments   [ + ] Show comments

Answers (7)

Posted by: airwolf 13 years ago
Red Belt
0
Yeah, but you need to know the name of the field. Then you just use the same method as other fields by placing "CUSTOM1=value", etc. at the top of the email body.
Posted by: Transam 13 years ago
Orange Belt
0
Maybe I am being dense but I added "CUSTOM1=Mary" and "CUSTOM_1=Bill" (the latter how it displays in customization) to the email body, with and with parens, and nothing populated.
Posted by: airwolf 13 years ago
Red Belt
0
Oops, sorry. You need the '@' symbol before the variables. They've also got to be at the beginning of the body. So, your email would need to start with "@CUSTOM_1=Mary" without the quotes.
Posted by: Transam 13 years ago
Orange Belt
0
That did it. Thanks!!
Do you have any suggestions on how we could automate this? I will never get a user to populate CUSTOM_1=Rod in an email. We would like to stick to email, just got them to start using email instead of calling. Could we do something with Ticket Rules? Like run an update query?
Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
You could use a rule to populate some custom fields. for example if you wanted the user's phone # to appear in a custom field you could do:


select ID from HD_TICKET JOIN USER ON SUBMITTER_ID=USER.ID
WHERE CUSTOM_FIELD_VALUE0='



update HD_TICKET JOIN USER ON SUBMITTER_ID=USER.ID
SET CUSTOM_FIELD_VALUE0=USER.WORK_PHONE WHERE HD_TICKET.ID=<TICKET_IDS>
Posted by: steelc 13 years ago
Senior Yellow Belt
0
The information about changing a field via email with the @fieldname syntax is very interesting. I had written a rule that checked for comments beginning with COMMAND=CLOSE that would set the Status to closed and then use the rest of the email as the resolution note. This would allow technicians to easily close tickets from the field using their smartphones but I guess I didn't need to go through the trouble. I have never seen this capability addressed in the knowledge base or the documentation. Does anyone know why something as useful as this isn't mentioned? If it is mentioned, could you please point it out to me so I can see what else I've missed?
Posted by: GillySpy 13 years ago
7th Degree Black Belt
0
It is in the documentation -- "service desk guide". Section is: "Modifying ticket attributes using email"
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ