Français

Español

🎉 Home

Voltapp Introduction

CUSTOMIZE A TEMPLATE ⏱

Discover Templates

Create your Airtable

Connect your data

Publish your app

LEARN VOLTAPP ▶️

Discovery of the interface

Nodes

Graph

Variables

Custom the design

Placing elements

Design examples & Devices

Managing pages

Create dynamic content

Manage data with Airtable

Combine templates

CREATE YOUR 1rst APP

Dynamic content

Data & design creation

GO FURTHER

Webhooks integration (Make, Zapier…): ex Notion

Team work

Internationalization

Sovereign data

Formulas

  1. Definition of a formula
  2. The different types of formulas
  3. Examples of use cases

Definition of a formula

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

The different types of formulas

Formulas are available in the attributes and in the parameters of some blocks that are convertible into formula.

Voltapp uses nocode & low code formulas:

No Code

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/f95972dc-81f8-40df-872c-0573f3ef4015/Untitled.png

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/adce1461-bded-4da5-b5a3-5e885062290b/Untitled.png

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.

Low code

Other types of "where" formulas for more advanced database tools.

Examples of use cases

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$

Make a text dynamic

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")

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/9437fb84-192f-4bd7-9e72-791fd12376ba/Untitled.png

Make the design dynamic

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/29577f49-2c7d-4cce-9374-e581b1735ee3/Untitled.png

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/2f969b4f-6879-4fd4-a8e5-c9f23a1ff265/Untitled.png

Write a dynamic rule

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/5fce8bd7-9e38-445b-b948-053f29bf1cdd/Untitled.png

Example to manage the plural in a text according to a numeric variable (here orderCount)]()

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/36ed9313-5200-40c2-9dab-b17814f3bc6d/Untitled.png