Understanding UDT Custom Columns

When you are adding a User Defined Table (UDT) you can define your own custom columns for the UDT.

UDTs are RAMM database tables which you have defined yourself so that you can use RAMM to manage your asset and condition data which are not in the standard RAMM Set.

Custom Columns Are Highly Configurable

You can create Custom Columns of the standard RAMM column types such as text, date, Boolean and so on. You can create Calculated Custom Columns which default based on selection criteria you have defined. You can also associate attributes with values in a Custom Column.

An Overview Of Adding UDTs
This introductory video gives a brief overview of adding a UDT. You should watch this so that you understand where Custom Columns fit into the process of adding a UDT.
An Overview Of Adding UDTs (3:52)
UDT Custom Columns
This video shows the basics of creating a Custom Column when adding a UDT. You should watch this and then the related videos to take full advantage of their potential.
UDT Custom Columns (4:29)
Setting Up Dropdowns For Multiple UDTs
When a number of UDTs require the same values from a drop-down list, rather than create a new one for each UDT, you should create one drop-down list and reuse it.
Setting Up Dropdowns For Multiple UDTs (5:26)
Lookup UDT Attributes
Not only can you associate attributes with Custom Column values, you can make those values default. Watch this video to find out how you can do this.
Lookup UDT Attributes (4:35)
Calculated Custom Columns
You use Calculated Custom Columns to create UDT Custom Columns for which values will default based on other values you have selected.
Calculated Custom Columns (4:33)
Understanding Control Layout
When you are adding a Custom Column you can use the Control Layout screen to configure short field labels for Pocket RAMM as well as labels for Grid and Detail screens.
Understanding Control Layout (2:18)
Make Model Fields
Sometimes want the values in one field, such as car Model (Commodore), to be dependent on the values in another field such as the car Make field (Holden).
Make Model Fields (3:15)