Sheets are one of the most important concepts in Ragic. "A sheet" represents a designed framework for storing multiple records of the same type. So, how do you create a sheet?
Below is an overview of all the ways to create sheets and their applications:
The most straightforward way to create a sheet when setting up a database is to create a new one. You can manually create a Ragic sheet from scratch, install pre-designed templates, apply quick templates, or import an existing spreadsheet to generate sheets.
For detailed instructions, please refer to this documentation.
If you want to create a sheet with the same or a similar design as an existing one, you can duplicate the sheet design and then adjust it. This way saves time compared to designing a sheet from scratch.
You can create multiple version sheets that share the same design and records, and then adjust the fields and Access Rights based on the needs of different user groups. This allows different groups of users to see different versions of the sheet while sharing the same records.
Subtables are great tools for managing one-to-many relationships in data. However, storing all data in subtables may not always be convenient. For example, when analyzing sales details from the past month with reports or exporting purchase records across datasets. In such cases, you can create a new sheet from a Subtable, which will automatically aggregate all the Subtable data from the parent sheet."
If you want to duplicate sheets across different databases, you can use the Cross Account Sheet Copier to quickly duplicate a sheet from Database A to Database B.
Note: This method only copies the sheet design, not the sheet record.