> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.52-preview/clearlines-functions.md).

# 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.&#x20;

Here is a complete alphabetical list of all ClearLines functions.

* [ABS](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/abs.md)
* [ACTIONCOLUMN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/action-functions/actioncolumn.md)
* [ACTIONCONTENT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/action-functions/actioncontent.md)
* [ACTIONROW](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/action-functions/actionrow.md)
* [ADDUSER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/adduser.md)
* [AGGREGATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/aggregate.md)
* [AND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/and.md)
* [APPLIST](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/applist.md)
* [APPSHARELIST](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/appsharelist.md)
* [CALLURL](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/callurl.md)
* [CELL](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cell.md)
* [CELLREF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cellref.md)
* [CHAR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/char.md)
* [CLEAR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/clear.md)
* [CLICK](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/action-functions/click.md)
* [CLOSE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/close.md)
* [CODE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/code.md)
* [COLUMN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/column.md)
* [COLUMNS](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/columns.md)
* [COMBINE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/combine.md)
* [CONVERT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/convert.md)
* [COUNT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/count.md)
* [CREATEDATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/createdate.md)
* [CREATEMEMBER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/createmember.md)
* [CSVTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/csvtorange.md)
* [CUMULATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/cumulate.md)
* [DATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/date.md)
* [DATETOTEXT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/datetotext.md)
* [DAY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/day.md)
* [DELETEFILE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/deletefile.md)
* [DECTOHEX](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/dectohex.md)
* [DIFF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/diff.md)
* [DOWNLOAD](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/download.md)
* [DOWNLOADEXCEL](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/downloadexcel.md)
* [DOWNLOADFILE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/downloadfile.md)
* [DOWNLOADPDF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/downloadpdf.md)
* [EMPTY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/empty.md)
* [EXCELCREATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/excelcreate.md)
* [EXECUTE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/execute.md)
* [EXP](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/exp.md)
* [FILTER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/filter.md)
* [FIND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/find.md)
* [GETDATA](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/getdata.md)
* [GETDBCOLUMNNAMES](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/getdbcolumnnames.md)
* [GETFILELIST](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/getfilelist.md)
* [GETPAGES](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/getpages.md)
* [GETSELECTION](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/getselection.md)
* [GETSTATEMENT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/getstatement.md)
* [GETTIMEZONEOFFSET](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/gettimezoneoffset.md)
* [GETTYPE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/gettype.md)
* [GETURLPARAM](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/geturlparam.md)
* [HIDDENTEXT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/hiddentext.md)
* [HOUR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/hour.md)
* [IF](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/if.md)
* [INSERTRANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/insertrange.md)
* [INTERSECTION](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/intersection.md)
* [ISEMPTY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/isempty.md)
* [JSONTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/jsontorange.md)
* [LEFT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/left.md)
* [LEN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/len.md)
* [LN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/ln.md)
* [LOADWIDGETCONTENT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/loadwidgetcontent.md)
* [LOG](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/log.md)
* [LOOKUP](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/lookup.md)
* [LOOP](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/loop.md)
* [LOWER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/lower.md)
* [MAX](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/max.md)
* [MESSAGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/message.md)
* [MID](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/mid.md)
* [MILLISECOND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/millisecond.md)
* [MIN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/min.md)
* [MINUTE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/minute.md)
* [MOD](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/mod.md)
* [MONTH](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/month.md)
* [MROUND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/mround.md)
* [NAME](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/name.md)
* [NOT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/not.md)
* [NUMBER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/number.md)
* [OPEN](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/open.md)
* [OPENWEBPAGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/openwebpage.md)
* [OR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/logical-functions/or.md)
* [PAGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/page.md)
* [PDFCREATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/pdfcreate.md)
* [PI](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/pi.md)
* [PIVOT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/pivot.md)
* [POSTMESSAGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/postmessage.md)
* [QUESTION](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/navigation-functions/question.md)
* [RAND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/rand.md)
* [RANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/range.md)
* [RANGETOCSV](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetocsv.md)
* [RANGETOHIERARCHY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetohierarchy.md)
* [RANGETOJSON](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetojson.md)
* [RANGETOROW](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rangetorow.md)
* [REMOVEUSER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/removeuser.md)
* [RIGHT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/right.md)
* [ROUND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/round.md)
* [ROW](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/row.md)
* [ROWS](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rows.md)
* [ROWTORANGE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/rowtorange.md)
* [SCANCODE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/scancode.md)
* [SECOND](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/second.md)
* [SENDEMAIL](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/sendemail.md)
* [SEQUENCE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/sequence.md)
* [SETSELECTION](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/setselection.md)
* [SHAREAPP](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/shareapp.md)
* [SORT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/sort.md)
* [SQRT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/sqrt.md)
* [STOREWIDGETCONTENT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/storewidgetcontent.md)
* [SUBSTITUTE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/substitute.md)
* [SUM](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/mathematical-functions/sum.md)
* [TEXT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/text.md)
* [TODAY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/today.md)
* [TRANSPOSE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/transpose.md)
* [TRIM](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/trim.md)
* [UNIQUE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/unique.md)
* [UNPIVOT](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/unpivot.md)
* [UPDATE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/widget-functions/update.md)
* [UPDATEUSER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/updateuser.md)
* [UPLOAD](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/upload.md)
* [UPLOADFILE](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/import-export-functions/uploadfile.md)
* [UPPER](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/upper.md)
* [USERLIST](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/userlist.md)
* [USERNAME](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/user-management-functions/username.md)
* [VISIBLEHIERARCHY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/visiblehierarchy.md)
* [WEEKDAY](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/weekday.md)
* [YEAR](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/date-functions/year.md)
