LogoLogo
Ninox websiteForum
Ninox websiteForum
  • Welcome
  • Step by step
    • Introduction
      • What is an application?
      • Databases and tables
      • Forms and views
    • Basics
      • Creating a database
      • Using templates
      • Adding a table
      • Adding and naming fields
      • Editing after saving changes
      • Customizing data fields
      • Extra: Display options in the Choice field
      • Deleting tables
      • Customizing forms
      • Edit mode
      • Entering data
      • Row numbers and IDs
      • Showing or hiding table columns
      • Sorting and filtering
      • Different views
      • Working together on databases
      • Tips
    • Intermediate tutorial
    • Independent tutorial
    • Tours
  • Build databases
    • Enable timezone-independent date
  • Manage databases
    • Modularity
      • do as database ... end
      • Reconnect modularized databases
    • Mailhook
    • Pages
    • Import and export
      • CSV import
      • Export database
    • Duplicate database
    • Defragment database
    • Process monitor
  • Print
    • Print customization
      • Introduction to dynamic print layouts
      • Create a template
      • Create and render a report
        • Upload a template
          • Option A: without a custom script
          • Option B: with a custom script
        • Example: invoice PDF
      • Password encryption
      • Test print with watermark
      • Substitutions
        • Basic
        • Access sub-objects
        • Access arrays
        • Array filters
        • Filter to the last element
        • Filter and print parent
        • Multiple array filters
        • Alias
        • Parametrized alias
      • Repetitions
        • Simple array
        • Nested arrays
        • Bi-directional loop
        • Sorting
        • Distinct items
        • Iterate on multiple items
        • Filters
        • Iterate over objects
        • Access the loop iterator value
      • Formatters
        • Dynamic parameters
        • String manipulation
        • Number manipulation
        • Array manipulation
        • Conditioned output
        • Date manipulation
      • Aggregators
        • aggSum
        • aggAvg
        • aggMin
        • aggMax
        • aggCount
        • aggCumSum
      • Charts
        • Native charts
          • Create dynamic charts in Microsoft Word
          • Create dynamic reports in LibreOffice
        • ECharts 5 charts
          • Insert a line chart into a document
      • Colors
        • Color examples
        • Color formats
        • Microsoft Word exception
        • Color in table
      • Hyperlinks
        • defaultURL formatter
      • Barcodes
        • Barcodes as image
      • Pictures
        • Picture from a public URL
        • Picture from a base64 Data URI
        • Picture from a Base64
        • Picture example – Word document
      • HTML
        • Example 1
        • Example 2
      • Troubleshooting
  • Scripting
    • Introduction to Ninox script
      • The formula editor
        • Formula editor features
      • Simple operators
        • Arithmetic operators
        • Comparison operators
        • Ninox operators
        • Writing dynamic texts
      • Declare variable
      • Set conditional statement
        • Set multiple conditional statements
      • Select and query specific records
      • Create and delete records
        • Creatable if and Deletable if
      • Sort records
      • Repeat conditional statements with loops
      • Create your own functions
      • Optimize performance of scripts
    • Functions overview
      • Functions—by category
        • Array
        • Database operations
        • Date and time
        • Files and printing
        • Format and convert data
        • Mathematical
        • Text
        • User interface
        • User management
        • Web integration and API
      • Functions—alphabetically
        • abs
        • acos
        • age
        • alert
        • appendTempFile
        • appointment
        • array
        • asin
        • atan
        • atan2
        • avg
        • barcodeScan
        • cached
        • capitalize
        • ceil
        • chosen
        • clientLang
        • closeAllRecords
        • closeFullscreen
        • closeRecord
        • color
        • concat
        • contains
        • cos
        • count (aka cnt)
        • createCalendarEvent
        • createCalendarReminder
        • createTempFile
        • createTextFile
        • createXLSX
        • createZipFile
        • databaseId
        • date
        • datetime
        • day
        • days
        • degrees
        • dialog
        • duplicate
        • duration
        • email
        • endof
        • even
        • exp
        • extractx
        • fieldId
        • file
        • fileMetadata
        • files
        • first
        • floor
        • format
        • formatJSON
        • formatXML
        • get
        • html
        • http
        • icon
        • importFile
        • index
        • invalidate
        • isAdminMode
        • isDatabaseLocked
        • isDatabaseProtected
        • item
        • join
        • last
        • latitude
        • length
        • ln
        • loadFileAsBase64
        • loadFileAsBase64URL
        • location
        • log
        • longitude
        • lower
        • lpad
        • max
        • min
        • month
        • monthIndex
        • monthName
        • ninoxApp
        • now
        • number
        • numbers
        • odd
        • openFullscreen
        • openPage
        • openPrintLayout
        • openRecord
        • openTable
        • openURL
        • parseCSV
        • parseJSON
        • parseXML
        • phone
        • popupRecord
        • pow
        • printAndSaveRecord
        • printRecord
        • printTable
        • quarter
        • queryConnection
        • radians
        • random
        • range
        • raw
        • record
        • removeFile
        • removeItem
        • renameFile
        • replace
        • replacex
        • round
        • rpad
        • rsort
        • sendCommand
        • sendEmail
        • set
        • setItem
        • 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
        • validateXML
        • waitForSync
        • week
        • weekday
        • weekdayIndex
        • weekdayName
        • workdays
        • year
        • yearmonth
        • yearquarter
        • yearweek
    • Fields
    • Ninox languages
    • Date and time formats
    • Icon picker
    • Color picker
    • About "any"
    • Automatic adjustments
    • Transactions
      • Read transactions
      • Write transactions
      • Execution context
  • Use cases
    • Tips and tricks for fast databases
    • Automatic invoice number
  • API
    • Introduction to Ninox API
      • Tables, fields, and records
    • API calls in Ninox script
    • Private Cloud APIs
    • Public Cloud APIs
  • Private Cloud / On-Premises
    • Single sign-on (SSO)
      • Introduction to SSO
      • SAML SSO with Okta
      • SAML SSO with Azure AD
      • OIDC SSO with Okta
    • Windows Server installation
    • Docker installation
    • 🆕On-Premises setup guide
    • Sample configuration file
    • SQL Server integration
      • Introduction to SQL Server Connectors
      • Set up an SQL connection in Ninox
  • 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
      • iPhone app will be switched off
  • Resources
    • Release notes
      • Beta release notes
      • Older release notes
    • Glossary
  • Ninox documentation (German)
  • Related Links
  • Ninox website
  • Community
  • Webinars
  • Pricing
  • Contact us
  • Imprint
  • Privacy policy
Powered by GitBook