Columns & Column types (properties)

Using columns to structure your data is a breeze with Stackby. Read on to know more. Using column types Importance of column types Basic column types Advanced column types FAQs Using different column types You can choose a new type of column by do...

As we discussed in the Overview of Tables article,  Stackby columns are essentially specific 'field types' that allows you to store rich data on each of your rows.  You can customize each of these columns, your way, per your needs & workflow.  A...

The primary column is always the first column in any of your tables. It cannot be deleted, moved or hidden.  Usually it is meant to give a short and unique representation (thing, task, project name, objects etc) to each of your row. We use the pr...

Short Text  A short text field type accepts a single line text for each cell. You can put any text value you want for each cell.  As the name suggests, it is best to put short, unique values such as things, tasks, projects, companies, deals, perso...

We support three different types of number field types that are most often used for any projects  - Decimal Type -   As you enter the number type model, you can choose 'Decimal' field type. When you choose decimal field type, you can also choose t...

A date field type allows you to easily enter a date and optionally time into a particular cell.  When you select date, you can choose a date format. We support 4 different formats today incl. a Friendly text based.  Optionally you can also select ...

Inside this article  Creating Single Option Creating Multiple Options What can It be Used for?  Creating Single Option  You can choose a 'Single Option' field type when you want to create options and select a single option from those preset option...

You can add a 'Checkbox' field type that helps denote True/False or Yes/No within that row.  You can use this field type to denote completion of a project, task or to-do based on your workflow.

The collaborator field type allows you to add your particular workspace or stack collaborator in a cell. It automatically creates a dropdown menu of people who are in your stack.  You can also choose from the configuration, whether you want to not...

In this article, read about  Adding a File or Files Viewing the Files Removing the Files FAQs The best part of this field type is that it allows you to add files or attachments on each Stackby row. Adding a File or Files An attachment or files fie...

In this article we will learn about 3 types of column properties: Email Phone Number URL Email An email field type will basically store single email address in each cell. Clicking on the email address in the cell will open your computer's native e...

We currently support 2 inbuilt field types such as  Created time (at)  Updated time (at) Created time -  Will automatically show the date (and time) that row was created. Just as the date field type, you can also choose the date format and also se...

Let's learn about one of the most powerful column types in Stackby: Formulas.  What are Formulas? How are they different from spreadsheet formulas?  Types of Formulas Take this 30-minutes live tutorial to learn everything about Stackby Formulas:  ...

Not everybody is a fan of formulas. That doesn’t mean that you need to be handicapped at creating or understanding how formulas work in Stackby. Stackby is easy to use even for the most non-technical user. So how can creating formulas on Stackby b...

Databases define relationships. One of the major advantages of databases over spreadsheets is that in databases, relationships are a first-class citizen.  A column type 'Link'  allows you to do just that.  You can now link between two tables via ...

Imagine your boring, lengthy VLOOKUP and INDEX/MATCH formulas in spreadsheets? Well, it's not needed in Stackby.  You can bring information from other tables in your current table by configuring a Lookup column type.  Note:  Lookup is only possibl...

Aggregation summarizes and brings aggregate numerical and other values from linked tables. Right now, the aggregation column type brings only numerical values. In this article, we will cover the following: Pre-Requisite to configuring an Aggregati...

Simply put, Auto Number is the numbering of records in your stack. Nope, it is not the same as assigning a serial number to the records.😊 It is different. We will be covering the following in this article: What is Auto Number? How to Configure Aut...

You can also change the way columns are shown in your table, by adjusting the column width.  The column width can be adjusted to your liking in the table by clicking on the column divider and stretching it.  By default, today, we have selected the...

We recently introduced the "Ratings" column type on Stackby.  With this column type, you can easily rate your records or can use it for quality assessment. Let us take a look at: Adding Ratings as a column type How to rate your records Adding Rati...

If you're using a relational database, you know about Link, Lookup and Aggregation. But what if you just want to bring only certain information from your linked records from other table. Learn how you can do conditional filters on Lookup, Count & ...

Advertisers are taking advantage of Barcode  by using them to reach out to customers in a more interactive, interesting, and unique way. With the use of smartphones, just by downloading and installing a stackby app that can read barcodes you can d...

Automatically add who -  1. Created the row  2. Last Updated the row  Check out this quick video:    Last Updated the row for Specific Columns Whenever any change is made to a row, whether it's updating a cell value, adding a comment, or attaching...

Keep track of your task's progress directly from your tables.  Add a progress bar and show information of your checklists .   Once you add the checklists, you can then add the 'Progress Bar' column type to see how the checklists are doing:

How to use Duration column type, learn in this quick 2 minute video: 

The button field is an interactive column type that lets you trigger certain actions directly. Adding button: Select button column type  Select button label you want and type URL formula, or just URL Current Button field actions 1. Open URL The Op...

Freezing a column means locking it to keep it visible while the user scrolls through the Stack. This is specifically helpful if a column is required to be seen at all times. When viewing a grid view, you can freeze - or lock - a column to always k...

In this article we will learn to combine the values in multiple columns together with a formula column. With the help of some methods we can enhance their functionality. CONCAT() Concatenate links together different fields (especially characters a...

Time column type is a versatile tool for managing time-related data in your spreadsheets. You can easily select a time into a particular cell.  Steps to add time column type in your Grid. Add a Time Column:  In your table, click on the column head...