-
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,…
-
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.…
-
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,… -
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…
-
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.…
-
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.…
-
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.…
-
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.…
-
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.…
-
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…
-
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.… -
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.…
-
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.… -
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…
-
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.…
-
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,…
-
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,…
-
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,…
-
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.…
-
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.…
-
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.…
-
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:…
-
tan
To calculate the tangent The function returns the tangent of an angle. Syntax tan(number) Return number Examples tan(x) To calculate the tangent of a number x. tan(1) Result: 1.5574077246549023 tan(1.…
-
tableId
To return the ID of a table With this function, you'll find out the internal identifier of the current table. This ID consists of at least 1 capital letter. It starts with A.…
-
sum
To return the total sum of a number array With the function, you can calculate the mathematical sum of numeric values from an array or a table. For example,…
Functions are the practical application of the Ninox scripting language to process data and navigate the solution