-
removeFile
To securely remove a file from a field or record This function removes a file by specifying either: A file object that contains the necessary information (nid and the file name).…
-
renameFile
To rename a file in a field or record This function renames a file by specifying either: A file object that contains the necessary information (nid and the file name).…
-
parseCSV
To return a structured list or array of rows and data from specified CSV text The parseCSV function parses CSV-formatted text into a structured list or array.…
-
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.…
-
fieldId
To return the ID of a field This function retrieves the internal identifier of a specified field. A field represents a location stored within a row of a table in a database.…
-
get
To return a value of a given field This function retrieves the value of a field. You can use get to access fields by their name or ID, making it easy to extract data for use in scripts and…
-
set
To update a value of a given field This function updates a field and its value. You can use set to modify a field by specifying its name or ID as text, such as "Name" or "A.…
-
format
To format a given value With the function, you can format numbers, date, and time values as you need them, to use them in text or formula fields.
Note: All entries are optional.… -
yearweek
To return the week and the year of a given date value You will get the year and the week from a given date value, displayed in the format “YYYY WW”. This can help you filter, sort, and group records.…
-
yearquarter
To return the quarter and the year of a given date value You will get the year and quarter from a given date value displayed in the format “YYYY Q1”. This can help you filter, sort, and group records.…
-
yearmonth
To return the month and the year of a given date value You will get the year and month from a given date value displayed in the format “YYYY/MM”. This can help you filtering, sorting,…
-
year
To return the year of a given date value This function provides the year from a date value as a number. You can use this function when calculating year numbers as well as filtering, sorting,…
-
workdays
To return the number of working days between 2 given dates With this function, you can calculate the number of working days between 2 given time-related values, with Monday to Friday as working days.…
-
weekdayName
To return the full weekday name of a given date value With this function you can determine the corresponding weekday as a string from a weekday number with 0 = Monday, 1 = Tuesday, … 6 = Sunday.…
-
weekdayIndex
To return a given weekday name as a number With this function, you can determine the corresponding weekday as a number from a weekday name. The weekday is a number with Monday = 0, Tuesday = 1, ...…
-
weekday
To return the weekday of a given date value as a number With this function, you can determine the corresponding weekday from a date value. The weekday is a number with Monday = 0, Tuesday = 1, ...…
-
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.…
-
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…
-
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.…
-
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 (team) with this function. The result is an array with the role names.…
-
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:…
-
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.… -
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,… -
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.…
-
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…
Functions are the practical application of the Ninox scripting language to process data and navigate the solution