LogoLogo
Version 1.56
Version 1.56
  • 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
    • 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
      • Ranges
      • Widget references
      • Widget cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • 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
      • DECTOHEX
      • EXP
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SQRT
      • SUM
    • 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
      • 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

ClearLines Functions

Last updated 3 months ago

ClearLines is the name of the language which is used by nedyx to define data calculations, navigation, import / export, database access, and others, following Low Code principles.

Here is a complete alphabetical list of all ClearLines functions.

📖
ABS
ACTIONCOLUMN
ACTIONCONTENT
ACTIONROW
ADDUSER
AGGREGATE
AND
APPLIST
APPSHARELIST
CALLURL
CELL
CELLREF
CHAR
CLEAR
CLICK
CLOSE
CODE
COLUMN
COLUMNS
COMBINE
CONVERT
COUNT
CREATEDATE
CREATEMEMBER
CSVTORANGE
CUMULATE
DATE
DATETOTEXT
DAY
DELETEFILE
DECTOHEX
DIFF
DOWNLOAD
DOWNLOADEXCEL
DOWNLOADFILE
DOWNLOADPDF
EMPTY
EXCELCREATE
EXECUTE
EXP
FILTER
FIND
GETDATA
GETDBCOLUMNNAMES
GETFILELIST
GETPAGES
GETSELECTION
GETSTATEMENT
GETTIMEZONEOFFSET
GETTYPE
GETURLPARAM
HIDDENTEXT
HOUR
IF
INSERTRANGE
INTERSECTION
ISEMPTY
JSONTORANGE
LEFT
LEN
LN
LOADWIDGETCONTENT
LOG
LOOKUP
LOOP
LOWER
MAX
MESSAGE
MID
MILLISECOND
MIN
MINUTE
MOD
MONTH
MROUND
NAME
NOT
NUMBER
OPEN
OPENWEBPAGE
OR
PAGE
PDFCREATE
PI
PIVOT
POSTMESSAGE
QUESTION
RAND
RANGE
RANGETOCSV
RANGETOHIERARCHY
RANGETOJSON
RANGETOROW
REMOVEUSER
RIGHT
ROUND
ROW
ROWS
ROWTORANGE
SCANCODE
SECOND
SENDEMAIL
SEQUENCE
SETSELECTION
SHAREAPP
SORT
SQRT
STOREWIDGETCONTENT
SUBSTITUTE
SUM
TEXT
TODAY
TRANSPOSE
TRIM
UNIQUE
UNPIVOT
UPDATE
UPDATEUSER
UPLOAD
UPLOADFILE
UPPER
USERLIST
USERNAME
VISIBLEHIERARCHY
WEEKDAY
YEAR