Overview of Light Weight List

Description

The Light Weight List makes it easy to define a SQL-backed table view and editing surface inside a UX component. A builder guides you through selecting the connection, table, and columns to display.

Discussion

While the existing Spreadsheet Control is well-suited for desktop-style, heavy-duty data entry, the newer Light Weight List offers a faster tool for working with modern web and mobile applications.

Creating a Light Weight List

To add a Light Weight List to a UX component, select Light Weight List from the Data Controls section of the UX Component toolbox. When you configure the control, a builder is opened where you can choose the connection string, table name, and columns to include.

After you have specified the connection string and table name, you can render the component and immediately start working with live SQL data.

Light Weight List entry in the UX data controls toolbox
Light Weight List in the UX toolbox

Builder options

The builder lets you:

• Specify how many columns to display or choose <Custom> to manually select columns.

• Configure column types, picklists, date pickers, and formatting options.

• Enable features such as Drag Fill, Drag Move, row state indicators, and parent–child relationships.

Light Weight List builder showing connection, table, and column options
Light Weight List builder
Light Weight List rendered with sample data
Rendering the Light Weight List

Introducing the Light Weight List

This video introduces the Light Weight List.

See Also