LogoLogo
Version 1.66
Version 1.66
  • nedyx
  • Welcome to nedyx
  • 🚀Getting started
    • Preparation
    • Basic widget formatting
    • The first formula
    • More formulas
    • Combine several tables
    • Add a new page
    • Widget references across pages
    • Add a chart widget
    • Further adjustments
  • 🖊️Working with nedyx
    • Apps
    • Live and Edit mode
    • The Header bar
    • The Navigation tab
    • Pages
    • Widgets
      • Widget types
      • Adding widgets
      • Widget selection
      • Widget positioning
      • Style tab
      • Settings tab
      • Cell styles
      • Chart content
      • Chart properties
      • Undo / redo
    • Databases
      • Connect to a database
      • Get external data
    • File management
  • 📖ClearLines Functions
    • General Aspects
      • Formula structure
      • The formula editor
      • Actions
      • Calculated widget properties
        • Content
        • Chart labels
        • Column widths and Row heights
        • Connection
        • Editable
        • MinY and MaxY
        • Style
        • Tooltips
        • Visible
      • Calculated page properties
        • Visible (for pages)
      • Ranges
      • Widget references
      • Menu selection references
      • Cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • INSERTDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • NOW
      • SECOND
      • TODAY
      • WEEKDAY
      • YEAR
    • Import / export functions
      • DOWNLOAD
      • DELETEFILE
      • DOWNLOADEXCEL
      • DOWNLOADFILE
      • DOWNLOADPDF
      • EXCELCREATE
      • GETFILELIST
      • PDFCREATE
      • POSTMESSAGE
      • SCANCODE
      • SENDEMAIL
      • UPLOAD
      • UPLOADFILE
    • Logical functions
      • AND
      • IF
      • ISEMPTY
      • ISUSERACTION
      • LOOP
      • NOT
      • OR
    • Mathematical functions
      • ABS
      • BINTODEC
      • BINTOHEX
      • COS
      • COT
      • DECTOBIN
      • DECTOHEX
      • EXP
      • HEXTOBIN
      • HEXTODEC
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SIN
      • SQRT
      • SUM
      • TAN
    • Navigation functions
      • CLOSE
      • GETPAGES
      • GETURLPARAM
      • MESSAGE
      • OPEN
      • OPENWEBPAGE
      • PAGE
      • QUESTION
    • Range functions
      • AGGREGATE
      • CELL
      • CELLREF
      • CLEAR
      • COLUMN
      • COLUMNS
      • COMBINE
      • CONVERT
      • COUNT
      • CSVTORANGE
      • CUMULATE
      • DIFF
      • EMPTY
      • FILTER
      • GETTYPE
      • INSERTRANGE
      • INTERSECTION
      • LOOKUP
      • PIVOT
      • RANGE
      • RANGETOCSV
      • RANGETOHIERARCHY
      • RANGETOROW
      • RANGETOJSON
      • JSONTORANGE
      • ROW
      • ROWS
      • ROWTORANGE
      • SEQUENCE
      • SORT
      • TRANSPOSE
      • UNIQUE
      • UNPIVOT
      • VISIBLEHIERARCHY
    • Text functions
      • CHAR
      • CODE
      • CREATEMEMBER
      • FIND
      • HASH
      • HIDDENTEXT
      • HTMLTOJSONTEXT
      • LEFT
      • LEN
      • LOWER
      • MID
      • RIGHT
      • SUBSTITUTE
      • TEXT
      • TRIM
      • UPPER
    • User management functions
      • APPLIST
      • ADDUSER
      • APPSHARELIST
      • REMOVEUSER
      • SHAREAPP
      • UPDATEUSER
      • USERLIST
      • USERNAME
    • Widget functions
      • GETSELECTION
      • LOADWIDGETCONTENT
      • NAME
      • SETSELECTION
      • STOREWIDGETCONTENT
      • UPDATE
  • 🔐Security
    • User Management
      • Workspaces
      • Workspace Roles
      • Adding Users to a Workspace
      • App Roles
      • Share an App with Other Users
      • Guest Access
      • Change Password
  • Appendix
    • Keyboard shortcuts
    • Error handling
    • Feature preview
    • Supported browsers
    • System requirements for on-premises installations
Powered by GitBook
On this page
  1. ClearLines Functions

Database functions

📖
CALLURL
EXECUTE
GETDATA
INSERTDATA
GETDBCOLUMNNAMES
GETSTATEMENT