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

📖ClearLines Functions

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

  • BINTODEC

  • BINTOHEX

  • CALLURL

  • CELL

  • CELLREF

  • CHAR

  • CLEAR

  • CLICK

  • CLOSE

  • CODE

  • COLUMN

  • COLUMNS

  • COMBINE

  • CONVERT

  • COS

  • COT

  • COUNT

  • CREATEDATE

  • CREATEMEMBER

  • CSVTORANGE

  • CUMULATE

  • DATE

  • DATETOTEXT

  • DAY

  • DECTOBIN

  • DECTOHEX

  • DELETEFILE

  • DIFF

  • DOWNLOAD

  • DOWNLOADEXCEL

  • DOWNLOADFILE

  • DOWNLOADPDF

  • EMPTY

  • EXCELCREATE

  • EXECUTE

  • EXP

  • FILTER

  • FIND

  • GETDATA

  • GETDBCOLUMNNAMES

  • GETFILELIST

  • GETPAGES

  • GETSELECTION

  • GETSTATEMENT

  • GETTIMEZONEOFFSET

  • GETTYPE

  • GETURLPARAM

  • HASH

  • HEXTOBIN

  • HEXTODEC

  • HIDDENTEXT

  • HOUR

  • IF

  • INSERTDATA

  • INSERTRANGE

  • INTERSECTION

  • ISEMPTY

  • JSONTORANGE

  • LEFT

  • LEN

  • LN

  • LOADWIDGETCONTENT

  • LOG

  • LOOKUP

  • LOOP

  • LOWER

  • MAX

  • MESSAGE

  • MID

  • MILLISECOND

  • MIN

  • MINUTE

  • MOD

  • MONTH

  • MROUND

  • NAME

  • NOT

  • NOW

  • 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

  • SIN

  • SORT

  • SQRT

  • STOREWIDGETCONTENT

  • SUBSTITUTE

  • SUM

  • TAN

  • TEXT

  • TODAY

  • TRANSPOSE

  • TRIM

  • UNIQUE

  • UNPIVOT

  • UPDATE

  • UPDATEUSER

  • UPLOAD

  • UPLOADFILE

  • UPPER

  • USERLIST

  • USERNAME

  • VISIBLEHIERARCHY

  • WEEKDAY

  • YEAR

Last updated 23 days ago