The older versions of SMSTurbo V10 utilized the User Defined Fields section
off of Utilities to setup User defined fields for tickets and almost all of the other SMSTurbo maintenance screens. This function of creating
UDFs has been moved to a new tool called SMSDesign. This includes the ability to create both ticket UDFs and Other UDFs
and to Export or import those.
Navigate to Utilities, Configuration, SMSDesign. This will launch this window:
Right click on any object in the left hand tree to reveal the available options for creating UDFs or UDTs.
Once created UDTs and UDFs and SDOs may all have its datasource code edited via the Datasource Editor.
Datasource window buttons
Print icon -print your entered data source code to a Windows ® mapped printer.
Find Text magnifying tool -Use this tool to locate any text in the Datasource programming.
Comment Uncomment selected code-Select a programming line in your code and hit this button to comment it out in the program
from being used.
Below -Code as it appears after being commented out.
Creating User Defined Tables
Right click on the folder called "Database Objects", to create new Tables (User Defined Tables) in your SMS database.
Create Properties for the new UDT
Enter the Name of the table you are creating.
You must also enter:
KeyColumn -name the keycolumn will be called related to the table used.
KeyColumnLength -The length of the field supporting these values. We set this to 15 as this is the maximum length of the characters entered there.
These three fields have to be defined to create a new UDT.
Select the blue disk "save" icon on the "properties for new UDT" window at the top.
A message will appear asking you to add the UDT to the maintenance menu and what its default authority is.
After selecting "Yes" you will see...
These new tables will show up as folders under this tree just as the currently existing tables do, such as BucketLoaders shown below.
Creating User Defined Fields
Right clicking on any table folder will allow you to create a UDF on that particular maintenance screen.
Right click on the folder called "Ticket" on the tree on the left.
Select "New User Defined Field"
You will see the default values populate on the right for the UDF you have started.
In the above example we named our UDF "Red".
Left click on the right side of any value above in the "Properties for New UDF" window to enter a value.
We create a simple list to display when this UDF is used.
After selecting the blue disk icon for saving it again and reopening Design we see the UDF as part of the ticket table
and there for placed on the main ticket page.
Certain fields must be populated to create and save the UDF.
Field Number -Fields 1 - 999 will be visible on the ticket screen. Fields entered with the number 1000 to 1099 will be put onto a tab called "Misc". Field numbers between 2000 and 2099 will create a second tab and so forth. The name of the tabs may be changed at Utilities, Configuration, SMSTurbo, General, General2 tab, UDF Authorization Levels (Ticketing). So in general each tab could have 99 UDFs on it.
Name -The name of that UDF for programming purposes. alpha numeric, no spaces, no special characters allowed.
Enter the rest of the UDF values. These include:
Data Type of the UDF -Pre populated with type of data, Alpha Numeric, Numeric Only, Date, Time, Property
DataSource -Formulas or other scripts assigned to the UDF under "Datasource for (UDF)" entered on the right.
DataSource Type -The system label of the type of data source being used on that Datasource.
Decimal -This is the number of places after the decimal.
Field Label -The name of the UDF as it will appear on the SMSTurbo screen.
Hide -Set to false, information is not displayed.
Key Template -Select NONE for no key template, CSharp, or Other.
Length -The length of that field defined in how many characters it can hold.
Required -When set to true this becomes a mandatory field.
AlwaysAllowEdit (not pictured) -Allows the ticket UDF to be edited at any time in its life. New tickets will use this value going forward. Old tickets will not be effected unless they are still open and brought up with the UDF changes and then applied.
Read Only -When checked this value is supplied by the software or formula
Width -The number of characters on the screen.
Protected -The UDF cannot be changed on a completed ticket.
UnmanConfirm -Confirms on the screen the value entered.
UnmanField -Use this UDF in Unattended operation.
UnmanStop -Unattended will stop for this field even if a default has been established.
Enter "New DataSource" formulas on the right if applicable to the use in your UDF.
Once the UDF "save" button is selected the formula created on the right will appear next to "DataSource"
whether the DataSource is a formula or other type, it will be noted under Datasource Type.
In the above example the ticket UDF called Blue was created on the ticket screen..
After saving the UDF appears at the bottom of Ticket tree on the left. Notice a Datasource formula was entered and saved to the UDF.
It appears under DataSource on the properties screen for Blue along with its "Data Source Type", which is a formula.
This UDF should allow the user to select one of three choices, Grey, Blue, or yellow.
Right click on the Datasource editor screen to produce the "Code Snippets and Samples" menu to offer selections
for already created coding shells which can be used here. Submenus with choices will display when a Snippet value is selected.
Click the snip to add it at the cursor.
Screen Designer Objects
Once a User Defined Table is created Screen Design Objects may be added to that table. Simply right click on the table and
select New Screen Design Object.
Edit the screens to create or change these SDOs.
Exporting and Importing UDFs
Right click on any existing UDF.
Select "Export UDFs".
The Export UDFs window will appear all the available UDFs to export.
Left click to highlight a UDF you wish to export or all or none of them.
Select the button for "Export Selected"
The below message will confirm the export and the location of the export file.
Perform the reverse process to Import a UDF.
Browse to the location of the export file.
Import the UDFs.