Bika
GuideDatabase

Mirror

Mirror

Mirror is a shortcut to a database view that you can quickly access in your working directory.

As the usage scenarios increase, do you encounter situations where there are too many views and you often can't find the data you are focusing on? Mirror can create a shortcut for a view of a database and put it in a specified folder.

This article uses the scenario of CRM (Customer relationship management system) to explain how to use view mirrors to allow salespeople to quickly access and edit "their own clients".

Create View Mirror

Scenario: As a sales executive, I want the salespeople in my group to quickly find "their own clients", so that they can view and edit clients information on a daily basis.

We first create a "My clients" view and set the filter to "Sales Lead" equal to "Me (currently visitor) ". At this time, the current view only displays clients information related to the visitor.

Set filter for My clients view My clients view result My clients view in CRM database

We will click the "More" menu right the folder, select "Create", and select "New mirror". There will be 3 types of new mirror:

  • Select an existing view: If your database already has a view that needs to be mirrored, this type will create a mirror resource for that view directly in the resource directory.
  • Independent view: If your database does not yet have the required view, this type can use a separate view configuration to create a mirror, and the original database will not add a new view
  • Select an existing resources: If you only need to mirror all the data of a database without any view configuration, choose this type

The following example is "Select an existing view". After creating the mirror, select the "My clients" view in the database, which will generate a mirror and send it to the folder. This way, all salespeople can access the mirror to quickly view and edit the datas in "My clients" view.

Create mirror for My clients view Mirror created in resource directory Select My clients view for mirror Mirror resource in folder

View Mirror

Scenario: Salesperson "Bob" visits the mirror resource "My clients" and wants to view and edit his own related clients.

When the salesperson "Bob" accesses the mirror, according to the filter set by the original view, he can only see clients whose "sales" is equal to "Bob". He can edit or add clients he is responsible for, and the customer's data will be synced to the original database.

All the data of the mirror will be synchronized with the corresponding view data of the original database

This means that changes made by the sales executive in the "My clients" view of the original "CRM data database" are also synced to "My clients " mirror.

Mirror data sync with original view

In the mirror, all members can only edit records and cannot operate on the View Toolbar and field configuration. This means that filtering, sorting, grouping, and adding, deleting, or transforming fields cannot be performed in the mirror.

Therefore, the sales executive is responsible for setting up the mirror structure, and the salesperson is only responsible for entering and managing his own clients.

Set permissions for view mirrors

Scenario: As a sales executive, I only want the salespeople in my group to update their own clients, but I can't view other member's clients.

We continue with the above scenario. When we mirror the view "My clients", we first set the permission for the mirror to be "Can edit" by Sales Group.

Then set the original database "CRM database" can only be edited by me (the sales executive), and other members have no access permission.

The salesperson can only access the mirror of "My clients", and can only view and edit their own clients in the mirror, and the salesperson does not have permission to the "CRM database", so he cannot access other member's clients.

Set mirror permissions for Sales Group Set original database permissions

Mirror permission classification role

On the working directory, you can set different permissions for the mirror, which are divided into the following four permissions:

  • Can manage: Members can edit or delete mirror resource and set permissions on mirror resource. However, it is not possible to use the view configuration (filtering group sorting) of the "View Toolbar", add or delete fields, and modify field configurations.
  • Can edit: Members can add, modify, and delete row data (records) in the mirror, and they cannot use the "View Toolbar" and operate on fields.
  • Update only: Members can only edit row data (records) already in the mirror, cannot add or delete records, and cannot use the "View Toolbar" and operate on fields.
  • Can view: Members can only view the content of the mirror, not edit it.

The permissions of the mirror are calculated independently of the permissions of the original database, and members can view and edit the mirror even if they do not have the permissions of the original database.

Mirror permission classification

FAQ

Why can't I add a new field in the mirror?

Mirroring is a shortcut to the vig view. To ensure the security and validity of the source data, operations such as adding fields, deleting fields, and modifying field configurations are not supported for the time being.

What is the relationship between a mirror and a view of the original database?

Mirroring is a shortcut to the view of the original database, so it has the following characteristics:

  • A single view can create multiple mirrors
  • The data of the mirror and the view of the original database are synchronized with each other
  • Deleting the view of the original database will make all mirrors inaccessible

How can we enable members to view only their own relevant data, rather than all the data?

After the view in the original database filters the data, generates a mirror, sets access permissions for the corresponding member, and then hides the original database from the member.

Recommend AI Automation Templates
X/Twitter Manager
An AI-powered Twitter Assistant that helps content creators draft viral tweets with auto-polish, generate tweet ideas, and schedule posts using one-click automation. Grow your engagement and effortlessly boost your Twitter follower growth.
ADDIE Instructional Design Model
ADDIE Instructional Design Model
Use the ADDIE Instructional Design Model as a practical instructional design template to manage your entire course development process. Plan and track e‑learning content development, instructor‑led training design, and training materials development for professional skills courses and employee training programs. This template helps instructional designers, training developers, and education project managers organize tasks, align learning objectives, and streamline course creation for any organization.
Bank Statement Attachment to Database
Bank Statement Attachment to Database
Manually upload a PDF attachment of the bank statement, use image recognition technology to extract the total expenditure and stock data, and generate data records into the Bika database

Coming soon

Google Analyst
Step-by-step guide to connect your Google Analytics 4 (GA4) property to the Google Analyst agent. Covers creating a Google Cloud service account, enabling the Analytics Data API, granting GA4 Viewer access, and configuring the agent with supported metrics like sessions, users, bounce rate, conversions, and more. Perfect for quickly setting up GA4 data reporting in Bika.ai
Automated Currency Data Retrieval (JavaScript)
Automated Currency Data Retrieval (JavaScript)
The Automated Currency Data Retrieval (JavaScript) template runs daily jobs to fetch exchange rates and write them into a table, giving you clean, structured historical exchange rate data without manual copy‑paste. Use it for financial data automation that feeds dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and analysts always have up‑to‑date FX data. Over time, the template becomes a lightweight risk management tool by helping you monitor currency movements, spot trends, and support better investment and hedging decisions.
AI Programmer
Transform your ideas into ready-to-publish HTML pages with AI Programmer by Bika.ai. Create stylish, professional web pages instantly — no coding required.