Gossamer Forum
Home : Products : DBMan : Customization :

Append to 2nd DB using info from add form [update]

Quote Reply
Append to 2nd DB using info from add form [update] In reply to
Ok, I found a solution for now via a form button, code below. However, can I automate this now so that I don't have to click the form button and the field is automatically updated?

Add_Success
Code:
&switch_cols_to_tickets;
print qq|<form action="$db_script_url" method="POST"><input type=hidden name="db" value="tickets"><input type=hidden name="uid" value="$db_uid">|;
&ticket_record(&get_record($in{Ticket}));
print qq|<INPUT TYPE="SUBMIT" NAME="modify_record" VALUE="Add to Ticket"></form>|;
&switch_cols_to_work;

sub ticket_record
Code:
my (%rec) = @_;
($db_auto_generate and print &build_html_record_form(%rec) and return);

$work .= $rec{'Work'} . ",$in{'ID'}";
print qq|
<INPUT TYPE="hidden" NAME="AddedBy" VALUE="$rec{'AddedBy'}">
<INPUT TYPE="hidden" NAME="CreateDate" VALUE="$rec{'CreateDate'}">
<INPUT TYPE="hidden" NAME="ID" VALUE="$rec{'ID'}">
<INPUT TYPE="hidden" NAME="ModifyDate" VALUE="$in{'Date'}">
<INPUT TYPE="hidden" NAME="RefName" VALUE="$rec{'RefName'}">
<INPUT TYPE="hidden" NAME="ID" VALUE="$rec{'ID'}">
<INPUT TYPE="hidden" NAME="Userid" VALUE="$rec{'Userid'}">
<INPUT TYPE="hidden" NAME="Requestor" VALUE="$rec{'Requestor'}">
<INPUT TYPE="hidden" NAME="Phone" VALUE="$rec{'Phone'}">
<INPUT TYPE="hidden" NAME="Email" VALUE="$rec{'Email'}">
<INPUT TYPE="hidden" NAME="Description" VALUE="$rec{'Description'}">
<INPUT TYPE="hidden" NAME="Work" VALUE="$work">
<INPUT TYPE="hidden" NAME="Resolution" VALUE="$rec{'Resolution'}">
<INPUT TYPE="hidden" NAME="Status" VALUE="$rec{'Status'}">
|;
Subject Author Views Date
Thread Append to 2nd DB using info from add form Helpdesk 2390 Jun 29, 2002, 10:54 PM
Thread Append to 2nd DB using info from add form [update]
Helpdesk 2282 Jul 4, 2002, 12:56 PM
Thread Re: [Helpdesk] Append to 2nd DB using info from add form [update]
LoisC 2289 Jul 4, 2002, 1:06 PM
Thread Re: [LoisC] Append to 2nd DB using info from add form [update]
Helpdesk 2278 Jul 4, 2002, 1:15 PM
Thread Re: [Helpdesk] Append to 2nd DB using info from add form [update]
LoisC 2286 Jul 4, 2002, 7:08 PM
Thread Re: [LoisC] Append to 2nd DB using info from add form [update]
Helpdesk 2285 Jul 4, 2002, 7:45 PM
Thread Re: Append to 2nd DB using info from add form [update]
Helpdesk 2261 Jul 8, 2002, 7:47 AM
Post Append to 2nd DB using info from add form [update]
Helpdesk 2238 Jul 22, 2002, 6:10 PM