Difference between revisions of "Custom Tabs and Fields"

From High5Wiki
Jump to navigation Jump to search
(Created page with "In SME 7.1 you have the ability to add custom tabs with custom fields to your records. You can call these fields any name you want and choose between many field types. In the sea...")
 
Line 7: Line 7:
  
 
View the video below for an overview or read through the guide for more information about setting up custom fields.
 
View the video below for an overview or read through the guide for more information about setting up custom fields.
 +
 +
<videoflash>Del59utdPR8</videoflash>
 +
 +
== Types of Custom Fields ==
 +
 +
{|
 +
| style="border-width: 1pt; border-style: solid; border-color: windowtext; padding: 0in 5.4pt; width: 1.45in; background: none repeat scroll 0% 0% rgb(217, 217, 217)" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
| style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; width: 220.5pt; background: none repeat scroll 0% 0% rgb(217, 217, 217)" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Definition</div>
 +
| style="border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; width: 207.9pt; background: none repeat scroll 0% 0% rgb(217, 217, 217)" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Sample</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Boolean</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">True or false field. Check the box for true. Leave the box unchecked for false.</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:Boolean.jpg]]</div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Button</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">This requires custom code to respond to the button.  For example you can add code that runs some other program when the button is pressed.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:Button.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Currency</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">Uses the default currency set by Windows language and settings, for example $.  Type numbers in the field or click in the field to use the calculator.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:Currency.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Date</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Click in the field and select a date from the calendar.</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:date.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">DateTime</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Enter both date and time. Select a date from the calendar. Use  to increase or decrease time.</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">[[Image:DateTime.jpg]]</div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Integer</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Enter numbers only.  Cannot enter a decimal. Limit to 9 digits</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:Integer.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">LargeInt</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Enter numbers only.  Cannot enter a decimal.  </div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:LargeInt.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Memo</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">Used for a paragraph or large block of text versus one line of text.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Numeric(decimal)</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">Enter a number with decimals.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">[[Image:NumericDecimal.jpg]]</div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">PickList</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">Drop down list.  The drop down list can be configured with an unlimited number of selections.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Enter the drop down list by clicking in the PickList column. [[Image:EditPickList.jpg]]</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:Picklist.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">String</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt"><font color="black">Used for a single line of text.  For a block or paragraph of text, use Memo.</font></div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">  [[Image:string.jpg]]</div>
 +
|-
 +
| style="border-width: medium 1pt 1pt; border-style: none solid solid; border-color: rgb(240, 240, 240) windowtext windowtext; padding: 0in 5.4pt; background-color: transparent; width: 1.45in" width="139" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">Time</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 220.5pt" width="294" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">Time field</div>
 +
| style="border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: rgb(240, 240, 240) windowtext windowtext rgb(240, 240, 240); padding: 0in 5.4pt; background-color: transparent; width: 207.9pt" width="277" valign="top" |
 +
<div style="line-height: normal; margin: 0in 0in 0pt">  </div><div style="line-height: normal; margin: 0in 0in 0pt">[[Image:Time.jpg]]</div><div style="line-height: normal; margin: 0in 0in 0pt">  </div>
 +
|}
 +
 +
== Create Custom Fields ==
 +
 +
1.Go to Utilities module.
 +
<br>2.      Click Custom Tabs.
 +
<br>3.      Click Run It.
 +
The Custom Table Designer window will open. This is where you will select what module you are adding the tab and fields to. You will assign a name for the tab and layout the custom fields on the tab.
 +
<br>4.      Click New.
 +
<br>5.      In the Module field, select the module you want to add a new custom tab to.
 +
<br>6.      In the Tab Name field, enter a name for the custom tab.
 +
<br>7.      Click Save.
 +
Now the tab is created, you can start adding the fields to the new tab.
 +
<br>8.      Click Edit.
 +
<br>9.      Click [[File:PlusSign.jpg]] at the bottom of the Custom Table Designer.
 +
 +
[[File:AddNewField.jpg]]
 +
 +
<br>10.  Notice a line was added to the Design tab.
 +
 +
<br>[[File:NewFieldRow.jpg]]
 +
 +
<br>11.  In the Field Name and Field Description, enter the name of the field. If the name is more than one word, remove the spaces between the words in the Field Name column. This is the database field. The Field Description is the name that shows on the custom tab.
 +
<br>12.  Select the '''Field Type'''.
 +
<br>13.  Place the field on the custom tab using the following columns:
 +
<br>'''Left''' – number of pixels from the left side of the tab.
 +
<br>'''Top''' – Number of pixels from the top of the tab.
 +
<br>'''Height''' – Number of pixels high the cell is.
 +
<br>'''Width''' – Number of pixels wide the cell is.
 +
<br>14.  Click '''Save'''.
 +
 +
'''**NOTE**''' It is not advised to change the field type once you started to enter data into the field. If you decide to change the field type after data is entered into the field, then all the data that was entered into the original field type will be lost.
 +
 +
 +
[[File:Examples.jpg]]
 +
 +
[[File:WidthExamples.jpg]]
 +
 +
Preview what the fields will look like by clicking the View tab in the Custom Table Designer window.
 +
 +
[[File:Preview.jpg]]
 +
 +
To see the custom tab in the module, close and reopen SME. Go the module and select the Custom Tab.
 +
 +
 +
== Custom Tab Order ==
 +
 +
If you create more than one custom tab for a module, you can determine the order of the tabs. In the Custom Table Designer window, locate the Tab Order field. Enter 1 in the tab you want on the left.
 +
In the example below, the VIP Info tab has 1 in tab order so it will be on the left. The Standard tab has 2 in the tab order so it will be on the right. If there was another tab, we would enter 3 to have it to the right of the standard tab.
 +
 +
[[File:CustomTabOrderExample.jpg]]
 +
 +
== Custom Tab - Admin Access ==
 +
 +
In the Custom Table Designer window, there is a checkbox for Admin Access. (image below)
 +
 +
[[File:admiAccess.jpg]]
 +
 +
If this box is checked, then the tab is only visible to SME users assigned to user groups where User Is An '''Administrator''' is checked (image below).
 +
 +
[[File:UserGroup_IsAdmin.jpg]]
  
  
 +
== Edit Custom Fields ==
  
 +
#      Go to '''Utilities''' module > '''Custom Tabs'''.
 +
#      Click '''Run It'''.
 +
#      Click '''Search''' and select the custom tab containing the fields you want to edit.
 +
#      Click '''Edit'''.
 +
#      Add more fields by clicking [[File:PlusSign.jpg]] at the bottom or make changes to existing fields.
 +
#      Click '''Save'''.
 +
#      Click the '''View''' tab to preview your changes.
 +
#      Close and reopen SME. Go to the custom tab in the module to see your changes.
  
<videoflash>Del59utdPR8</videoflash>
+
 
 +
== Field Access Level ==
 +
You can assign an access level to each custom field. Only users that are authorized to see that level can access the custom field.
 +
 
 +
Someone with access 0 can see everything, access 1 would only see fields with access 1 or higher, user group access 2 would not see 0 and 1 fields and would see 2 and higher, etc. Access levels can go to 5.
 +
 
 +
<u>'''Assign SME user groups an access levels'''</u>
 +
#      Go to '''Setup module''' > '''Company'''.
 +
#      Click User Groups.
 +
#      Click '''Search''' to locate the user group you want to apply an access level to.
 +
#      Select the Administrative Clearances tab.
 +
#      Locate the User Field Access Level field in the right column.
 +
#      Click '''Edit'''.
 +
#      Enter the access level (1-5)
 +
#      Click '''Save'''.
 +
 
 +
 
 +
<u>'''Assign an access level to the custom fields'''</u>
 +
#      Go to''' Utilities''' module> '''Utilities'''.
 +
#      Click''' Custom Tabs''' and click '''Run It'''.
 +
#      Click '''Search''' and select the tab containing the fields you need to edit.
 +
#      Click '''Edit'''.
 +
#      Locate the '''Access Level''' column (circled below).
 +
 
 +
[[File:FieldAccessLevel.jpg]]
 +
 
 +
<br>6.      Enter the access level for the custom field.
 +
<br>7.      Click Save.
 +
 
 +
'''*NOTE* Access levels are fixed, so you cannot allow a user group to see fields with access levels 1, 5, and 10 but no others.'''
 +
 
 +
 
 +
== Form Code ==
 +
 
 +
Form code is entered in the customer and then on the work order.  (Image below)
 +
 
 +
[[File:CustomerFormCode.jpg]]
 +
 
 +
The tabs matching this form code and the tabs with no form code and will show on the work order.
 +
 
 +
<br>You assign the form code to the custom tab (circled in image below). Form codes can be numbers or text.
 +
 
 +
[[File:AssignFormCode.jpg]]
 +
 
 +
<br>For example you have a custom tab created for Home Depot customers and you assigned the Form Code of HD. You set the form code on the home depot billing company and every time you create an order for a customer with HD as billing, it sets that form code on the service order and only shows the custom tabs with the HD form code AND any custom tab with a blank form code.

Revision as of 17:13, 17 June 2011

In SME 7.1 you have the ability to add custom tabs with custom fields to your records. You can call these fields any name you want and choose between many field types. In the search window you can sort by the custom fields just like all the other fields in SME. You can also apply an access level to each of the fields to restrict user groups from seeing the field.

CustomTabsFields.jpg


In 7.1, you will see a tab called Custom Tabs in your Leads, Customer, Maintenance Contracts, Customer Equipment, Service, Install, Invoices, and Users. On this tab, you can add multiple custom tabs containing custom fields as shown in the image above.

View the video below for an overview or read through the guide for more information about setting up custom fields.

<videoflash>Del59utdPR8</videoflash>

Types of Custom Fields

Definition
Sample
Boolean
True or false field. Check the box for true. Leave the box unchecked for false.
Boolean.jpg
Button
This requires custom code to respond to the button. For example you can add code that runs some other program when the button is pressed.
Button.jpg
Currency
Uses the default currency set by Windows language and settings, for example $. Type numbers in the field or click in the field to use the calculator.
Currency.jpg
Date
Click in the field and select a date from the calendar.
Date.jpg
DateTime
Enter both date and time. Select a date from the calendar. Use to increase or decrease time.
DateTime.jpg
Integer
Enter numbers only. Cannot enter a decimal. Limit to 9 digits
Integer.jpg
LargeInt
Enter numbers only. Cannot enter a decimal.
LargeInt.jpg
Memo
Used for a paragraph or large block of text versus one line of text.
Numeric(decimal)
Enter a number with decimals.
NumericDecimal.jpg
PickList
Drop down list. The drop down list can be configured with an unlimited number of selections.
Enter the drop down list by clicking in the PickList column. EditPickList.jpg
Picklist.jpg
String
Used for a single line of text. For a block or paragraph of text, use Memo.
String.jpg
Time
Time field
Time.jpg

Create Custom Fields

1.Go to Utilities module.
2. Click Custom Tabs.
3. Click Run It. The Custom Table Designer window will open. This is where you will select what module you are adding the tab and fields to. You will assign a name for the tab and layout the custom fields on the tab.
4. Click New.
5. In the Module field, select the module you want to add a new custom tab to.
6. In the Tab Name field, enter a name for the custom tab.
7. Click Save. Now the tab is created, you can start adding the fields to the new tab.
8. Click Edit.
9. Click PlusSign.jpg at the bottom of the Custom Table Designer.

AddNewField.jpg


10. Notice a line was added to the Design tab.


NewFieldRow.jpg


11. In the Field Name and Field Description, enter the name of the field. If the name is more than one word, remove the spaces between the words in the Field Name column. This is the database field. The Field Description is the name that shows on the custom tab.
12. Select the Field Type.
13. Place the field on the custom tab using the following columns:
Left – number of pixels from the left side of the tab.
Top – Number of pixels from the top of the tab.
Height – Number of pixels high the cell is.
Width – Number of pixels wide the cell is.
14. Click Save.

**NOTE** It is not advised to change the field type once you started to enter data into the field. If you decide to change the field type after data is entered into the field, then all the data that was entered into the original field type will be lost.


Examples.jpg

WidthExamples.jpg

Preview what the fields will look like by clicking the View tab in the Custom Table Designer window.

Preview.jpg

To see the custom tab in the module, close and reopen SME. Go the module and select the Custom Tab.


Custom Tab Order

If you create more than one custom tab for a module, you can determine the order of the tabs. In the Custom Table Designer window, locate the Tab Order field. Enter 1 in the tab you want on the left. In the example below, the VIP Info tab has 1 in tab order so it will be on the left. The Standard tab has 2 in the tab order so it will be on the right. If there was another tab, we would enter 3 to have it to the right of the standard tab.

CustomTabOrderExample.jpg

Custom Tab - Admin Access

In the Custom Table Designer window, there is a checkbox for Admin Access. (image below)

AdmiAccess.jpg

If this box is checked, then the tab is only visible to SME users assigned to user groups where User Is An Administrator is checked (image below).

UserGroup IsAdmin.jpg


Edit Custom Fields

  1. Go to Utilities module > Custom Tabs.
  2. Click Run It.
  3. Click Search and select the custom tab containing the fields you want to edit.
  4. Click Edit.
  5. Add more fields by clicking PlusSign.jpg at the bottom or make changes to existing fields.
  6. Click Save.
  7. Click the View tab to preview your changes.
  8. Close and reopen SME. Go to the custom tab in the module to see your changes.


Field Access Level

You can assign an access level to each custom field. Only users that are authorized to see that level can access the custom field.

Someone with access 0 can see everything, access 1 would only see fields with access 1 or higher, user group access 2 would not see 0 and 1 fields and would see 2 and higher, etc. Access levels can go to 5.

Assign SME user groups an access levels

  1. Go to Setup module > Company.
  2. Click User Groups.
  3. Click Search to locate the user group you want to apply an access level to.
  4. Select the Administrative Clearances tab.
  5. Locate the User Field Access Level field in the right column.
  6. Click Edit.
  7. Enter the access level (1-5)
  8. Click Save.


Assign an access level to the custom fields

  1. Go to Utilities module> Utilities.
  2. Click Custom Tabs and click Run It.
  3. Click Search and select the tab containing the fields you need to edit.
  4. Click Edit.
  5. Locate the Access Level column (circled below).

FieldAccessLevel.jpg


6. Enter the access level for the custom field.
7. Click Save.

*NOTE* Access levels are fixed, so you cannot allow a user group to see fields with access levels 1, 5, and 10 but no others.


Form Code

Form code is entered in the customer and then on the work order. (Image below)

CustomerFormCode.jpg

The tabs matching this form code and the tabs with no form code and will show on the work order.


You assign the form code to the custom tab (circled in image below). Form codes can be numbers or text.

AssignFormCode.jpg


For example you have a custom tab created for Home Depot customers and you assigned the Form Code of HD. You set the form code on the home depot billing company and every time you create an order for a customer with HD as billing, it sets that form code on the service order and only shows the custom tabs with the HD form code AND any custom tab with a blank form code.