/build/static/layout/Breadcrumb_cap_w.png

Autopopulating lists with entries from Custom Fields

1. Is it possible to autopopulate one field by the selection of another field?  for example, automatically filling in an email address based on a selectable user name?  (Example, user puts down a name in the field, then another field is automatically filled with the email belonging to the user, similar to Gmail.)D24bioGJhDteAAAAAElFTkSuQmCC



0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 months ago
Red Belt
0

The short answer is no, whilst you can populate a custom field using quite an advanced SQL statement, the one fly in the ointment is that you need to save the ticket to either get the SQL to update or to run a rule to populate the second field


Comments:
  • Is there a way to make the query use the prompt in the ticket in a WHERE clause?(As in as the ticket is saved, The query uses the ticket's value in that ticket for its own values) Like an ID value inputted by the owner in one column, which is used in the query for another column for the assigned person, in the same ticket. - MC9921 3 months ago
    • Again, No, mainly because you have no way to pull the current ticket ID in as a variable - Hobbsy 3 months ago

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