-
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…
-
Web integration and API
An overview of functions to connect your databases to external services and think outside the box createCalendarEvent To create an event in the Apple Calendar App createCalendarReminder To create a…
-
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.…
-
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, ...…
-
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, ...…
-
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.…
-
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.…
-
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,…
-
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,…
-
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.…
-
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.…