Fruitask has several data types which you can use to tailor your workspace according to your needs. Below is the complete list of data types. **Short Text** A short text is the default type. It is ideal for tabbing information that you want to see at a glance, such as titles, names, tasks, and many more. It supports alphabets, numbers, and special characters. It can be edited and saved automatically. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/6cbabe951b838f020220514140534.png) **Long Text** The longÂ text allows you to detail your work, ensuring that your team understands what they'll be doing. Unlike the Short Text, you can write paragraphs and descriptions, which are scrollable! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/c46b551455ba1ff20220514141502.png) **Link** This data type allows you to include links in the column to collect all of the information you need for the task. With just one click, you can access all of your Google Docs, photographs, videos, and web sources of information. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/f6500f43c10c51320220514142007.png) **Email** Instantly connect to your members via their e-mail accounts with this data type. Set the column header to short text first. Then, enter their e-mail address in the cell. Set the column to Email to use the function of this data type. If you click an address, you will be redirected to your default mailbox. Isn't that awesome? !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/5c75494445c58f320220514142217.png) **Password** If you're not ready to share your column inputs just yet, the PasswordÂ will help you keep private information safe. The texts will be encrypted when you change the column header to this data type. If you want to reveal them, change the column back to a short text. It's that simple! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/39433798811911c20220514142627.png) **Droplist** This data type can help track the users progress assigned to the task. You can create a multiple-choice menu and customize their labels as you wish. When you click on a cell, it will pull down a menu where you can add tags. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/f3f0ea162231c3020220514143000.png) *How to use droplist?* Change the column to Droplist. You may choose between a single drop list and a multiple drop list. If you choose the single type, a new label will always replace the old label in the cell. If you choose the multiple one, more than one label may appear in the cell. It depends on your preference! *How to edit droplist?* In the droplist, choose "setting" found at the bottom of the menu. To change label name, simply click on the label and type yourÃ‚Â text. To change the color, click the paintbrush icon next to it and select the color you want. Click the trash can icon next to the paintbrush to delete the drop. To add new drops, click the "add new" button below and begin customizing. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/c66077dc9aeda0620220514143201.png) **Radiolist** Radio buttons and drop-down lists can be used interchangeably, but a web designer may choose one over the other depending on the use case. However, drop-down lists take up less screen space. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/316a836de7eb04e20220514143455.png) *How to edit radiolist?* Click the cell on the radio list and choose "setting" found at the bottom of the menu. To change the bubble's label, just click on it and type your text. To change its color, use a paintbrush beside it to choose what you prefer. Click the trash can icon beside the paintbrush if you wish to delete the bubble. Click "add new" below and start customizing if you want to add bubbles. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/885b5877891d72f20220514144754.png) **Users** This data type allows you to assign a workplace collaborator. Before using this function, go to the "collaborator" tab above the workspace and type in their email address. After you've found the users you want to add, click the "invite" icon. Once you've gathered everyone in the workplace, you can start assigning tasks by clicking on the user cell. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/d97dd7a954af41720220514144446.png) **Attachment** This data type allows you to access any file in your workspace. First, set your column header to text. Then, paste the file link and change the column to attachment. You can view or edit the file with just one click without opening another tab in your browser. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/0b01bb00c1a73ac20220514143803.png) **Drawing** Drawing is the exciting part of the data types! Drawing allows you to transform a cell into a canvas. Have fun drawing with the following features: !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/0c6c196d97d5fa420220514145200.png) !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/1e6bb9523baf4cf20220514145447.png) * Brush: This tool lets you draw on the canvas with six fun colors. You may adjust its size and its transparency. * Straight Line: Is drawing a straight line frustrating to you? Worry no more! This tool will help you draw a stable line on the canvas. * Image: This tool lets you add an image to your canvas that you may use as a reference. You may resize it by dragging its corners. You may also move it wherever you want. Cool, right? * Eraser: If you made a mistake in your drawing, don't panic! This eraser tool will help you remove it. * Crop: With this tool, you can drag the cursor to the space you want to crop and save it as an image afterward. * Delete: This tool will help you delete everything on the canvas in the blink of an eye so you can start again. * Revoke and Go Ahead: These tools are represented with two curved arrows: one faces the left while the other faces the right. If youre finally satisfied, click the keep icon located on the bottom left corner of the screen and click save. Just click the leave canvas button to go back to the workspace. **Checkbox** The checkbox is a more straightforward way of tracking the number of tasks you've completed in the workspace. When you change the column header to this data type, youll see a box in the cell. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/8d1d1a37897d0ef20220514150353.png) **Colors** This data type is an accurate way to choose hues for the color scheme of your templates or websites. There are two ways to do this: first, change the column to Color, then click on the cell. A color board will appear where you can drag your mouse until you find the right shade or input a hex code. Another way to do this is to set the column to Short Text and input the HEX code. When you change the column to color, the circle will be painted in that shade. Easy peasy! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/b75306be285ac9920220514150648.png) **QR Code** Generate a code automatically with this data type for your text data. Don't worry about where it goes after it be saved instantly! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/064307e2a2c7e2320220514151035.png) **Numbers** We also have an option for your numerical data! This data type will cater to you, whether it's the word count for your blogs or the number of items. There is an up-and-down arrow on the right side of the column to change it without typing. You can also use this feature along with the equation data type. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/cf0a38459ff115320220514151239.png) **Time** Yes, we also help you with your time management! This data type lets you transform a workspace into a daily time record. By converting a column to time, you can track when your team has logged in and out of your workspace. You may also use this in setting deadlines and timeframes for tasks. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/d394750c8b32f4320220514152508.png) **Equation** This data type is basically the calculator of the workspace. When you enter an equation, it will reveal the answer in the cell. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/c7f100118b04d4f20220514151821.png) **Rich Text** Rich text lets you edit and format the draft of your web content on the column itself, making it perfect for blogs. You may italicize or bold texts, put headings, insert quotes and images, include bulleted or numbered lists, create links, and preview your output. It also has a word and line counter below so you can track its length. To do these tricks, highlight your selected text and press your target icon located on top of the box. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/6db85301d61cc0f20220514152104.png) **Calendar** The Calendar lets you set deadlines and jot down important events. This way, you are aware of the time allotted to your task and avoid going beyond your projects time scope. It also has a calendar theme which you can edit and save immediately. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/0cdd8891abb145820220514152548.png) **Rating** When you set the column Rating, you'll see a line of five stars in the cells. Rating helps you measure the task's urgency and set priorities by marking it with some stars. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/ed538a63ec590e720220514152757.png) ### What else can I do with the data types? Aside from using data types, you may tailor the workspace according to your project needs by clicking the Rename, Description, and Delete functions in the header menu. With **Rename**, you'll be able to set the header's name according to its purpose and use an appropriate data type. For example, when you rename a column with ""Assignee"", you may use the ""Users"" data type to assign collaborators. With a **Description**, you'll be able to include a short paragraph about the purpose of the details of that particular column. It will appear above the data type selection. When you click **Delete**, you'll be able to remove an entire column from the worksheet. Be careful, though, because you cannot retrieve your data once you've confirmed the deletion.
Keep your team updated on what's happening inside a workplace with the Chat feature of Fruitask! Our chat system functions both as a sticky note and a messenger. You may post important announcements, initiate a conversation, and even store files. Here's all you need to know about the chat system and settings in Fruitask. ### Expand Chat This feature lets you lengthen the chatbox to view your messages better. Bonus part: it has a fresh look that will not make you feel pressured at work! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/13aca53abb81b6f20220514153906.png) ### Search Messages To see older messages, go to the "gear" icon and select "search messages". It will bring up a search box at the top. Type the keyword(s) you're looking for in the box. Any messages containing that word or phrase will appear. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/9dffb7c084db07520220514153956.png) ### Live Storage Check to see how much memory space you used at work. Keep in mind that each workplace only has 500 MB. So put it to good use! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/3312955c67c18d620220514154101.png) ### Download Files Download any files you'll need at work and save them locally so you can access them later. !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/c12fe8e0961ea7620220514155108.png) ### Export History See the changes that have occurred in your workspace. It shows who edited your workspace, when it was edited, and what changes were made. You may also save the file for later use! !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/c26be60cfd1ba4020220514155306.png) ### Exit Settings Once you've finished making adjustments or changes, click "Exit settings." !(https://fruitask.com/assets/file_upload/A2q8BZDwY7VyQML/ca8a52904ddd4f220220514155456.png)
If you want to do more in your workplace, and you might probably try the **Transform** features. Though is kind of advance mode but we still keep things simple and easy. So let's dive in how it might help you. # AutoNumber Let say you want to fill all the rows by numbers. Manually typing might get you fingers hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the **Transform**, in Array_Command enter this code and leave the row as 0. `AUTONUM()`. Then start executing the code. Voila! **What if you just want to start in a specific row and end in a row?** Just run the same command but this time, input the start row number to the row textbox. # Set Date Let say you want to fill all the rows by calendar date. Manually typing might get you fingers hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the **Transform**, in Array_Command enter this code and leave the row as 0 `CREATED()` Then start executing the code. Voila! **What if you just want to set a date for all row?** Try to modify the command into something this `CREATED(08/04/2022)` You need to MM/DD/YYYY format the execute the code. # Fill Value Let say you want to fill all the rows by calendar date. Manually typing might get you fingers hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the **Transform**, in Array_Command enter this code and leave the row as 0 `FILL(Avocado)` Then start executing the code. Voila! **What if you just want to start in a specific row and end in a row?** Just run the same command but this time, you need to modify some format. For command you need to add the word you need use and the start row number. Looks like this format `FILLSTOP(AVOCADO,5)` And to end that command in a specific row, just set the end row number in a row textbox. # Replace Text Let say you want to replace some value in all the rows. Manually replacing them might get you fingers hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the **Transform**, in Array_Command enter this code and leave the row as 0 `REPLACE(Avocado,Banana)` You need to include first the word you need to replace (Avocado) and next the value that will replace (BANANA). **What if you just want to replace a specific value with an empty?** Just run the same command but this time, you need to modify some format. For command you need to add the word you need use and use the "" or leave it nothing. That will serve as empty. Looks like this format `REPLACE(AVOCADO,"")` or `REPLACE(AVOCADO,)` # Sum Total Let say you want to sum a total of the entire data. Manually calculating them might get you brain hurt, specially if you already had hundreds of row. This trick might help you. Just select a column, select the **Transform**, in Array_Command enter this code and leave the row as 0 `TOTAL()` **Note:** *This only work if the column is using Number data types.* # Duplicate Row Duplicating row features already added for our UX, you don't need to run the code anymore, you can easily use them in row settings. However in case you just need to try, this command works `DUPLICATE()` and to identify the row were trying to clone, just enter that row number into row textbox. # Duplicate Column Duplicating column features already added for our UX, you don't need to run the code anymore, you can easily use them in column settings. However in case you just need to try, this command works `COPYCOLUMN()` and to identify the row were trying to clone, just enter that row number into row textbox. # Row Created Date Are you wonder when the specific row created? Let say it was added via form or a collaborator, you can easily figure that out by running this code. `BIRTH()` Just leave the row as 0 for default. **Note:** *This only work if your workplace specifically in Dragonfruit 5.4 version.* # Text ALL CAPS Thinking to uppercase all of your data?, you can easily figure that out by running this code. `ALL_CAPS()` Just leave the row as 0 for default. # Text lowercase Thinking to lowercase all of your data?, you can easily figure that out by running this code. `LOWER_CAPS()` Just leave the row as 0 for default. # Random String Thinking to generate a random string with combination of numbers and letters?, you can easily figure that out by running this code. `RANDOM()` Just leave the row as 0 for default. # Random Letters Thinking to generate a random string with combination of letters only?, you can easily figure that out by running this code. `RANDOM_LET()` Just leave the row as 0 for default. # Random Numbers Thinking to generate a random string with combination of numbers only?, you can easily figure that out by running this code. `RANDOM_NUM()` Just leave the row as 0 for default. # JOIN Text Thinking to join value from Column1 and Column 2 with a special character seperator, you can easily figure that out by running this code. `JN(ColumnName1,ColumnName2,separator)` Supported Separator: *.,$%&*#@+_=* Ex: `JOIN(Name,Age,===)` Output: *JohnDoe==25* Just leave the row as 0 for default. # ENCODE Value Thinking to encode your value using **base64** you can easily figure that out by running this code. `DECODE()` Just leave the row as 0 for default. Decode is not yet available, however you can encode it on your application end if your using an API for your data. Amazing! Easy right. If you need more command or suggest anything. We're the dev team! 😃 You can reach us [here](https://fruitask.com/form/?p=contactfruitask). Thank you for taking time to learn! 😚 xoxo
The Artificial Programming Interface acts as a doorway between platforms. It allows you to use data from one website to another. Fruitask provides you with an API key that will let you transfer data, ..
How does Fruitask secure data? Fruitask uses end-to-end encryption, which means that all data, from your password to everything saved in your workplace, is encrypted or hashed, allowing you to re..
Have you ever wanted to set colors in your workplace? If you want to bring your creativity to your space, coloring is one way to do that with ease. Setting the color of a table sets the mood and tone ..
Here s the not-so-good news, you won t be able to recover your data once you ve deactivated an account. That s why before deactivating your account, w..
Data Import lets you upload data from external sources. Find the Import icon on the homepage of your Fruitask workspace, click it, and upload a file from your local storage. !(https://fruitask.com/..
If you want to leave a workplace on Fruitask, you have two options: have a team member remove you or leave the workplace by yourself. Option 1: If a workplace is not active and has no members, yo..
Did you encounter a problem on our platform? When a restriction occurs at Fruitask, an error or permission code will flash on your screen. These are the following: • Permission Denied: this code..
By default, Fruitask allows you to upload multiple file types. If you want to upload a file type that we don t currently support, feel free to contact us! Supported File Types Upload the follo..
Feel free to invite your friends to collaborate with you! Modify your Fruitask workspace according to your project details then give your friends a role based on what they can and cannot access. To ef..