Create your own functions

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

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. Enable edit mode

2. Click the Options tab

3. Enter your function(s) under Global 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

function hello(name : text,age : number) do
	"Hello " + name + ". You are " + age + " years old!"
end

Result: Hello Mom. You are 100 years old!

If you called the function like this: hello("Mom", 100)

Data types for creating user-defined functions

These following data types are already available for creating user-defined functions.