Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
SysAid tip - How to: add custom fields to the service request activity form ?  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
Haim
SysAider

Joined: 15/04/2008
Messages: 2449
Offline

In order to add custom fields to the service request activity form, please go to Preferences -> Customize -> Customized Forms tab and make the following changes in the Service Request Activities box.

Look for these four lines as they represent the Total Time field:
<tr>
<td class="Form_Ctrl_Label" ><label> $resource.getString('SRWorkTime.total'):</label></td>
<td class="Form_Ctrl_Fields"><table><tr>$frm.printControl('totalTime', true, true, null)</tr></table></td>
</tr>

After these lines, add the following lines:
<tr>
<td class="Form_Ctrl_Label" ><label> $resource.getString('FIELD-CAPTION'):</label></td>
<td class="Form_Ctrl_Fields"><table><tr>$frm.printControl('FIELD-NAME', MANDATORY?, VISIBLE?, 'DEFAULT-VALUE')</tr></table></td>
</tr>

Replace the following with:
1. FIELD-CAPTION – replace with the caption of the field (preferably from the translation – e.g SRWorkTime.cust_int1)
2. FIELD-NAME – replace with the name of the field you wish to add from the following options: cust_list1, cust_list2, cust_text1, cust_text2, cust_int1, cust_int2, cust_int3, cust_int4, cust_notes, cust_date1, cust_date2.
3. MANDATORY? - replace with either true or false
4. VISIBLE? - replace with either true or false
5. DEFAULT-VALUE – leave blank or set the default value.

This will add the field to the form. You also need to add a column for this on the activities table. To do that, look for the following lines, which represent the Total Time column:
<th style="cursor:text;">$resource.getString('SRWorkTime.total')</th>

After that line, add the following line:
<th style="cursor:text;">$resource.getString('FIELD-CAPTION')</th>

This will add the column heading. You'll need to add the actual values to the column, so look for the following line:
<td class="Form_Ctrl_Label">$activity.totalTimeStr</td>

Add the following line after the above line:
<td class="Form_Ctrl_Label">$activity.custInt1</td>
This refers to the custom integer field. You can use $activity.custText1, $activity.custList1, etc for other field types.

Best regards.
SysAid team

Pushing IT forward
SysAid#1
SysAid Mod


SysAider from release 6.5 Pathfinder
Joined: 02/11/2008
Messages: 702
Offline

Thank You Hiam.

I tried it and it works fine.
[Email]
Boonew
SysAider


SysAider from release 7 South Africa Pathfinder
Joined: 06/07/2010
Messages: 19
Offline

Hi Haim,

how do I get the datepicker to sit next to the text box when I insert a cust_date2 field.

Currently the text box and the datepicker are split apart as if the cell is 100%, the text field is left aligned and the date picker is right aligned..

my code looks like this..



I've tried to resize the but it doesn't appear to work...

regards
Warren

This message was edited 1 time. Last update was at 31/08/2010 04:43:31


regards
Warren

PS. I have a whole bunch of unanswered Topics HERE
juergens
SysAider

SysAider from release 7.5 Switzerland
Joined: 01/11/2010
Messages: 4
Offline

Dear SysAid professionals

I have modified my activities, as described in the starter of this topic, with a custom list. Everything workes fine, but now I have a "optical" issue in the activities table. If I include the text <td class="Form_Ctrl_Label">$activity.custList1</td> in the table, I get the key and not the caption of the custom list in the table, which is not really meaningful. (see attachment).

In the structure of the database the field cust_list1 is available in the dbo.work_report. The caption is in the dbo.cust_values as value_caption. Is there a possibility to relate the tables in the output?

How do I get the caption in my activities table?

B.t.w. as I browsed through the database, I saw that in the dbo.work_report all my tests in a not saved service request where put down in the table as service_req_id "0". Isn't that a possibility to create trash in the db? If someone creates a lot of activities in a non saved service request it will fill up my database?

Thank you in advance.

Juergen
[Thumb - Custom_Activity.png]
 Filename Custom_Activity.png Download
 Description
 Filesize 45 Kbytes
 Downloaded:  8 time(s)

Fumbler
SysAider

SysAider from release 7.5
Joined: 11/07/2011
Messages: 1
Offline

juergens wrote:Dear SysAid professionals

I have modified my activities, as described in the starter of this topic, with a custom list. Everything workes fine, but now I have a "optical" issue in the activities table. If I include the text <td class="Form_Ctrl_Label">$activity.custList1</td> in the table, I get the key and not the caption of the custom list in the table, which is not really meaningful. (see attachment).

In the structure of the database the field cust_list1 is available in the dbo.work_report. The caption is in the dbo.cust_values as value_caption. Is there a possibility to relate the tables in the output?

How do I get the caption in my activities table?

Hi All

Having the same issue, has any one resolved yet? I would also like the caption instead of the key in the activities table.

Many thanks.
Joseph Zargari
SysAid Customer Relations


Meet me in Vegas - SysAid technology Conference - 28-30/4/2010
Joined: 26/03/2006
Messages: 423
Offline

You can use $activity.getCustList1Caption() instead. This will bring in the text value of the custom list.

Thanks,
Joseph.
Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011
   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   02:00 AM - 04:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use