Articles on: Features

Database pro tips

💡 Hello and welcome to the advanced use of Fabrie, in this article we will focus on the advanced use of Fabrie tables.

Import & export





Import/upload tables



Fabrie database supports easy import of table data from a local Excel or CSV file, once imported a new table can be created.

Export/share tables



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.

Table structures and views



Change column field type



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.



Different fields will have corresponding styles, the following field types are currently supported.

Field TypeSupported ContentApplicable Scenarios
Textplain texttitle, short and long description
Single selectmulti-colour blocksingle label, option
Multiple selectmulti-colored blocksmultiple labels, options
Numbersplain numbersnumeric display
Dateyear month daycalendar options
AttachmentAttachment cardsExternal images, manuscript files
CheckboxCheckboxCheckmark
MemberCollaborator namesAdd collaborators and send notifications
URLClickable linksOutbound jumps
Formulafx functionsnumeric calculations, matching
Relationtable contentlinking records to another table
Rolluprecord cell contentcalculations, aggregates on cells
Created byusernamerecord row creation properties
Created timemonth, day, year, hour, minuterecord row creation properties
Last modified byUsernameRecord Row Editing Information
Last modified timemonth, day, year, hourrecord row edit information


Sorting and hiding columns



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.



List view



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.





Fabrie multidimensional tables also support gallery view, a special view style for tables containing visual elements, suitable for managing and presenting material lists more clearly, aiding in building visual scenarios such as mood boards, index albums, etc.



Linking records (Relation)



When you're handling a workflow, you gotta keep track of a ton of info. It's pretty damn important to know which project is connected to which client and which venue is being used for which event, ya know? Gotta stay on task and keep all those relationships straight, or things can get real messy, real quick!

In Fabrie, you can store all your important stuff in a single record and even link them together to capture the dynamic relationships between them.



Rollup fields



A rollup field calculates values, creates summaries, and applies formulas to specific cells based on records linked to another field in your table. To add a rollup field, click the plus sign located to the right of your existing fields. Then, select "Rollup" from the list of available field types.



Synced record: connecting whiteboard and database



Drag and drop whiteboard content to tables



Fabrie supports the interconnection of whiteboard and table data, drag and drop whiteboard objects to tables to create synced records; use this feature to structure whiteboard content in batches and keep even complex information organised!



Associate table data to the whiteboard



Drag and drop a table record onto the whiteboard to create a 'synced record', which is a whiteboard object with table data and whose data is updated in real time. Use the synced record for drawing annotation, feedback collection etc to make the data more traceable.



Editing synced record



Each synced record is marked with a serial number and can be quickly viewed by pressing the "Space" button or by clicking on the "Expand Record " in the edit bar. perfect for quickly add new data when viewing whiteboard plans or drawings!



Sharing a database table





Similar to linking objects in a whiteboard, each row or view in Fabrie's tables has a dedicated link, which supports one-click copying and sharing, making collaborative referencing easier!



Synced tables



Besides sharing table links, is there a more convenient and seamless way to share table data? The synced table feature can help you! This feature can break down the data barriers between files, allowing completed table data to be referenced in other documents, and even combined with the style expansion of chart-linked cards to complete the referencing and reuse of table data cards in whiteboards. It is very suitable for these scenarios:

- Within a team, referencing data and reusing styles that other members have already created, using synced record cards on a whiteboard, such as clothing fabric, color planning cards, product cards, etc.;
- In personal use scenarios, referencing historical data and styles in different documents, making it easy to synchronize once and everywhere, such as game planners needing to reuse various resource, material values, and designs during project planning.

Switch on/off referrencing



Any view of a table within a team can be referrenced and synced, but before referencing, the reference switch in the table being referenced needs to be turned on. The table reference switch directly determines:

- Whether the table can be referenced. If the reference is closed, the table cannot be referenced. Collaborators can request to referrence the table.



- Whether the table can be synced. If the reference is closed, the table reference relationship will be invalid, and the table data will stop automatically synchronizing.



⚠️ Note: The synced table feature currently only supports referencing files within the same team.

Create synced tables

Once a table has enabled referencing, collaborators (with table reading permissions) can quickly create a synced table in the following ways:

- Quick referencing while browsing the source table: Click "Reference" below the current view and click "Sync this view", then select the target project and document location to complete the reference;



- Quick referencing when creating a new table: In the "Expand Table" menu, click "Select referenced table" to select a table that has enabled reference permissions in the current team, and create a referenced table view in the current document.



Sync settings

After creating a synced table, the data in the table is linked to the source table, and the data also supports automatic synchronization:

- Sync settings: Click "Sync settings" in the synced table view to enable automatic synchronization.



- Sync status: After enabling automatic synchronization, you can quickly check the synchronization status of table data in the document.



Have a question about something not covered here? We're here to help!

👋🏼 Join and ask our community: https://discord.gg/YEdhUtk4Wa

👉🏼 or just email us at community@fabrie.com

Updated on: 07/08/2023

Was this article helpful?

Share your feedback

Cancel

Thank you!