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} = "<select name=\"TicketFreeText1\"
> onchange=\"document.compose.ExpandCustomerName.value='3';
> document.compose.submit(); return false;\">\n";
> $Param{SiteIDStr} .= "<option value=\"\"> Select SiteID<\/option>\n";
> $Param{SiteIDStr} .= "<option value=\"new\"> 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} .= "<option selected
> value=\"$_\">$SiteIDData{$_}<\/option>\n";
> } else {
> $Param{SiteIDStr} .= "<option
> value=\"$_\">$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 [EMAIL PROTECTED]
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
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/
