Vizlib Home Try Vizlib
Welcome
Login

Vizlib Writeback Table Guides - Form View

If you're working with large sets of data, Vizlib Writeback Table offers a Form View to help keep your table scalable and readable. You can also choose to alter the layout of the table by changing the height of a row, to make the table more compact. 


TABLE OF CONTENTS


Form View Setting


If you enable the Form view setting, you'll be able to customize the format and layout of the table, hide columns and control which columns can be edited. However, with form view enabled, you'll also be able to drill down into a row to display all columns and edit data if you need to. 


Figure 1: Writeback Table Form View 


You can find and manage Form View in the Column Settings menu in the property panel (Figure 2).


Figure 2: Form View


Back to Contents


Form View Wizard


  • Click on Form View Wizard to open the wizard screen (Figure 3). Columns in the table will be 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 and drop it 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 3: 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 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 choose to 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, and also change the text Color, use the Show Group If function to display the group only if a condition is met and add Tooltip.   
  • Add Caption - click to add a caption. You can enter caption text in the text area, and choose a Header or Paragraph format, apply Bold, Italic or Underline formatting, set the text Color, 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, and also 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 column values (Figure 4). You can see that the form has two pages - Sales Period and Sales Breakdown.  


Figure 4: Writeback Table Edit


Back to Contents 


Hide All Columns in Table


If you click Hide all columns in 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 5). 


Figure 5: Show Column If


An example of the text you'd need to enter would be 

Column('Type')='Other' 


which would mean the column is only displayed if the value Other is selected in the Type column. 


Back to Contents


Hiding Fields 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 Form View, a column has to be placed inside a group, and the Show group if property 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


Figure 6: Add Group


  • When the expression editor opens, add the code which will identify the fields to be hidden. This example uses an expression which means Year and YearMonth will only be displayed for columns which have the Product Group Desc value Beer. The column syntax would read
Column('Product Group Desc')='Beer'

Note: You can find other examples on working with expressions using column syntax here. 

  • 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. 
  • Select a row where Beer is listed 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 7: Display Hidden Fields


Back to Contents






K
Kenneth is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.