Search
⌃K
Links

Create your own functions

function
Create your own functions with Ninox to automate workflows according to your needs.

Advantages

  • write a script once and use it throughout the database
  • concise scripts because you only need your own function and don't have to insert the entire script once or even multiple times
To define a function, use function followed by whatever name you choose. Then, in parentheses, specify which parameters are to be used. These are separated by commas.

Define parameters respectively as follows

parameterName : parameterType
To create a function without parameters, insert empty parentheses ().
Like scripts, the last line in the definition of the function is the return value.

Define functions globally

To use your functions across the entire database, enter the function in the tab bar of the database under Options in Global functions.
Options are displayed when you're in edit mode
.

How it works

  1. 1.
    Enable edit mode
  2. 2.
    Click the Options tab
  3. 3.
    Enter your function(s) under Global Functions.
Under "Global functions" you can enter your own functions
Insert the function in a formula field of a table and that function is only available in that formula field. This is useful when keeping repetitive sections short, or when your function refers to the current table, respectively.

Hello Mom. You are 100 years old!

Let's create a function hello to greet a person and tell them their age. First, pass the function a string for the name and a number for the age as parameters. These parameters are inserted into a given sentence at the appropriate positions.

Example

1
function hello(name : text,age : number) do
2
"Hello " + name + ". You are " + age + " years old!"
3
end
Result: Hello Mom. You are 100 years old!
If you called the function like this: hello("Mom", 100)
parameterName
parameterType
name
text
age
number
Unfortunately, not all data types are currently supported by user-defined functions.

Data types for creating user-defined functions

These following data types are already available for creating user-defined functions.
Data type
Description
Example
text
corresponds to the data type string and stands for simple text
"Mom"
number
is a number
100
boolean
is either true or false
​
✅
"Mom" = "Mom"
⛔
"Mom" = "Dad"
date
is a date
date(1922, 1, 13)
time
is a time
time()
datetime
corresponds to the data type timestamp and stands for a timestamp
datetime(date(1922, 1, 13), time())
Table name
corresponds to a record from the specified table
myRecord : 'Table 1'