User Field

Bung

Hi friends,

I have an enterprise with a 200 employees more or less. when i open a ticket from staff panel i have to fill email address etc over and over. i would want to add an user field selected from a client database. is it posible?

masino_sinaga

Have you tried by typing few characters in email textbox from staff panel, then you should see there would be a pop listbox appearing?

Then, when you click one of the items on the pop listbox, the email, name, and phone will automatically filled-in to its textbox.

See also my MOD regarding this via the topic below:

- http://www.osticket.com/forums/showthread.php?t=2021(http://www.osticket.com/forums/showthread.php?t=2021)

Good luck!

Best regards,

Masino Sinaga

Bung

Thanks

Thanks a Lot My friend for answer me.

it´s perfect for my situation but i just have a question. i have followed this mod

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

And i wish to know if there´s any posibility that this take the user from the table CLIENT_USER instead of TICKET_TABLE in the mod that you send me?

Thanks a lot my friend

masino_sinaga

Of course there is always the possibility.

Just replace TICKET_TABLE with CLIENT_TABLE at my MOD above, if you trully implement MOD at that topic number 1105.

Best regards,

Masino Sinaga

Bung

Hi friend,

i have done that you said me but it´s doesn´t work. I don´t have idea so much about php and i think that something do wrong this is tthe code that i have

$sql='SELECT DISTINCT email,name,phone FROM '.CLIENTS_TABLE.' WHERE email LIKE \''.$input.'%\' ORDER BY created LIMIT '.$limit;

$resp=db_query($sql);

if($resp && db_num_rows($resp)){

while(list($email,$name,$phone)=db_fetch_row($resp)) {

$name=(strpos($name,'@')===false)?$name:'';

$items ='{"id": "'.$email.'", "value": "'.$email.'", "info": "'.$name.'|'.$phone.'"}';

}

$result= '{"results": }';

return $result;

}

Please could you help me?

Thanks a lot you are doing me a big favour.

masino_sinaga

Did you get an error or something else?

Best regards,

Masino Sinaga

Bung

hi again,

I don´t have any error it´s just that the pop-up not appears

i don´t know what happened. the other mod crate a table with firstname and lastname and yours takes a fullname. it´s probably that this is the problem.

Thanks a lot

masino_sinaga

Plase re-check again your code by comparing my MOD with yours and make sure everything is fine except for the table name.

Best regards,

Masino Sinaga

Bung

thanks

I think that the problem is that it´s not connect with the CLIENT_TABLE. I think that i must connect with this table in a other page of the aplication but i don´t know what