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