| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 20/07/2009 10:51:18
|
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 |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 29/10/2009 22:13:27
|
SysAid#1
SysAid Mod

Joined: 02/11/2008
Messages: 702
Offline
|
Thank You Hiam.
I tried it and it works fine.
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 31/08/2010 04:42:16
|
Boonew
SysAider

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 |
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 02/02/2011 03:58:30
|
juergens
SysAider
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
|
| Filename |
Custom_Activity.png |
|
| Description |
|
| Filesize |
45 Kbytes
|
| Downloaded: |
8 time(s) |
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 11/07/2011 07:54:16
|
Fumbler
SysAider
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.
|
|
|
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 14/07/2011 22:39:14
|
Joseph Zargari
SysAid Customer Relations

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.
|
|
|