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

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

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

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

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

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}, ...

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

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 time is def...

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

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

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

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

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

In this article, we will learn how you can extract text from a  LEN() Counting Words() LEFT() RIGHT() MID() 1. LEN ()  LEN returns the length of a string. You can reference a value/column/string within the function following this format: LEN({COLU...

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 Function in Stackby. They are REGEX_MATCH(), REGEX...

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

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, yo...

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

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

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

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

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