When working with large data sets, Vizlib Writeback Table offers a Form View to help keep your table scalable and readable.
Enabling the Form View allows you to:
- alter the table's layout by changing the row height >to make the table more compact
- customize the format and layout of the table
- control which columns can be edited
- hide columns to make reviewing and editing the table data easier
- view row details in a form that makes reviewing and editing the table data easier.
And you can still drill down into a row to display all the columns and edit data if needed.
TABLE OF CONTENTS
- Setting up the Form View
- Using the Form View Wizard
- Hide All Columns in Table
Setting up the Form View
- Click Edit sheet
- Select an object to view the property panel.
- Click to open the Column Settings menu, and use the slider to enable the Form View (Figure 1).
Figure 1: Enable Form View
Using the Form View Wizard
- Click on Form View Wizard to open the wizard screen for editing (Figure 3). Columns in the table are listed on the right, other available Columns are listed on the left.
- Select an option from the Add Column dropdown if you want to add any new columns.
- You can drag existing columns from the Columns list on the right and drop them into the editor.
- Change the column order by using drag and drop. You can select multiple items by clicking and holding down the CTRL button.
Figure 2: Form View Wizard
Note on Adding Columns: If you need to add a column without using the wizard, you can use the Add Column button in the Columns section of the property panel.
The wizard has several buttons to help you add items and organize them in the form.
- Add Column- select a Data Type from the dropdown and enter a column name using the text box. There is also a dropdown to choose the column text Size, text Color, enable a Break after the column, use Show to display the column only if a condition is met, and add a Tooltip.
- Add Page - click to add a page to the form. Once you've added the page, you can add items using the controls or drag and drop. You can disable the Next navigation button in the form if validation fails.
- Add Group - click to add a group. You can add items to the group using drag and drop, change the text Color, use the Show Group If function to display the group only if a condition is met, and add a Tooltip.
- Add Caption - click to add a caption. You can enter caption text in the text area, choose a Header or Paragraph format, apply Bold, Italic or Underline formatting, set the text Color, and use the Show Text If function to display the caption only if a condition is met.
- Add Divider - click to add a divider. You can move the divider using drag and drop, set the divider Color, and use the Show Divider If function to display the group only if a condition is met.
Note on Delete: If you need to remove an item, let the cursor hover on it, then click the delete icon.
- Click Save when you've finished making changes. You should see the edit icon displayed beside each row.
- Click on the edit icon to drill down on a row, view each column and edit any values (Figure 4). You can see that the form has two pages - Sales Period and Sales Breakdown.
Figure 3: Writeback Table Edit
Hide All Columns in Table
If you click Hide all columns in the table, the table will display as empty. You can display individual columns again by editing the Show column if setting in the property panel (Figure 4).
Figure 4: Show Column If
To hide a column, select the columns you want to hide, and set the Show column if to 0 (zero) to hide them.
Hiding specific columns using a value filter
An example of the text you'd need to enter would be
Which would mean the column is only displayed if the value Other is selected in the Type column.
Hiding groups inside the Form View Table
The Show column if property determines whether or not a column is visible inside a table. To manage column visibility in the Form View, a column has to be placed inside a group and the Show group if property is applied.
- Open the wizard and add a Group in the form (Figure 6).
- Select the fields to add to the group. We're adding Year and YearMonth in this example.
- Enter a name for the group in the text box, then click on Show Group If.
- When the expression editor opens, add the code which identifies the fields to be hidden. This example uses an expression that means Year and YearMonth will only be displayed for columns with the Product Group Desc value Beer. The column syntax would read:
Column('Product Group Desc')='Beer'
- Click Apply to save the changes. You should see the expression symbol highlighted in color to show a condition has been added. Click Done Editing to enter analysis mode.
Note: There are more examples of working with expressions using column syntax on the page Referencing Column/Field values in Expressions.
Figure 5: Add Group
- Select a row where Beer is listed in Product Group Desc values, then select Edit for a row. You should see the Year and YearMonth fields in the edit panel (Figure 7).
- Open a row using Edit with Wine as a Product Group Desc value (i.e. not Beer). There should be no Year or YearMonth fields displayed.
Figure 6: Display Hidden Fields