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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By

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

By