# 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](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/abs)
* [ACTIONCOLUMN](https://docs.nedyx.com/nedyx/clearlines-functions/action-functions/actioncolumn)
* [ACTIONCONTENT](https://docs.nedyx.com/nedyx/clearlines-functions/action-functions/actioncontent)
* [ACTIONROW](https://docs.nedyx.com/nedyx/clearlines-functions/action-functions/actionrow)
* [ADDUSER](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/adduser)
* [AGGREGATE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/aggregate)
* [AND](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/and)
* [APPLIST](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/applist)
* [APPMODE](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/appmode)
* [APPNAME](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/appname)
* [APPSHARELIST](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/appsharelist)
* [BINTODEC](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/bintodec)
* [BINTOHEX](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/bintohex)
* [CALLURL](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/callurl)
* [CELL](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/cell)
* [CELLREF](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/cellref)
* [CHAR](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/char)
* [CLEAR](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/clear)
* [CLICK](https://docs.nedyx.com/nedyx/clearlines-functions/action-functions/click)
* [CLOSE](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/close)
* [CODE](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/code)
* [COLUMN](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/column)
* [COLUMNS](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/columns)
* [COMBINE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/combine)
* [CONVERT](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/convert)
* [COPY](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/copy)
* [COS](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/cos)
* [COT](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/cot)
* [COUNT](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/count)
* [CREATEDATE](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/createdate)
* [CREATEMEMBER](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/createmember)
* [CROSSJOIN](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/crossjoin)
* [CSVTORANGE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/csvtorange)
* [CUMULATE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/cumulate)
* [DATE](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/date)
* [DATETOTEXT](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/datetotext)
* [DAY](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/day)
* [DECTOBIN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/dectobin)
* [DECTOHEX](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/dectohex)
* [DELETEFILE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/deletefile)
* [DIFF](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/diff)
* [DOWNLOAD](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/download)
* [DOWNLOADEXCEL](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/downloadexcel)
* [DOWNLOADFILE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/downloadfile)
* [DOWNLOADPDF](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/downloadpdf)
* [EMPTY](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/empty)
* [EXCELCREATE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/excelcreate)
* [EXECUTE](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/execute)
* [EXP](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/exp)
* [FILTER](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/filter)
* [FIND](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/find)
* [FLIPCELLS](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/flipcells)
* [GETDATA](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/getdata)
* [GETDBCOLUMNNAMES](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/getdbcolumnnames)
* [GETFILELIST](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/getfilelist)
* [GETPAGES](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/getpages)
* [GETSELECTION](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/getselection)
* [GETSTATEMENT](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/getstatement)
* [GETTIMEZONEOFFSET](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/gettimezoneoffset)
* [GETTYPE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/gettype)
* [GETURLPARAM](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/geturlparam)
* [HASH](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/hash)
* [HEXTOBIN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/hextobin)
* [HEXTODEC](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/hextodec)
* [HIDDENTEXT](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/hiddentext)
* [HOUR](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/hour)
* [HTMLTOJSONTEXT](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/htmltojsontext)
* [IF](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/if)
* [INSERTDATA](https://docs.nedyx.com/nedyx/clearlines-functions/database-functions/insertdata)
* [INSERTRANGE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/insertrange)
* [INTERSECTION](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/intersection)
* [ISEMPTY](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/isempty)
* [ISUSERACTION](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/isuseraction)
* [JSONTEXTTOHTML](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/jsontexttohtml)
* [JSONTORANGE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/jsontorange)
* [LEFT](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/left)
* [LEN](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/len)
* [LEVEL](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/level)
* [LN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/ln)
* [LOADWIDGETCONTENT](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/loadwidgetcontent)
* [LOG](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/log)
* [LOOKUP](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/lookup)
* [LOOP](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/loop)
* [LOWER](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/lower)
* [MAX](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/max)
* [MESSAGE](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/message)
* [MID](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/mid)
* [MILLISECOND](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/millisecond)
* [MIN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/min)
* [MINUTE](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/minute)
* [MOD](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/mod)
* [MONTH](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/month)
* [MOVECELLS](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/movecells)
* [MROUND](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/mround)
* [NAME](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/name)
* [NOT](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/not)
* [NOW](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/now)
* [NUMBER](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/number)
* [OPEN](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/open)
* [OPENWEBPAGE](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/openwebpage)
* [OR](https://docs.nedyx.com/nedyx/clearlines-functions/logical-functions/or)
* [PAGE](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/page)
* [PDFCREATE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/pdfcreate)
* [PI](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/pi)
* [PIVOT](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/pivot)
* [POSTMESSAGE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/postmessage)
* [QUESTION](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/question)
* [RAND](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/rand)
* [RANGE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/range)
* [RANGETOCSV](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rangetocsv)
* [RANGETOHIERARCHY](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rangetohierarchy)
* [RANGETOJSON](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rangetojson)
* [RANGETOROW](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rangetorow)
* [REMOVEUSER](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/removeuser)
* [RIGHT](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/right)
* [ROUND](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/round)
* [ROW](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/row)
* [ROWS](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rows)
* [ROWTORANGE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/rowtorange)
* [SCANCODE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/scancode)
* [SECOND](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/second)
* [SENDEMAIL](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/sendemail)
* [SEQUENCE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/sequence)
* [SETSCROLLPOSITION](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/setscrollposition)
* [SHAREAPP](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/shareapp)
* [SIN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/sin)
* [SORT](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/sort)
* [SQRT](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/sqrt)
* [STARTTIMER](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/starttimer)
* [STOPTIMER](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/stoptimer)
* [STOREWIDGETCONTENT](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/storewidgetcontent)
* [SUBSTITUTE](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/substitute)
* [SUM](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/sum)
* [SWITCH](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/switch)
* [TAN](https://docs.nedyx.com/nedyx/clearlines-functions/mathematical-functions/tan)
* [TEXT](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/text)
* [TIMERLIST](https://docs.nedyx.com/nedyx/clearlines-functions/navigation-functions/timerlist)
* [TODAY](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/today)
* [TRANSPOSE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/transpose)
* [TRIM](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/trim)
* [TRIMCELLS](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/trimcells)
* [UNIQUE](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/unique)
* [UNPIVOT](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/unpivot)
* [UPDATE](https://docs.nedyx.com/nedyx/clearlines-functions/widget-functions/update)
* [UPDATEUSER](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/updateuser)
* [UPLOAD](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/upload)
* [UPLOADFILE](https://docs.nedyx.com/nedyx/clearlines-functions/import-export-functions/uploadfile)
* [UPPER](https://docs.nedyx.com/nedyx/clearlines-functions/text-functions/upper)
* [USERLIST](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/userlist)
* [USERNAME](https://docs.nedyx.com/nedyx/clearlines-functions/user-management-functions/username)
* [VISIBLEHIERARCHY](https://docs.nedyx.com/nedyx/clearlines-functions/range-functions/visiblehierarchy)
* [WEEKDAY](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/weekday)
* [YEAR](https://docs.nedyx.com/nedyx/clearlines-functions/date-functions/year)