Search…
Welcome 🎉
Tutorial
Introduction
Basics tutorial
Intermediate tutorial
Independent tutorial
Build databases
Enable timezone-independent date
Manage databases
Import and export
Duplicate database
Scripting
🆕
Introduction to Ninox script
Formula editor features
Functions overview
Functions—by category
Functions—alphabetically
abs
acos
age
alert
appendTempFile
appointment
array
asin
atan
atan2
avg
barcodeScan
capitalize
ceil
chosen
clientLang
closeAllRecords
closeFullscreen
closeRecord
color
concat
contains
cos
count (aka cnt)
createCalendarEvent
createCalendarReminder
createTempFile
createTextFile
databaseId
date
datetime
day
days
degrees
dialog
duplicate
duration
email
endof
even
exp
extractx
file
fileMetadata
files
first
floor
format
formatJSON
formatXML
html
http
icon
importFile
index
isAdminMode
isDatabaseLocked
isDatabaseProtected
item
join
last
latitude
length
ln
location
log
longitude
lower
lpad
max
min
month
monthIndex
monthName
ninoxApp
now
number
numbers
odd
openFullscreen
openPrintLayout
openRecord
openTable
openURL
parseJSON
parseXML
phone
popupRecord
pow
printAndSaveRecord
printRecord
printTable
quarter
queryConnection
radians
random
range
raw
record
replace
replacex
round
rpad
rsort
sendCommand
sendEmail
shareFile
shareView
sign
sin
sleep
slice
sort
split
splitx
sqr
sqrt
start
string
styled
substr
substring
sum
tableId
tan
teamId
testx
text
time
timeinterval
timestamp
today
trim
unique
unshareAllViews
unshareFile
unshareView
upper
url
urlDecode
urlEncode
urlOf
user
userEmail
userFirstName
userFullName
userHasRole
userId
userIsAdmin
userLastName
userName
userRole
userRoles
users
waitForSync
week
weekday
weekdayIndex
weekdayName
workdays
year
yearmonth
yearquarter
yearweek
Appendix
API
Introduction to Ninox API
http function
Private Cloud APIs
Public Cloud APIs
Private Cloud / On-Premises
Single sign-on (SSO)
Windows Server installation
Docker installation
Sample configuration file
🆕
SQL Server integration
🆕
Print customization
Manage account
Create account
Book subscription
Calculate required licenses
Add licenses
Manage licenses
Invite collaborators
Understand usage overview and capacity restrictions
Ninox, Mac app and iCloud
Resources
🆕
Release notes
Glossary
🇩🇪
Ninox Docs (German)
👵
Legacy documentation
❓
Why did we move the old documentation from ninox.com?
Introduction
User interface
Tables
Calculations
Print
Import and export
System requirements
User management, identities and rights
Data synchronization
Data backup
FAQ
Related Links
Ninox website
Community
Webinars
Pricing
Contact us
Imprint
Privacy policy
Powered By
GitBook
Functions—alphabetically
Here are the articles in this section:
abs
acos
age
alert
appendTempFile
appointment
array
asin
atan
atan2
avg
barcodeScan
capitalize
ceil
chosen
clientLang
closeAllRecords
closeFullscreen
closeRecord
color
concat
contains
cos
count (aka cnt)
createCalendarEvent
createCalendarReminder
createTempFile
createTextFile
databaseId
date
datetime
day
days
degrees
dialog
duplicate
duration
email
endof
even
exp
extractx
file
fileMetadata
files
first
floor
format
formatJSON
formatXML
html
http
icon
importFile
index
isAdminMode
isDatabaseLocked
isDatabaseProtected
item
join
last
latitude
length
ln
location
log
longitude
lower
lpad
max
min
month
monthIndex
monthName
ninoxApp
now
number
numbers
odd
openFullscreen
openPrintLayout
openRecord
openTable
openURL
parseJSON
parseXML
phone
popupRecord
pow
printAndSaveRecord
printRecord
printTable
quarter
queryConnection
radians
random
range
raw
record
replace
replacex
round
rpad
rsort
sendCommand
sendEmail
shareFile
shareView
sign
sin
sleep
slice
sort
split
splitx
sqr
sqrt
start
string
styled
substr
substring
sum
tableId
tan
teamId
testx
text
time
timeinterval
timestamp
today
trim
unique
unshareAllViews
unshareFile
unshareView
upper
url
urlDecode
urlEncode
urlOf
user
userEmail
userFirstName
userFullName
userHasRole
userId
userIsAdmin
userLastName
userName
userRole
userRoles
users
waitForSync
week
weekday
weekdayIndex
weekdayName
workdays
year
yearmonth
yearquarter
yearweek
Previous
Customer solutions
Next
abs
Last modified
1mo ago
Export as PDF
Copy link