-
teamId
To return the ID of the current workspace This function returns the ID of the workspace you are in. You might need this in your REST API. Syntax teamId() Return string Examples teamId() Result:…
-
testx
To check if a text has matches with a given regular expression This function does the same as contains(): it checks a text for the occurrence of a certain string.…
-
text
To convert a value to a string and possibly reflect the format options With this function, you can convert almost any data type at Ninox to a text value.…
-
Text
An overview of text-related functions capitalize To capitalize the first letter of each word chosen To return Yes (true) if the given value equals a given selection concat To return all items of an…
-
time
To return the current time With this function, you can return the current time or set a time. You can use this function for calculations with other time-related data types.…
-
timeinterval
To convert a given time-related value to a time interval, i.e. a duration To convert a given time-related value to a time interval, i.e. a duration. If the value is a number,…
-
timestamp
To convert a given time-related value to a timestamp With this function, you will convert a time-related value to a UTC-based timestamp. If you use a value without time,…
-
today
To return the current date (without time) Here you can determine the current date, i.e. the respective day on which the function is executed. Therefore,…
-
trim
To remove preceding and following spaces Especially when copying & pasting text from another source, it can happen, that you also “import” spaces that are unwanted.…
-
unique
To return an array with unique elements Filter out duplicates from one or more arrays to get an array with only unique values. This can be helpful to make sure there are no double entries in your…
-
unshareAllViews
To unshare all views of a given table This function will stop sharing all views of a table.
This function doesn't work in a formula field because it's modifying data.… -
unshareFile
To unshare a given file With this function, you can stop sharing a file. Syntax unshareFile(file) unshareFile(nid, string) Return void Examples unshareFile(myFile) To unshare a given file.…
-
unshareView
To unshare a given view of a given table With this function, you stop sharing a previously shared view.
This function doesn't work in a formula field because it's modifying data.… -
upper
To output a string in the upper case This function converts lowercase characters in a text to uppercase. Other characters stay untouched. This can be useful for comparing strings or for correction of…
-
url
To convert a value to a link With this function, you can display a formula field as an URL field with an internet button. By clicking the button, the URL will open in your local browser.…
-
urlDecode
To decode a given string from a URL-compliant format into text This function will convert a string from URL-compliant format into plain text based on the ASCII character set.…
-
urlEncode
To convert a given string into a URL-compliant string based on the ASCII character set This function will convert plain text based on the ASCII character set into a URL-compliant format.…
-
urlOf
To return a link for a given record or view With this function, you can get a link to a specific record or view, for example, to share it with your members in your workspace.…
-
user
To return the current or a specific user There is not much to say about this function; it just returns the name or email of the current user. That's it.…
-
User interface
An overview of the functions related to your user interface alert To open a pop-up with an alert message barcodeScan To open the barcode scanner and return the scanned value as a string…
-
User management
An overview of all user management related functions clientLang To return the currently used language of the browser or app in abbreviated form isAdminMode To return Yes (true) if the edit mode is on…
-
userEmail
To return the email address of a user This function will tell you the email address of the current user or a given user. Literally, the email the invitation to this specific workspace (team) was sent…
-
userFirstName
To return the first name of a user This function will tell you the first name of the current or a given user.
This refers to the first name that is on file in the profile of the user,… -
userFullName
To return the full name of a user This function tells you the full name of a user. If not specified differently, the function will return the current user.…
-
userHasRole
To return Yes (true) if a user has a given role Check with this function if the current or a given user has a specific role. Syntax userHasRole(string) userHasRole(user,…