[INSTRUCTIONS] How to add custom text fields to tickets

ntozier

Instructional:

So you want to add a custom text field to your tickets. You want this field to also be populated with a value when someone opens a ticket via email, and you want both clients and staff to populate this field with a value. Then this is the mod for you.

(Adding custom text fields to tickets in osTicket 1.7)

Enjoy!

Rionoskae

Fantastic Job on the MOD ntozier! Worked like a charm my first try.

Few things I noticed however :)

1. ) Ticket Preview didn't contain the new field. ( line 230 - ajax.tickets.php, this is of course purely preference )

2. ) Print Preview of Tickets shows default Values as well. Haven't figured out where this is controlled....

Thanks!

utopiasedge

Great Mod! Quick Question:

So I really like this mod. Most of my clients are businesses with multiple users, so I added a "companyName" text field.

I would love to be able to pull the companyName into the email template, using a variable along the lines of %{ticket.companyName} (or in the mod %{ticket.orderNumber})

What changes would need to be made, in order for that to work? (I am not a PHP expert, and today marks 5 days of using osTickets.)

Thanks

JLCarbwood

Link

The link for the MOD is not working. Can anyone provide a different link

utopiasedge

Link still works for me. YMMV.

JLCarbwood

Link

Thank you. I guess when I try the other day the were some problems with the server or something. It's working now and the Mod works perfect.

Thank you very much

mcardosoti

Blank fields

Hi,

The fields were created successfully, but I can not get the information answered by the client when I'm editing the ticket.

The picture illustrates what I'm trying to solve.

blank

I need help.

Forgiveness for my bad English.

ntozier

@[deleted], Sounds like you skipped a step when following the instructions then. I recommend that you go back through the instructions.

mcardosoti

@mcardosoti, Sounds like you skipped a step when following the instructions then. I recommend that you go back through the instructions.

I changed it: <?php echo $info; ?>

therefore: <?php echo Format:($ticket->getOrderNumber()); ?>

This way I solved my problem but do not know if this is acceptable.

Thanks!

ntozier

Sounds fine to me.

mcardosoti

Sounds fine to me.

Thanks! :)

mfmosem

HI,

Thanks for this. btw, I got a question

when I try I to print, the Order number data not appear.

How can I add this to the print page.

ntozier

You would edit to include the fields you added to your tickets.

\include\class.pdf.php

mfmosem

You would edit to include the fields you added to your tickets.
\include\class.pdf.php

It works! thanks.

sn666

data not adding to database

hello

I have problem with adding new collumns. I made all changes which were described in instruction included here:

http://www.tmib.net/adding-custom-text-fields-tickets(http://www.tmib.net/adding-custom-text-fields-tickets)

when I want to add new ticket, new fields appear but after sumbitting form there is no validation for new fields and data from new fields is not adding to database (new ticket is created but new fields have "NULL" value).

What can be wrong?

in instruction only one thing is understable for me, why in line below should be "agency" not "orderNumber" ?

'agency' => $this->getOrderNumber(),

Thanks in advance for all asistance :-)

ntozier

If you change the variable name any where in the mod, you should change it every where in every change that its listed in. Also you might want to consult your php and or MySQL error logs as it's likely to tell you where to look to fix the issues. You should especially change it in the form name="" statement(s).

amartin

data for new fields not submitting

Forgive my ignorance. I am also having a problem getting the submitted tickets to populate the database. If I populate the database manually they show up in the "view" pages and all the other places, but the "open" page for some reason will not add the data for the new fields to the database.

I too am a little ignorant about why 'agency' is used in the call on class.ticket.php.

This mod is exactly what I need to be able to duplicate some expected behavior that my users are used to getting from Spiceworks (which I am replacing due to bloat).

Any help pointing me in the correct direction would be greatly appreciated.

Thanks!

ntozier

You can call the field whatever you want. So long as you call it the same thing every where you should be good. I cannot give you more descriptive answers as to why it snot working for you with out the files you are working on.

amartin

Here are the files I have edited. I stopped before I got to the Staff files as I saw it wasn't entering them into the database. I have added 4 fields (site,room_num,computer_name, and type). I created them as VARCHAR fields in the database.

Thanks for giving your time to help.

[edited_files.zip](https://forum.osticket.com/assets/files/migrated/1/15a0b882eb377558a6dcfbe9a54f92e.zip)

amartin

found the other walkthrough

ntozier,

I am still not sure what I did wrong, but I switched to the dropdown walkthrough you have and it worked great! I am just going to use this mod to get the functionality I need. Thanks again for taking time to respond to my query and more importantly for taking time to produce these mods and document them so all of us can utilize their functionality.

For the others of you the link to that mod walkthrough is:

http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st(http://www.tmib.net/agencies-dropdown-and-admin-ui-osticket-17st)