By Lee Sykes
February 2008
In this tutorial we demonstrate how to use the User Defined Table (UDT) module. The UDT module allows you to create a custom table and store records within that table.
The table can include sorting of columns, paging, filtering by content and search. It also includes some powerful features such as the use of calculated columns, token replacement and layout templates through the use of XSL transformation files.
In this tutorial we walk you through creating a basic table through to advanced tables which implement calculated columns, templates, filters, paging and sorting.
The videos contain:
Video 1 - Installation, creating a basic table
- Introduction
- How to install the UDT module
- How to add the UDT module to a page
- How to configure the module
- How to create a table
- How to create a column
- Column data types: Text, Rich Text (HTML), Integer, Decimal, Date and Time, Date, Time, True / False, Email, Currency, URL, Image, Download, Calculated Column
- Required column data
- Visible column data
- Searchable column data
- How to create multiple columns
- The 4 default columns
Time Length: 10mins 2secs
Video 2 - Adding records, sorting, creating a second UDT table
- How to add a new record to the table
- How to sort the column data in a table
- How to add a second UDT module to the page
- Creating multiple columns with various data types
- How to create a drop down list data type selection
Time Length: 8min 1sec
Video 3 - Calculated columns, advanced options
- How to create a calculated column
- The advanced column options bug
- How to minus the data value from one column to another
- How to create a calculated column that calculates a % based on values from other columns
- How to add data to the table
Time Length: 7min 33secs
Video 4 - Permissions, users adding content
- Module Permissions
- How to enable registered users to create and edit their own records
- How to set ‘users only allowed to manipulate their own records’
- How to allow unauthenticated users to add records and force CAPTCHA control
- How to filter the code entered by users to prevent dangerous scripts from being entered into your table
- Logging in as a test user
- Adding a new record as a test user
- Editing the record as a test user
- How to edit the properties of the Rich Text (HTML) data column so that it uses a plain text box
Time Length: 7min 59secs
Video 5 - Advanced options for data types
- Manage User Defined Table
- The advanced column options for the data type Text: List of values, default value, validation rule, validation message, help text
- Regular Expressions
- How to cancel changes to a column
- The advanced column options for the data type Image: List of values, ALT tag, Hyperlink, Default value, Help Text
- How to re-order the columns
- Column Settings:
- Show open link in new browser window
- How to set the image width and height
Time Length: 8min 45secs
Video 6 - Display settings
- Display Settings (for current page)
- Rendering Method: Default grid table
- Sort Column
- Sort Direction
- Paging
- Grid Table Settings
- CSS Classes
- Filter Statement
- How to filter the data displayed
- Configuring separate display settings for the copied UDT module
- How to create a copy of a UDT module and filter the data displayed
Time Length: 8min 7secs
Video 7 - Search, predefined XSL transformation files (templates)
- Search Box
- Enabling searchable columns
- Simple Search
- Show no records until search
- Display Settings, Rendering Method: Predefined XSL Transformation
- Predefined XSL file: Advanced Table.XSL
- Visible items in List view
- Viewing list and details view
Time Length: 7min 36secs
Video 8 - Editing and auto generation of XSL transformation files
- BasicTable.XSL
- CardView.XSL
- OnlyOwnItems.XSL
- How to display just the records of the logged in user
- Users are only allowed to manipulate their own items
- Transpose.XSL
- Show XSL source code
- How to edit the predefined XSL transformation files
- User Defined XSL transformation files
- Generate New XSL transformation file
- List Type: Table, Division, Paragraph, Ordered List, Unordered List, Nothing
- Delimiter
- Available Fields and Context (Tokens)
- Adding fields into the XSL template
- Rebuild
Time Length: 9min 23secs
Video 9 - Further XSL transformation file options and tokens
- Options:
- Add sorting, paging, searchbox to the stylesheet
- Auto generate from HTML XSL stylesheet template
- Edit XSLT script
- Save the XSL stylesheet
- How to edit the current XSL stylesheet
- How to create a table list type with a detail view
- Viewing the table
- Token Replacement
- Using tokens in calculated columns
- Using tokens for the filter
- Hidden columns
Time Length: 8min 57secs
Total Time Length: 76min 23secs