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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.nedyx.com/nedyx/clearlines-functions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.