.png)
<aside> 💡 Hello and welcome to the advanced use of Fabrie, in this article we will focus on the advanced use of Fabrie tables.
</aside>
Fabrie database supports easy import of table data from a local Excel or CSV file, once imported a new table can be created.
Fabrie database can also be downloaded as Excel or CSV files to accommodate the data transfer needs of everyday collaboration, However, we recommend using one-click sharing for better online collaboration experience.
Fabrie tables support a rich field structure for diverse data dimensional presentation, allowing you to select the appropriate field type for specific content and style.
.gif)
Different fields will have corresponding styles, the following field types are currently supported.
| Field Type | Supported Content | Applicable Scenarios |
|---|---|---|
| Text | plain text | title, short and long description |
| Single select | multi-colour block | single label, option |
| Multiple select | multi-colored blocks | multiple labels, options |
| Numbers | plain numbers | numeric display |
| Date | year month day | calendar options |
| Attachment | Attachment cards | External images, manuscript files |
| Checkbox | Checkbox | Checkmark |
| Member | Collaborator names | Add collaborators and send notifications |
| URL | Clickable links | Outbound jumps |
| Formula | fx functions | numeric calculations, matching |
| Relation | table content | linking records to another table |
| Rollup | record cell content | calculations, aggregates on cells |
| Created by | username | record row creation properties |
| Created time | month, day, year, hour, minute | record row creation properties |
| Last modified by | Username | Record Row Editing Information |
| Last modified time | month, day, year, hour | record row edit information |
After updating the content of each field, you can drag and drop the content of each row or column to adjust the display order, and choose to hide the content of columns that do not need to be displayed, thus making the entire table content clearer.
Fabrie database supports different grouping of tables by field content, with grouping rules based on filtering and sorting of single or multiple fields for output presentation. Each grouping can be saved as a different view, thus making the whole table more organised and intuitive.