-
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.…
-
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,…
-
userId
To return the ID of a user This function will show you the internal alphanumeric ID of the current or a given user. Syntax userId() userId(user) Return string Examples userId() To return the ID of…
-
userIsAdmin
To return Yes (true) if the current user has the admin role With this function, you can check if the current user's role is admin, that is, if they have admin rights.…
-
userLastName
To return the last name of a user This function will tell you the last name of the current or a given user.
This refers to the last name that is on file in the profile of the user,… -
userName
To return the username of a user The function tells you the username of the current or a user.
This refers to the display name that is on file in the profile of the user.… -
userRole
To return the role of the current or a given user This function finds out for you, which role a user has been assigned. By default Ninox has 2 roles in stock:…
-
userRoles
To return the role of a given user Get back all roles the current or a given user is assigned to in a workspace with this function. The result is an array with the role names.…
-
users
To return the IDs of all collaborators in an array This function will return all collaborators of your workspace. The result will be returned as an array with values of the data user.…
-
validateXML
To validate XML documents against an XSD schema The validateXML function checks whether a given XML string conforms to the rules defined by an XSD schema.…
-
waitForSync
To return Yes (true) if the database is synced with the Ninox Cloud With this function, you attempt to synchronize your data with the Ninox Cloud. If the attempt to synchronize your data with the…
-
week
To return the calendar week of a given date value This function tells you the week of a given date value as a number with 1st week = 1, 2nd week = 2, … 53rd week = 53. You can use all data types.…