Vizlib Home Try Vizlib
Welcome
Login

Vizlib Writeback Table Guides - using 'Editable if' in Writeback


Editable if - row level control


TABLE OF CONTENTS



The ‘Editable if’ feature allows you to control, at the row level, when specific columns should be editable.

When designing your tables, it may be tempting to apply this feature to all your column settings.


However, it’s important to remember when using this feature, that like all good things, this feature should be used in moderation.


Otherwise, it may negatively affect performance as it checks and applies permissions to all the rows and columns that have this constraint applied.


Advanced Mode


To use view the option to apply the Editable if feature, slide the Advance Mode toggle.


Slide the Advanced Mode toggle to the right to turn it on, so you can view, select, and enter the expression to control at the row level, which columns are editable. 


Figure 1: Shows the Country column is editable if Advanced mode is turned on.

Figure 1: Shows the Country column is editable if Advanced mode is turned on.


Viewing the writeback table


Figure 2: Shows the Country column is editable.

Figure 2: Viewing the writeback table


Adding an 'Editable if' column manually


To add the ‘Editable if’ column manually, in your worksheet:

  1. Click Edit Sheet (top right)
  2. Click Column
  3. Select the column name from the displayed list
  4. Click Data
  5. Scroll down to view ‘Editable if’

If you slide the toggle to the right and it displays as ‘Green’ - applies the ‘Editable if’ at the table level

If you slide the toggle to the left and it displays as ‘Red’ - it applies the ‘Editable if’ at the row level.


In the field, your expression must be set to either: 1 - for editable columns, or 0 - no editing is possible. In the example above, the tooltip shows that the toggle was set to 0, and is now 1 to make the column editable.

It’s good to check if you have a longer expression to confirm that it evaluates to 1 or 0.



Did you find it helpful? Yes No

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