Database Design Documentation
Database Design Documentation
When accessing your Ragic database, you'll see a list of all available sheets under each tab that you have access rights to on the user Homepage. You can either scroll down to find the sheet that you want to access or navigate from the Tab at the top.
As tabs grow, locating the sheets you need might become a problem. This is when the Tab Menu can help. You can categorize tabs into different tab groups (tab menus) such as "ERP", "HR", or "Marketing". Each tab menu will have its homepage.
You can add and edit Tab Menus through Tab Manager, accessible in two ways:
1. Click on the drop-down menu at the top-left of the page and select Default Tab Menu, which contains all uncategorized tabs. Then, choose Create new tab menu set next to the "+" sign.
2. Right-click on any tab at the top and select Tab Manager.
To add a new tab menu, click on Create new tab menu and name it.
Select the tabs you would like to add to the new tab menu and click "Save".
You can also rename or delete the selected tab menu or sort tab menus by clicking the "gear icon".
Access the new tab menu by selecting it from the drop-down menu at the top-left of the page. Only the tabs you added will be displayed on this page. You can also add different logos and banners to each tab menu.
Note:
1. Tabs added to other tab menus will no longer be displayed in the Default Tab Menu.
2. Reports will move along with their source sheets.
If you have a "Sales Order Management Tab" and there are linking relationships between sheets within it, and you want to duplicate an identical set of designs (including linking relationships but excluding data), you can use the Duplicate Tab instead of copying individual sheet and manually adjusting the link.
Click on the inverted triangle icon next to the tab name or right-click, and choose Duplicate Tab.
Select which sheets you want to copy.
After submitted, all selected sheets will be copied together! The linking relationships between sheets will be connected to the newly copied set of sheets, not the source ones.
This feature is for duplicating the entire tab and its sheet designs. Unlike Multiple Versions, the data won't be synced after duplication.
When your database has numerous tab menu sets and you want to simplify the process of finding sheets for users upon login, you can direct them to commonly used tab menu sets. For instance, users in the "Sales" group can be directed to the "ERP" tab menu set, while users in the "HR" group can be directed to the "HR" tab menu set.
First, open the Tab Manager, select the tab menu set you want to configure, and click the "gear icon" next to it. Choose Set as user group-specific default tab menu set.
In the window, specify which Groups should have this tab menu set as their default, and remember to Save. Once done, users in that group will be directed to this tab menu set upon login.
Note: If users belong to multiple groups, each configured with a different default tab menu set, their default will be determined by the order of these sets. If users can't access any sheets or tabs in a set, they will be directed to the next one. If none meet the criteria, they will be directed to the database's Default Tab Menu.
Select the sheet you would like to view and right-click to access the Sheet Information.
In the window, you can see the following information.
You can hide a sheet from users who do not have SYSAdmin access rights in Sheet Information. This feature helps to maintain a clear interface by concealing the sheet.
Users can still access this sheet via its URL. If this sheet is a linked sheet within the Link & Load feature, it will remain accessible in those configurations.
If you want to change sheet order, you can hover on any tab or sheet and right-click to open Sheet Manager.
Select a sheet and click the horizontal arrows to move it to other tabs, or click the vertical arrows to change its order within the same tab.
Remember to save before leaving.
To delete the sheet or tab, hover over it and an "arrow" icon will appear on the right. Click on the arrow, then select "Delete" to remove it. Alternatively, right-click on the sheet or tab you want to delete, then select "Delete".
If the system stops you from deleting a sheet, please refer to this document.
If you accidentally deleted a tab or sheet and would like to recover it, you can check the Recycle Bin.
