🎉 Home
CUSTOMIZE A TEMPLATE ⏱
LEARN VOLTAPP
CREATE YOUR 1rst APP
GO FURTHER
Webhooks integration (Make, Zapier…): ex Notion
REFERENCE
HELP
Mode allowing, at the level of the attributes of nodes, to write text by calling dynamic elements which are the variables.
Ex: In the text attribute of a node Button, we could write the formula: @currentdate + 1
Formulas are available in the attributes and in the parameters of some blocks that are convertible into formula.
Voltapp uses nocode & low code formulas:
Formulas that start with "=" are switched to Excel mode.
NB: Excel formulas can also use text concatenation. See example.
Where formulas are used to filter answers from databases. They use the grammar of the database tool.
The Airtable community is particularly active and the tool is made for beginners.
Other types of "where" formulas for more advanced database tools.
The most used formulas are the simplest:
Name | Example formulation | Expected result |
---|---|---|
ADDITION | =1+2 | 3 |
SUBTRACTION | =5-1 | 4 |
MULTIPLICATION | =2*2 | 4 |
DIVISION | =10/5 | 2 |
IF(Condition, True, False) | =IF(5 < 2, 1, 3) | |
=IF(5 < 2, "No", "Yes") | ||
=IF(isAdmin, "Access allowed", "Access denied") | 3 | |
"Yes" | ||
"Access allowed" : if isAdmin is $true$ | ||
"Access denied" : if isAdmin is $false$ |
Transform a text into a formula to display the value of a variable that can be represented in text (textual: "Jon", boolean: "TRUE", number: "36.5")
Example to manage the plural in a text according to a numeric variable (here orderCount)]()