Build a Table

engini’s tables serve as the central repository for consolidating all pertinent information and facilitating essential work processes while the table structure is adaptable to accommodate the specific requirements of each team or organization, it consists of fundamental components, which will be elaborated upon in the documentation create your table you can add one or more tables to the same workbook by clicking on ‘new table’ and changing the name of the table from ‘new table1’ a pop up window will show up, fill the fields folder choose an existing folder or create a new one to organize your tables by default, a new folder is empty table name choose a significant name to your table create button click create if you are ready to create the table create columns to add column, simply click on the + sign in the far right of the table’s column section choose the column type you want from the dropdown menu you will be able to view various types of columns later in the guide name the column fill the rows with current data in order to do actions in a specific column, open an existing column menu in the right side of the column by clicking on the three dots duplicate you can add the same column directly to the right side click on ‘duplicate’ delete you can delete a column while clicking on ‘delete’ filter/sort you can filter / sort the column you will be able to learn how to sort and filter later in the guide you can expand the column by clicking on the right side the width of the column will be up to 1000px change the location of the column change it location by dragging the column to its new location sort & filter take your table customization up a notch with a filter this feature lets you show off specific info in your table, tailored to your display needs click on ‘filter/sort’ choose your filter criteria, in the example choose one of the names apply your choice you can clear the filter you can sort a field in a table by selecting the field and choosing whether the order will be descending or ascending first, click on ‘filter/sort,’ then choose your sort criteria and finally, click ‘apply’ choose your sort criteria (descending / ascending) apply your choice you can clear the sort to create a quick filter, click on the “filter” icon on the top left side of the table click on “add new filter” choose the field from the drop down choose the condition from the drop down enter the value to compare it to click on the “save to view” button on the right side of the popup to create a quick sorting, click on the “sort” icon on the top left side of the table click on “add new sort ” select the field you want to sort from the drop down choose the sorting click on the “save to view” button on the right side of the popup comments you can add and edit comments on any row in your table to provide additional information, share feedback, or collaborate with teammates click on the comment icon a new window will pop up on the right side, click on “write a comment” write your comment and use the toolbar to bold, italicize, underline, or align your text in order to make your message clear and easy to follow before hitting “send” choose to sent / cancel the comment once you send the comment, the row will show that it has one comment you or your colleagues can then reply to it by clicking the “replay” button, and the number of comments will increase accordingly once you cancel the comment, it won’t appear and the comment count will remain unchanged when you click the three dots on the right, a window opens with three options reply when you click on ‘reply’, a text box opens for you to write a response after you click ‘reply’, you have the option to respond directly to the person’s comment (to click ‘reply …’) or simply add another comment delete when you click ‘delete’, it removes the comment you wrote edit when you click ‘edit’, you can modify the content of the comment after it has been sent views & hide enhance your data presentation by altering the view of the original table or creating an additional view we let you filter various column types, like status, labels, text, people, numbers, and more this approach gives you a new outlook on your data, leading to improved data readability and a better understanding of the most important info you need right now if you choose to filter one or more columns within the original table click on ‘hide’ on the top of the table choose the columns you want to filter by removing the selected option in the check box click on ‘save to view’ if you choose to filter one or more columns within a new view of table click on views on the top of the table click on ‘add new view’ name the new view repeat the steps from stage 1 note ensure you’re in the correct view by clicking ‘views’ to access all your views types of columns status the status column is a key factor in planning, organizing and tracking all of your team’s work the status allows you to easily see the status of the tasks you can edit the status labels according to your workflow to do this click on one of the status columns cells click the edit labels button at the bottom to modify the labels alter the displayed text to your preference you can add more labels write a new status in ‘new label’ click on ‘+’ to select a color, click on the desired option click on ‘new label’ click on ‘apply’ note the gray label is the default label that appears when an item is created we recommend leaving the gray status label blank because setting a status to the gray label can cause confusion for users tip use automation to streamline your workflow! you can effortlessly set up automations to update your team when a status changes, for example you can learn more in this guide labels serve to categorize and organize items text this column allows you to add any type of text such as names, short comments, phone number, address and more date the date column allows you to set dates for your tasks, such as dates the items were created or due dates the default option is date only but you can choose to display the date with or without the time choose the date column to store the calendar date you have 2 options choose date and time to store both the calendar date and the exact time if you clicked it by mistake, don’t worry! you’ll still have the option to use only the date or only the time , depending on what you need choose time only to store the exact time if you clicked it by mistake,no problem! just click the three dots and switch to date only or date and time , depending on what you need people the people column allows you to assign tasks to one or multiple users this column type provides a visual representation of who is responsible for which tasks and gives ownership of tasks to your team number you can use this column for anything related to a number counter, budget, quantity of item, number of hours you spent on a task and more checkbox represents a binary choice according to conditions and settings it can be checked or unchecked (empty) connect table the connect tables column allows you to easily link one or more tables to the current one that you are on 1\ choose the table you want to connect to by searching for it in the search box, or select it from the list 2\ select the field you want to display from the connected table you chose you can either search for it using the search box or click directly on the field 3\ allow linking to multiple records select this if you want to link multiple values from the selected field in your table record 4\ create bidirectional field create a two way connection between items in both tables any item linked from one table will automatically appear as a linked item in the other table as well this helps ensure that only relevant or identifying information is shown when viewing linked items choose which column from the current table will be displayed in the connected table add field click on the add field button to confirm note connected table fields display relationships between records when https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview hvdmr16kyjggwcsq2arm1#t4 zr or https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview hvdmr16kyjggwcsq2arm1#kaxv4 records in workflows, always use the record id connected table fields cannot be used to identify the record filters filters allow you to control which records from the connected table will be displayed in the current table after linking the table, you can set filter conditions to display only the records that meet those criteria 1\ click “add field” to open the filter screen if you don’t need to apply any filters, just click ok to proceed 2\ add conditions to control which records from the field you chose will be available click on the left field and choose the field you want to filter by from the table you connected to select the condition you want the record to meet from the conditions list click on the rightest field and the tooltip will pop up showing the options you can choose you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview o3kkbgi5xnqf yvnuqkcv#ca 5p and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) created log adds the creator of the record and the date and time it was created updated log here, you can see who updated the record and the date and time it was updated link the link column allows you to add an hyperlink to any website you have the flexibility to customize each item with a particular web address and the corresponding text to be displayed files the files column allows users to attach, preview, and manage files directly within a record it’s designed to centralize documents such as reports, images, or contracts, keeping all relevant materials in context supported actions upload single or multiple files via file picker (web & mobile) preview supported types (e g , pdf, jpg) delete files (single or multi file mode) workflow integration – usable in workflow automations (upload, delete, etc ) supported file types documents doc, docx, xls, xlsx, ppt, pptx, pdf, txt, csv, json, html, htm, xml images jpg, jpeg, png, webp, gif, svg, bmp videos mp4, webm, mov, wmv, avi audio mp3, aac, wav, ogg archives zip, tar, 7z, rar file type restrictions admin level vs column level the platform supports file type restrictions at two levels admin level restrictions administrators can define a global allowlist of permitted file types across the entire account any file type not allowed at the admin level will be blocked globally – it cannot be uploaded to any files column, regardless of the column’s individual settings column level restrictions each files column can further restrict file types on top of the admin level allowlist columns can narrow down the list of allowed file types, but cannot override the admin restrictions in other words ➤ allowed in admin + allowed in column = upload possible ➤ not allowed in admin = upload blocked, even if allowed in column this layered control ensures that only explicitly approved file types are accepted, both at the admin and column level to allow file types follow the next steps click the three dots next to the column name click on “allowed file types” choose the file types you want to allow don’t forget to save file storage limits the files column enforces storage limits to ensure performance and compliance with user or system level quotas per file size limit each uploaded file must not exceed the maximum allowed size per file , as defined by the system or user level policy files that exceed this limit will be blocked, with a clear error message indicating the allowed size account level storage quota each user or workspace may have an overall storage quota if this quota is exceeded, no new files can be uploaded until storage is freed or increased uploads blocked for this reason will include an error message explaining that the account has reached its storage capacity