Apply formulas

updated 2 days ago

This is where the magic begins! And Ninox can show what else it can do

With formulas, you can automate processes. For example, you can:

Automatically format text
Perform calculations
Incorporate logic to generate conditional information ("If this is true, then do that ...")

Fields where you can insert formulas (or scripts) are always marked with fx in Ninox.

In our tutorial, we'll start small and use a Ninox function to automatically calculate the age of our contacts based on their birthday.

Procedure

An exciting moment! You are about to script in Ninox for the first time. We will explain everything in detail. Additionally, you can watch everything in the video.

The principle will always be the same, whether your script consists of just one line or is much more complex.

1. Open Table Settings and Add a Formula Field

Open the Table Settings of the Company table. Here's how
Add a Formula Field fx under Birthday by dragging it from the right column to the middle and placing it under Birthday.
Give the field the name Age (today).

Add a formula field to your table and name it "Age (today)"

2. Open Field Settings and Formula Editor

Click on the newly added field Age (today). The Field Settings will open in a new pop-up.
Click in the formula field Formula. The Formula Editor will open. It looks empty now, but we will change that soon.

Click in the field settings on the formula field to open the formula editor

3. Insert Script and Automate Calculation

Insert the function age(). As you type, the Formula Editor will immediately suggest options. Select fx age and confirm with Enter.
In the parentheses that are automatically added, enter Birthday. This tells the function age() which date to use for the calculation.
Save your script. Click OK in the Field Settings. Return to your form.
You will see the calculated age displayed in the new field Age (today). This field has been added to all records, calculating the current age for all entries!