Table’s Records

a table is a collection of records (rows) that can represent different types of values ​​corresponding to columns the content of the row is populated according to your data add a record to add a record, just click the ‘+’ at the bottom of the table duplicate & delete to use these actions, first select the item(s) you want to perform actions on by checking the checkbox select checkbox allows you to select the record to perform bulk actions duplicate creates a copy of the selected record delete permanently removes the selected record from the table types of columns defines the different data formats available in the table, allowing you to store and display various kinds of information such as text, dates, numbers, statuses, files, and more 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 you can add more labels write a new status in ‘add status’ to select a color, click on the desired option click on ‘save’ 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 table automations https //app archbee com/docs/ixqqblwfxopjg0nave78y/hvdmr16kyjggwcsq2arm1 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 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 the section highlighted in the red box represents the time input (hours and minutes), which is added when using the second option (time selection) 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 collaborators 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 choose the table you want to connect to by searching for it in the search box, or select it from the list (only text fields) 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 allow linking to multiple records select this if you want to link multiple values from the selected field in your table record 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 display fields choose which column from the current table will be displayed in the connected table save click on the save button to confirm note connected table fields display relationships between records when updating https //app archbee com/public/preview ixqqblwfxopjg0nave78y/preview hvdmr16kyjggwcsq2arm1#t4 zr or creating 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 to filter connect table 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 click 3 dots and after that "settings" to open the filter screen if you don’t need to apply any filters, just click ok to proceed click on 'add filter' 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 functions 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 to edit this field, click on the record where you want to add or update the link write or paste a link enter the url you want to attach (e g , a website or resource link) text to display define the text that will appear instead of the full url apply saves and applies the link to the selected record 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 open settings menu click on the three dots (⋯) in the files column to open the available options menu access file type settings from the menu, select “allowed file types” to view or configure which file types are permitted here you can view which file types are allowed to be uploaded, based on the current account permissions the available file types are derived from the account level settings, and can only be further restricted here (not expanded) to manage or update these permissions, please access them via the following link https //app archbee com/docs/ixqqblwfxopjg0nave78y/ vcgvwvr7lhgegoxeulrd#cotl1 note full 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 move to folder click on the three dots ••• on the right side of the table you want to move to another workbook click on ‘move to folder’