This example demonstrates how to use dynamic cell access to control read and write access to time periods.
Before you create an access driver module, create a simple Products list, such as:
All products
- Soft drinks
- Beer
- Red wine
- Rose wine
- White wine
- Craft ale
- Coffee
- Tea
To control access to time periods:
- Select Modules in the model settings bar.
- Create an access driver module, and name it Access drivers - time.
- Position Time on columns.
- Insert two line items, Read and Write. These are the access drivers.
- Select Blueprint , then change the format of both line items to Boolean.
- Create a target module, and name it Products over time.
- Position Time on columns.
- Insert a line item, name it Data, and position it on Pages.
- Position the Products list on rows.
- Select Blueprint , then apply the Access drivers - time.Read and Access drivers - time.Write access drivers to the Read Access Driver and Write Access Driver columns, respectively.
- In Grid view, enter some numbers.
Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | |
Soft drinks | 10 | 80 | 110 | 80 | 10 | 90 |
Beer | 60 | 50 | 100 | 40 | 30 | 80 |
Red wine | 50 | 100 | 90 | 10 | 60 | 10 |
Rose wine | 50 | 20 | 50 | 40 | 50 | 80 |
White wine | 70 | 70 | 30 | 80 | 100 | 50 |
Craft ale | 80 | 50 | 10 | 60 | 30 | 60 |
Coffee | 90 | 30 | 40 | 70 | 0 | 70 |
Tea | 100 | 70 | 20 | 30 | 80 | 60 |
All products | 510 | 470 | 450 | 410 | 360 | 500 |
- For the purposes of this example, publish both modules to a single dashboard, and name it Product sales data.
- Use the access driver checkboxes to dynamically control access to product sales data in the target module, Products over time.
- For example, select both Read and Write for March 22 to enable write access to product sales in March 22. You can edit blue values.
- Select Read for Jan 22 and Feb 22 to enable read access to product sales in those months.
Product sales data is invisible for the other months because both Read and Write are deselected.