Hi,<br><br>To create similar to Status field you will need to add Picklist type custom field.<br><br>When a custom field 'SN' is added, it appears under Custom Information Block. If you want to move it into Trouble Ticket Information block,<br>
you will have to update vtiger_field as described below.<br><br>1. In table get the blockid of LBL_TICKET_INFORMATION<br>SELECT blockid FROM vtiger_blocks WHERE blocklabel='LBL_TICKET_INFORMATION'<br><br>2. Get the fieldid of the new custom field that was added with label 'SN'<br>
SELECT * FROM vtiger_field WHERE generatedtype=2 AND fieldlabel='Cost'<br><br>Note: Save the result record given by previous record. It might be useful to revert back.<br><br>3. Now change the field and block association<br>
UPDATE vtiger_field set block=BLOCKID where fieldid=FIELDID<br><br>Here BLOCKID is the value obtained from Step1 and fieldid is the value obtained from Step2<br><br>Regards,<br>Prasad<br>vtiger Team<br><br><div><span class="gmail_quote">On 10/22/08, <b class="gmail_sendername">WenZhi Yi(易文志)</b> <<a href="mailto:wzhyi@hillstonenet.com">wzhyi@hillstonenet.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="ZH-CN">
<div>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US">Hi ,Asha</span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"> Thank you for
your help,my mean: I want to add a field named "sn" , pls look
follows picture, but not add in Custom Fields ,I want my add '" sn"
is look like "status",how to do ? I know I will change code if that .but I
hope you help me.</span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US">Regards</span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"><img src="cid:image001.png@01C9345E.5E4F8650" height="273" width="1251"></span><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"></span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p><span style="font-size: 10.5pt; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p><b><span style="font-size: 10pt;">发件人<span lang="EN-US">:</span></span></b><span style="font-size: 10pt;" lang="EN-US">
<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers-bounces@lists.vtigercrm.com</a>
[mailto:<a href="mailto:vtigercrm-developers-bounces@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers-bounces@lists.vtigercrm.com</a>] </span><b><span style="font-size: 10pt;">代表 </span></b><span style="font-size: 10pt;" lang="EN-US">Asha<br>
</span><b><span style="font-size: 10pt;">发送时间<span lang="EN-US">:</span></span></b><span style="font-size: 10pt;" lang="EN-US"> 2008</span><span style="font-size: 10pt;">年<span lang="EN-US">10</span>月<span lang="EN-US">22</span>日<span lang="EN-US"> 15:31<br>
</span><b>收件人<span lang="EN-US">:</span></b><span lang="EN-US"> <a href="mailto:vtigercrm-developers@lists.vtigercrm.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtigercrm-developers@lists.vtigercrm.com</a><br>
</span><b>主题<span lang="EN-US">:</span></b><span lang="EN-US"> Re:
[Vtigercrm-developers] one problem about trouble tickets</span></span></p>
</div><div><span class="e" id="q_11d2397931e6fb49_1">
<p><span lang="EN-US"> </span></p>
<p style="margin-bottom: 12pt;"><span lang="EN-US">Hi Wenzh Yi,<br>
<br>
Most easiest thing is to add a custom field for module Trouble tickets through
Settings->Custom Fields<br>
<br>
Let me know if you are looking for something different.</span></p>
<div>
<p><span><span lang="EN-US">On 10/22/08, <b>WenZhi
Yi(</b></span><b>易文志<span lang="EN-US">)</span></b><span lang="EN-US"> <<a href="mailto:wzhyi@hillstonenet.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">wzhyi@hillstonenet.com</a>> wrote:</span></span><span lang="EN-US"></span></p>
<div>
<div>
<p><span lang="EN-US">Hi,</span></p>
<p><span lang="EN-US"> I wan't
know how to add a field in table name trouble tickets ,pls tell me .</span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US">Thanks!</span></p>
<p><span style="font-size: 10pt;" lang="EN-US"> </span><span lang="EN-US"></span></p>
<p><span style="font-size: 10pt;" lang="EN-US">Wenzh Yi<br>
</span><span style="font-size: 13pt;" lang="EN-US">Hillstone Networks</span><span style="font-size: 11pt;" lang="EN-US"><br>
</span><span style="font-size: 10pt;" lang="EN-US">Tel: (010)82897229-8026<br>
<a href="http://www.hillstonenet.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.hillstonenet.com</a></span><span lang="EN-US"></span></p>
<p><span lang="EN-US"> </span></p>
</div>
</div>
<p><span lang="EN-US"><br>
_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> </span></p>
</div>
<p><span lang="EN-US"><br>
<br clear="all">
<br>
-- <br>
Regards,<br>
Asha<br>
vtiger Team </span></p>
</span></div></div>
</div>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>