Explaining set-depth and relation between quantities

How to Record a Set

Creating a database of sets

How to Create an Empty Database of Sets

Storing articles from the Minutes to a database of sets

Use Databases>Record set

How to Record a Set

What is a flat set?

A flat set contains no structure. It creates no group in the minutes view.

How to Record a Set

Nesting sets

A set can belong to another set.

Nested Sets

Returning “calculated” fields from a set

In Sheet3, use Define output data; this creates a global variable QDV_Output.

GUI Widgets

Using controls in sets

Put them in the Sheet3.

GUI Widgets

Adding a User Interface to sets

Put controls in the Sheet3.

How to Build a Form

Displaying/Hiding columns or rows

Use SHOWROW/SHOWCOLUMN.

ibidem

Setting visible areas

Use View>Show>Set visible area.

ibidem

Storing input values in the estimate

Import set input values.

How to Parameterize the Insertion into the Minutes

Storing the whole logic in the estimate

Import set workbook.

ibidem

Passing parameters when using nested sets

How to Leverage the Calculation Power in Nested Sets

Editing sets under Excel™

Edit in Excel, then import through drag and drop.

How to Create a Set >3b

Duplicating sets

Use the menu Clone Selected Set.

How to Manage the Sets

Contextual sets using global variables

See Multi-languages sample>Sheet of Sales>bottom.

Contextual Databases