Hello Oliver, Apologies for missing your original posting. It certainly is possible to turn the CustomerID or any other field into a drop-down. But it depends how you what to populated the drop-down. I created a drop-down field that populated via a database (not OTRS db) query. In every module where the field is referenced (using AgentEmail.pm as example) you must add something like:

# # build siteid select # # Connect to db and extract siteid info. # my $CMP_Get = "SELECT DISTINCT CL.SITE_ID " . "FROM SITE_ID"; # my $dbh = &external_db_connect(); my $sth = $dbh->prepare($Get); $sth->execute(); # while (my @SQLSiteID = $sth->fetchrow_array()) { $SiteIDData{$SQLSiteID[0]} = $SQLSiteID[0]; } # $Param{SiteIDStr} = "\n"; $Param{SiteIDStr} .= " Select SiteID<\/option>\n"; $Param{SiteIDStr} .= " New Customer<\/option>\n"; # my $SiteIDAssign = index($Param{"TicketFreeTextField1"},"value=\"\""); if ($SiteIDAssign == -1) { $SiteIDAssign = index($Param{"TicketFreeTextField1"},"value=\""); $SiteIDStart = ($SiteIDAssign + 7); $SiteIDEnd = index($Param{"TicketFreeTextField1"},"\" size=\"30\""); $GetSiteID = substr($Param{"TicketFreeTextField1"},$SiteIDStart,($SiteIDEnd - $SiteIDStart)); } foreach (sort keys %SiteIDData) { if ("$_" eq "$GetSiteID"){ $Param{SiteIDStr} .= "$SiteIDData{$_}<\/option>\n"; } else { $Param{SiteIDStr} .= "$SiteIDData{$_}<\/option>\n"; } } $Param{SiteIDStr} .= "<\/select>\n";

In this example, we connect to the external db and find a single occurrence of eack Site ID, when build the HTML 'SELECT' tag and associated values. If you replace 'TicketFreeTextField1' with 'CustomerID' it will work against that field. HTH, Graeme Oliver Buckie wrote:

...

Would be great if any could comment on this... I need to find a way of have both contact (individuals)and company (firm) fields. The latter being a drop-down...

Is it possible to turn the CustomerID field (in all instances) from a free-text field to a dropdown with pre-defined values (customer1, customer2, customer3 etc.)? If possible, would also be great if an agent could also add-to this field to populate the values.

Thanks for your comments. _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? =http://www.otrs.de/

---------- _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System?

...

http://www.otrs.de/

-- ============================================================== Graeme Brough rsc-uc@sun.com Customer Account Management Support Team Internal: x(70) 73488 Worldwide: +44 (0)1506 673488 Sun Remote Support Centre Linlithgow, UK ============================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

0 0