How to Add new field in the submit ticket form

hamidi

Hi guys,

a few question here.

how can i add new field such as department for user (in a drop down list) while they want to send a new ticket. so it can be easier to technician know where is user come from. in a default form, we have full name, email address, telephone, help topic, subject and message.now i want to add department and it was compulsory to filled out

hope u guys can help me. :)

exilepc

I would love to do this, someone please help this man so I can get help too

exilepc

http://osticket.com/forums/showthread.php?t=873(http://osticket.com/forums/showthread.php?t=873)

masteryoda

Easy...sorta

I just did this, but you need to either make a new table in mysql or add a column to OS Ticket's ticket table. I chose to create my own table.

In include/staff/newticket.php around line 42 I inserted a new row into their form/table.

KMC

<tr>

<td align="left"><b>Account #:</b></td>

<td>

<input type="text" name="kmc_account_number" size="25" value="">

</td>

</tr>

<tr>

<td align="left"><b>Website:</b></td>

<td>

<input type="text" name="kmc_domain" size="50" value="">

</td>

</tr>

END KMC

Then you have to receive it when the form is processed...

In include/class.ticket.php around line 1367

after

//TODO: recover from postMessage error??

insert to receive the variable form data and then do what you will with it...

$kmc_email=$var; // Gets email from form field

$kmc_filenumber=$_POST; // Grabs input from Filenumber field on form

$kmc_domain=$_POST; // Gets domain from form

$kmc_ticket_attach=kmc_try_to_attach($kmc_filenumber, $kmc_email, $kmc_domain, $id, $extId);

Here I get the variables and then use them to run my custom function kmc_ticket_attach that attaches this OS Ticket to our database of customers.

Let me know if you have any more q's!

masteryoda

For Customer

Just noticed you want this for the customer...I would recommend putting it in both entry points for customer and staff, but you would do the same thing I mentioned in

include/client/open.inc.php around line 48 between the row of your choice depending where you want your input to appear on page.

</tr>

...Insert your code here...

<tr>

hamidi

new table of database

thanks for suggestion.

but i still not clear when u say

"you need to either make a new table in mysql or add a column to OS Ticket's ticket table. I chose to create my own table."

maybe u can help me with give your table and the code to insert it

masteryoda

Study php and MySQL

This project may be beyond your abilities if you are not familiar with php and MySQL. I suggest reading up on it and then come back to this project. I would recommend a book called something like Head First PHP, it really helped me learn.