## Getting Started with Column Type - Formulas

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: ...

## Formula Terminology in Stackby

Terminology In Stackby we use formulas consisting of terms and symbols which are the same for programming languages. They are simplified to make formulas easier to write and understand. The table below lists the terms you'll encounter and some com...

## Writing Formulas in Excel vs Stackby

If you're an excel or google sheet user who just loves formulas, and are just getting started with Stackby, this article is for you! While the fundamentals of formulas remain the same, there are some differences you can learn as you become a Stac...

## Advanced 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...

## Using Formula in Primary Column

Formulas in Stackby can save you time by calculating data automatically by combining columns contents in a Table. A Primary key is a column in a table which uniquely identifies each row in a table. Primary keys must contain unique values. If you...

## Calculate difference between two dates

You can find the difference between two dates using DATE_DIFF formula function in Stackby. Learn about the complete formula guide here Learn about advanced formula guide here DATE_DIFF({Start Date}, {End Date}, "days") DATE_DIFF({Start Date}, ...

## How to write nested IF statements

NESTED IF Formula You can also add IF conditions to the Nested Formulas. IF({IsCompleted ?}=="checked","MET",(IF(ISBEFORE({Due Date},NOW()),"BEHIND","GOING ON"))) The above formula is used to determine the status of the project. The comparison is...

## Convert UNIX/Epoch time to current date

Here, we have added a new Date function (DATE_ADD()) :- Epoch :- The date and time in a computer is determined according to the number of seconds or clock ticks that have elapsed since the defined epoch for that computer or platform. Epoch tim...

## Encode URL Component to generate pre-filled form URLs

The Encode URL function encodes a URL string, replacing certain non-alphanumeric characters with % and a hexadecimal number. In this article, we will learn how to set up a base to automatically generate unique pre-filled form URLs using ENCODE_U...

## Character Count

Characters are the basic building blocks of writing. Whether you're composing a writing contest entry, a headline, captions or a tweet, sometimes the number of characters you use in your writing is important. For Counting characters, we will us...

## Extract the File Name from Attachments

In this article, you'll learn how you can extract file name from attachment column type. Formula to use: LEFT({Column Name},SEARCH({Column Name},"(")-1) Example:- Here, two columns are used. One is Attachment column and other is formula column....

## Things to keep in mind while using formulas

Well, creating formulas are not everyone's cup of tea, but creating them on Stackby is easy. Having said, there are a few pre-requisites and norms that you need to be aware of before you start creating those simple or complex formulas on Stackby. ...

## Changing the look of a text string

In this article we will learn how you can change the look of a text string using the text functions: LOWER, UPPER, TRIM 1. LOWER 2. UPPER 3. TRIM LOWER() and UPPER() The LOWER function takes a string of text and makes all the characters lowercase....

## Extracting text from a column

In this article, we will learn how you can extract text from a column or field using the following formula functions: LEN() LEFT() RIGHT() MID() LEN () LEN returns the length of a string. You can reference a value/column/string within the functi...

## Guide to REGEX() functions

Regular expressions allow you to find patterns in character combinations in a string. It's super powerful and are used in modern search engines and word processors. There are three types of REGEX Formula functions in Stackby. They are REGEX_MATCH...

## Using logical operators to compare column values

Logical Operations in a programming-language symbol that denotes a logical operation. In stackby we use logical operators that allow you to compare values in one column to another column. Greater than or less than We will have two columns income ...

## Add a line break using \n

We combine several columns with the help of CONCAT() function, but what about if we want line breaks in between? So for that we will use "\n" as a formula. Basically \n is used to add line breaks for more readable result or output. For example, y...

## Other Text Functions: T(), REPT ()

In this article, we will learn T() REPT() These functions are very simple, so it won’t take too long to learn how they work. T() : Return the argument if it is test otherwise blank Result:- REPT() : It repeats a string for the given number of t...

## Array Functions

An array formula is a formula that works with an array of values, rather than a single value. Array formulas can return a single result, or multiple results and it's separated by a comma. In Stackby, arrays can be used in conjunction with an aggre...

## Switch Formula

Decision control Statements are used to decide the order of execution/flow of control in a program by making a decision based on a condition. Such as IF, ELSEIF statements. Switch statement is an alternative to IF statement. NESTED IF Formula Yo...

## The essentials of Stackby formulas

Stackby consists of more than 25 columns to add in the table from that one is FORMULA column type. Formulas let you reference other columns in a table and create different functions based on the content of those tables. In this article, we will le...

## Using & operator in Formula Column

We’ve now added support for ‘&’ in formula column. Here are some ways you can use & in your formula: If you’re using & in the context of two numerical columns, say {Price 1} & {Price 2}, it will basically SUM by default. If you’re using & with two...