The users of the database we support regularly make requests for us to add a building to the database. There are a number of fields that are required, but when users submit our word doc version of the form they frequently leave some of the required fields blank, so I thought making the form in osTicket would help make certain that all of the required fields were filled in. That part works great and I can now force users to complete every field that is required to add a building to the database. Now, we would like the form to be a little smarter and automatically change the units of measurement based on the building's use. In the database, the quantity measurement for each building changes depending on the building's use code. Most of the building use codes measure the building quantity in square footage (SF), but some "buildings" use gallons (GA) or a unit count (EA). I have a custom list of all of my building use codes (over 3000) and I would like the quantity field label to change based on the building use code that is selected. Can this be done in Custom Forms? Would it be done using the properties tab in Custom Lists? Or is there some other place I would set that up? osTicket Version: v1.9.12 (19292ad)Web Server Software: Apache/2.4.20MySQL Version:  5.6.28PHP Version:  5.6.21

5 days later

I cannot think of any way to do that.

I appreciate response, Neil, so maybe you can explain what Karen was trying to suggest I do when I asked your support@ the same question: "we would suggest the list properties to uniquely identify specific characteristics for each item of the list. These fields are currently internal but you can communicate the information with the variables which can be included in email templates (Admin Panel > Emails > Templates) or Canned Responses. That way, you can define the properties as needed and they will populate automatically based on the field selection."

They are saying that if you populate the fields you can use email template variables to send the information to the client. 

Ah. That makes some sense.... Doesn't fit exactly what I was looking for, but I may be able to work with it. How do I make use of the Properties tab in the Custom List to identify which measurement type is associated with each Building Use code?

You are going to have to play with it... but I don't think that you can do what you mean.

I understand I won't be able to get the form to update correctly to show the measurement type based on the building use code, but I would like it to identify the correct measurement type in the confirmation email that is sent when the form is submitted. How do I modify the Properties to give me a variable for the email template that will show the correct unit of measure for each building use code? The are no Help Tips on either the Items or Properties of the Manage Custom Lists page and I have not been able to find any user instructions here in forums or in the wiki for how to use Custom List Properties. 

12 days later

Is there additional documentation available for how to utilize the Properties for Custom Lists? 

4 years later

@cartmega please do not be a necromancer.

This thread is 4 years old.
Killing zombie thread with a head shot.

Write a Reply...