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
Script editor features
Functions overview
Functions—by category
Functions—alphabetically
abs
acos
age
alert
appointment
array
asin
atan
atan2
avg
barcodeScan
capitalize
ceil
chosen
clientLang
closeAllRecords
closeFullscreen
closeRecord
color
concat
contains
cos
count (aka cnt)
createCalendarEvent
createCalendarReminder
createTextFile
databaseId
date
datetime
day
days
degrees
dialog
duration
email
endof
even
exp
extractx
file
files
first
floor
format
formatJSON
formatXML
html
http
icon
index
isAdminMode
isDatabaseLocked
isDatabaseProtected
item
join
last
length
latitude
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
quarter
queryConnection
radians
random
range
raw
replace
replacex
round
rpad
rsort
sendCommand
sendEmail
sign
sin
slice
sort
split
splitx
sqr
sqrt
start
string
styled
substr
substring
sum
tan
testx
text
time
timeinterval
timestamp
today
trim
unique
upper
url
user
userEmail
userFirstName
userFullName
userHasRole
userId
userIsAdmin
userLastName
userName
userRole
userRoles
users
week
weekday
weekdayIndex
weekdayName
workdays
year
yearmonth
yearquarter
yearweek
Appendix
API
Introduction
HTTP function
Private Cloud APIs
Public Cloud APIs
Private Cloud / On-Premises
Single sign-on (SSO)
Windows Server installation
Docker installation
Sample configuration file
🆕
Create print layouts with Carbone
🆕
SQL Server connector configuration
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
sqrt
To calculate the square root
Use the function to find the square root of a positive number.
If the number has a negative sign, use the function abs for example to convert it to a positive number first.

Syntax

sqrt(number)

Return

number

Example

sqrt(x) To calculate the square root of a number x.
sqrt(3)
Result: 1.7320508075688772
​
sqrt(9)
Result: 3
​
sqrt(-9)
Result: (invalid)
​
sqrt(abs(9 - 13))
Result: 2

See also

​sqr which calculates the square of a number.
Previous
sqr
Next
start
Last modified 2mo ago
Export as PDF
Copy link
Outline
Syntax
Return
Example
See also