Skip to main content

Cell Privacy & Locking

AnyDB Cells can be configured for various privacy and locking options to control visibility and editing permissions. This is useful for sensitive information or to prevent accidental changes.

Locking Cells​

When a cell is locked, it cannot be edited or modified by users without the appropriate permissions.

  • Locking is useful for:
  • Protecting sensitive data
  • Preventing accidental edits
  • Ensuring data integrity

To lock a cell, select the cell and use the Cell Details panel to set the lock option in the Privacy section.

AnyDB Cell Locking

Cells with locked status will show a lock icon in the cell.

AnyDB Locked Cell

caution

Locked cells are not editable, you will need to unlock it before making any changes.

Locked cells automatically get a gray background color to indicate that they are locked. To override this, you can set a custom background color in the cell styling options.

Hiding Cells​

AnyDB allows you to hide cells for various reasons, such as:

  • Keeping sensitive information private
  • Simplifying the view for users
  • Reducing clutter in forms
  • Hiding cells can be done in two ways:
    • Hidden Everywhere: Hide content from all viewers form or in normal views
    • Form-Specific Hidden Fields: Hide certain cells only in forms

Hidden Everywhere​

To hide a cell everywhere, select the cell and use the Cell Details panel to set the hide option in the Privacy section.

AnyDB Cell Hiding

The cell will be hidden in all views, including forms and normal views. A hidden cell will indicate its status with a hidden icon in the cell.

AnyDB Hidden Cell

Hide only in Forms​

Sometimes it is useful to hide a cell only in forms, while keeping it visible in normal views. This is useful for fields that are not relevant for data entry but are important for reporting or analysis. For example, you may want to hide a cell that contains a formula or a calculated value in forms, but keep it visible in normal views for reference.

Or you might want to hide a cell that is used for admininistrative purposes, so that only users submit the forms they cannot see the internal workings of the system.

To hide a cell only in forms, select the cell and use the Cell Details panel to set the hide option in the Privacy section.

AnyDB Cell Form Hiding

The cell will be hidden only in forms, but visible in normal views.