Database Design Documentation
Database Design Documentation
As fields and Subtables multiply in a sheet, you might need to scroll up and down to check information constantly. For instance, a "Customers" sheet may include Subtables such as contacts, sales opportunities, and contracts, resulting in longer loading times.
The Sheet Sections feature allows you to group rows into different sections and view each section by selecting different tabs at the same row level without scrolling.
The advantages of Sheet Sections include:
1. Clear Visualization: Switching tabs and horizontally viewing different sections eliminates the need to scroll up and down.
2. Streamlined Organization: Sheets often consist of different functional sections, such as basic information, contact details, and related records. You can group related fields and Subtables in the same section for better organization.
3. Enhanced Speed: It's generally not recommended to have more than 100 records in a single Subtable as it can slow down loading speed. If you must have lengthy Subtables, using sections can "hide" them to increase page load speed.
First, select the rows you would like to group as a section. You can select both independent fields and Subtables.
Right-click on selected rows to Create Section.
Click + next to section tabs to add a new section.
Choose which row the new section will end on. Ensure there are no empty rows in between, and a Subtable cannot be divided into 2 sections.
Click on a tab to rename it.
Right-click on the tab name and select Edit Style to adjust the style of the tab, such as the font size, font type, color, and more.
Click x to cancel the section.
