Ninox Docs
Searchβ¦
Welcome π
Tutorial
Introduction
Basics tutorial
Intermediate tutorial
Independent tutorial
Build databases
π
Enable timezone-independent date
Manage databases
Import and export
Duplicate database
Scripting
π
Script editor features
Functions overview
Functions categorized
Array
Date and time
Format and convert data
Mathematical
Text
User management
Functions alphabetically
Appendix
Manage account
Create account
Book subscription
Calculate required licenses
Add licenses
Manage licenses
Invite collaborators
Ninox Mac app and iCloud
API
Introduction
HTTP function
Public Cloud APIs
Private Cloud APIs
Private Cloud / On-Premises
Single sign-on (SSO)
Windows Server installation
Docker installation
Sample configuration file
Resources
π
Release notes
π©πͺ
Ninox Documentation (German)
π
Glossary
π΅
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
Format and convert data
In the following you'll find functions, that help you to format and convert data types
β
appointment
β
To convert given time-related values to an appointment
β
array
β
To create a new array by merging 2 arrays of a similar type
β
date
β
To convert to or return a date value
β
datetime
β
To convert to or return a timestamp
β
email
β
To convert a given value to an email value
β
format
β
To format a given value
β
formatJSON
β
To create a JSON string of a valid JSON object
β
formatXML
β
To convert a given JSON object into XML text, which might be optically structured
β
html
β
To return a rich text representation of any value
β
lower
β
To return a string in lower case
β
monthIndex
β
To return a given month as a number out of a string
β
monthName
β
To return the full month name of a given date value
β
number
β
To convert a given value to a number
β
parseJSON
β
To convert a JSON string to a JSON object
β
parseXML
β
To convert an XML string to a JSON object
β
phone
β
To convert a number or string to a phone value
β
string
β
To convert a given value to a string
β
styled
β
To convert a given string to a styled object
β
text
β
To convert a value to a string and possibly reflect the format options
β
timeinterval
β
To convert a given time-related value to a time interval, i.e. a duration
β
timestamp
β
To convert a given time-related value to a timestamp
β
upper
β
To return a string in the upper case
β
url
β
To convert a string to a link
β
Previous
Date and time
Next
Mathematical
Last modified
1mo ago
Export as PDF
Copy link
Contents
appointment
array
date
datetime
email
format
formatJSON
formatXML
html
lower
monthIndex
monthName
number
parseJSON
parseXML
phone
string
styled
text
timeinterval
timestamp
upper
url