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 common examples of each one.
Word | Usage | Example |
Curly Bracket | Reference a {Column Name} | {Price} or {Status} |
Function | References a formula function that performs specific calculations using specific column names | SUM ({Value 1}, {Value 2}) or AVERAGE ({Value 1}, {Value 2}) |
Operator | Symbols used in formula to output different calculations |
|
String | Group of text characters that are used in the formula. String input need to be given in double quotes. | “This text needs to be changed” |
Array | Collection of values separated by a comma | Price 1, Price 2, Price 3 |
Integer | Whole number - positive, negative or zero | 9 |
Date | A date format that can be represented in multiple ways | January 1st, 2022
|
Also Read: How are Stackby Formulas different from Excel
