-
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.…
-
Example DB - dynamic choice with JSON
Attached is a small example database showing how you can use an array of JSON objects as the data basis in the dynamic choice field instead of a table.
-
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 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…
-
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,…
-
Button - open e-mail
Hi all, I have a table (a) with an-email field with recipient, subject and body. Table b already has a relationship with a whereby b has selected one record from a.…
-
CSS Framework & Ninox
Hello, I recently realized that Ninox allows us to use a CSS stylesheet file directly from a CDN link. I wanted to know if we could use a CSS Framework to design a Ninox page faster and more…
-
Dashboard
Hi guys, I experimented a little bit with html and ninox. I created a Dashboard which looks currently like this. I will also attach the code. However is it possible to integreate in Module 4 a table…
-
API pagination same records repeated
I'm learning the basics of API and scripting and trying to start with a simple request - all record IDs for the given table using pagination (limit and offset) and have it saved as a JSON file.…
-
How can I link 2 separate database?
How can I link 2 separate database? For instance one data base with data from customer and another with time and labour. Cheers
-
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,…