> 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.66/nedyx.md).

# nedyx

- [Welcome to nedyx](https://docs.nedyx.com/version-1.66/nedyx/readme.md): nedyx is the modern low code platform for rapid business app building with an intuitive, easy-to-learn user interface and the ability to cover requirements of any complexity.
- [Getting started](https://docs.nedyx.com/version-1.66/nedyx/getting-started.md)
- [Preparation](https://docs.nedyx.com/version-1.66/nedyx/getting-started/preparation.md)
- [Basic widget formatting](https://docs.nedyx.com/version-1.66/nedyx/getting-started/basic-widget-formatting.md)
- [The first formula](https://docs.nedyx.com/version-1.66/nedyx/getting-started/the-first-formula.md)
- [More formulas](https://docs.nedyx.com/version-1.66/nedyx/getting-started/more-formulas.md)
- [Combine several tables](https://docs.nedyx.com/version-1.66/nedyx/getting-started/combine-several-tables.md)
- [Add a new page](https://docs.nedyx.com/version-1.66/nedyx/getting-started/add-a-new-page.md)
- [Widget references across pages](https://docs.nedyx.com/version-1.66/nedyx/getting-started/widget-references-across-pages.md)
- [Add a chart widget](https://docs.nedyx.com/version-1.66/nedyx/getting-started/add-a-chart-widget.md)
- [Further adjustments](https://docs.nedyx.com/version-1.66/nedyx/getting-started/further-adjustments.md)
- [Working with nedyx](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx.md)
- [Apps](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/apps.md)
- [Live and Edit mode](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/live-and-edit-mode.md)
- [The Header bar](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/the-header-bar.md)
- [The Navigation tab](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/the-navigation-tab.md)
- [Other areas](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/other-areas.md)
- [Pages](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/pages.md)
- [Widgets](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets.md)
- [Widget types](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/widget-types.md): There are different types and subtypes of widgets.
- [Adding widgets](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/adding-widgets.md)
- [Widget selection](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/widget-selection.md)
- [Widget positioning](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/widget-positioning.md)
- [Style tab](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/style-tab.md)
- [Settings tab](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/settings-tab.md)
- [Cell styles](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/cell-styles.md)
- [Chart content](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/chart-content.md)
- [Chart properties](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/chart-properties.md)
- [Undo / redo](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/widgets/undo-redo.md)
- [Databases](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/databases.md)
- [Connect to a database](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/databases/connect-to-a-database.md)
- [Get external data](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/databases/get-external-data.md)
- [File management](https://docs.nedyx.com/version-1.66/nedyx/working-with-nedyx/file-management.md)
- [ClearLines Functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions.md)
- [General Aspects](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects.md)
- [Formula structure](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/formula-structure.md): ClearLines formulas consist of the following elements.
- [The formula editor](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/the-formula-editor.md)
- [Actions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/actions.md)
- [Calculated widget properties](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties.md): Properties can be used to define and change the appearance and behavior of widgets.
- [Content](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/content.md)
- [Chart labels](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/chart-labels.md)
- [Column widths and Row heights](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/column-widths-and-row-heights.md)
- [Connection](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/connection.md)
- [Editable](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/editable.md)
- [MinY and MaxY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/miny-and-maxy.md)
- [Style](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/style.md)
- [Tooltips](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/tooltips.md)
- [Visible](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-widget-properties/visible.md)
- [Calculated page properties](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-page-properties.md)
- [Visible (for pages)](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/calculated-page-properties/visible-for-pages.md)
- [Ranges](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/ranges.md)
- [Widget references](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/widget-references.md)
- [Menu selection references](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/menu-selection-references.md)
- [Cell references](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/cell-references.md)
- [Menu widget synchronization](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/general-aspects/menu-widget-synchronization.md)
- [Action functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/action-functions.md)
- [ACTIONCOLUMN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/action-functions/actioncolumn.md): Returns the index of the column, which was selected before or after the current action.
- [ACTIONCONTENT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/action-functions/actioncontent.md): Returns the content of the cell, which was selected before or after the current action.
- [ACTIONROW](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/action-functions/actionrow.md): Returns the index of the row, which was selected before or after the current action.
- [CLICK](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/action-functions/click.md): Executes the Click action of a button widget.
- [Database functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions.md)
- [CALLURL](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/callurl.md): Returns the result of an http-based url request.
- [EXECUTE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/execute.md): Executes a statement for a data connector.
- [GETDATA](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/getdata.md): Retrieves data from a data connector.
- [GETDBCOLUMNNAMES](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/getdbcolumnnames.md): Returns the names of db columns from a widget.
- [GETSTATEMENT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/getstatement.md): Returns the statement (SQL, MDX or REST URI) as defined in the Connection tab.
- [INSERTDATA](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/database-functions/insertdata.md): Writes data back to a data source.
- [Date functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions.md)
- [CREATEDATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/createdate.md): Returns a date, defined by year, month and day.
- [DATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/date.md): Converts a value into value type “date”.
- [DATETOTEXT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/datetotext.md): Converts a datetime value into a text with a user-defined format.
- [DAY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/day.md): Returns the day of a date.
- [GETTIMEZONEOFFSET](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/gettimezoneoffset.md): Returns the difference in hours between the local and the UTC time.
- [HOUR](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/hour.md): Returns the hour of a datetime value.
- [MILLISECOND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/millisecond.md): Returns the millisecond of a datetime value.
- [MINUTE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/minute.md): Returns the minute of a datetime value.
- [MONTH](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/month.md): Returns the month of a date.
- [NOW](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/now.md): Returns the current date and time.
- [SECOND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/second.md): Returns the second of a datetime value.
- [TODAY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/today.md): Returns the date of the current day.
- [WEEKDAY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/weekday.md): Returns the weekday of a date as a number.
- [YEAR](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/date-functions/year.md): Returns the year of a date.
- [Import / export functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions.md)
- [DOWNLOAD](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/download.md): Downloads a text as a file to the local client computer.
- [DELETEFILE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/deletefile.md): Deletes a file on the nedyx server.
- [DOWNLOADEXCEL](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/downloadexcel.md): Creates an Excel file with the content of a table widget and downloads it.
- [DOWNLOADFILE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/downloadfile.md): Downloads a file to the local client computer.
- [DOWNLOADPDF](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/downloadpdf.md): Creates and downloads a pdf file with a selection of app pages.
- [EXCELCREATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/excelcreate.md): Creates an Excel file on the nedyx server with the content of a table widget.
- [GETFILELIST](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/getfilelist.md): Returns a range containing all files which have been uploaded or created in the current nedyx workspace.
- [PDFCREATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/pdfcreate.md): Creates a pdf file with a selection of app pages.
- [POSTMESSAGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/postmessage.md): Sends a message to current browser page.
- [SCANCODE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/scancode.md): Scans a QR or bar code and returns its content as a text.
- [SENDEMAIL](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/sendemail.md): Sends an email to one or more recipients.
- [UPLOAD](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/upload.md): Uploads the content of a file from the local client computer into a widget.
- [UPLOADFILE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/import-export-functions/uploadfile.md): Uploads a file from the local client computer to the nedyx server.
- [Logical functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions.md)
- [AND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/and.md): Returns true, if all parameters are true, otherwise false.
- [IF](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/if.md): Evaluates an expression if a corresponding condition is true.
- [ISEMPTY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/isempty.md): Returns true if a value is of type empty or an empty text (““) , otherwise false.
- [ISUSERACTION](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/isuseraction.md): Returns true, if the function is called in a formula of the widget, where the user has performed the current action.
- [LOOP](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/loop.md): Executes an expression until a condition is met.
- [NOT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/not.md): Returns true, if the parameter is false, otherwise false.
- [OR](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/logical-functions/or.md): Returns true, if at least one of the parameters is true, otherwise false
- [Mathematical functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions.md)
- [ABS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/abs.md): Returns the absolute value of a number.
- [BINTODEC](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/bintodec.md): Returns a decimal number from a binary value.
- [BINTOHEX](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/bintohex.md): Returns the hexidecimal representation of a binary value.
- [COS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/cos.md): Returns the cosine of a given angle.
- [COT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/cot.md): Returns the cotangent of a given angle.
- [DECTOBIN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/dectobin.md): Returns the binary representation of a decimal number.
- [DECTOHEX](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/dectohex.md): Returns the hexidecimal representation of a number.
- [EXP](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/exp.md): Returns Euler's number e (2.7182...) raised by an exponent.
- [HEXTOBIN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/hextobin.md): Returns a binary value from a hexadecimal value.
- [HEXTODEC](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/hextodec.md): Returns a decimal number from a hexadecimal value.
- [LN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/ln.md): Returns the "natural logarithm" of a number, base e (Euler’s number 2.7182...).
- [LOG](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/log.md): Returns the logarithm to a specified base.
- [MAX](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/max.md): Returns the maximum of numers in a range.
- [MIN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/min.md): Returns the minimum of numers in a range.
- [MOD](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/mod.md): Returns the remainder after dividing a number by another number.
- [MROUND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/mround.md): Rundet eine Zahl auf das nächste Vielfache einer anderen Zahl.
- [NUMBER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/number.md): Converts a value into value type “number”.
- [PI](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/pi.md): Returns PI, as number 3.1415926....
- [RAND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/rand.md): Returns a random number.
- [ROUND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/round.md): Rounds a number to a defined number of digits.
- [SIN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/sin.md): Returns the sine of a given angle.
- [SQRT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/sqrt.md): Returns the square root of a number.
- [SUM](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/sum.md): Returns the sum of numers in a range.
- [TAN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/mathematical-functions/tan.md): Returns the tangent of a given angle.
- [Navigation functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions.md)
- [APPMODE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/appmode.md): Returns the current mode of the app.
- [APPNAME](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/appname.md): Returns the name of the current app.
- [CLOSE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/close.md): Closes the current page.
- [GETPAGES](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/getpages.md): Returns a range with information about the pages of the navigation tab.
- [GETURLPARAM](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/geturlparam.md): Returns the value of a key from the current web page url.
- [MESSAGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/message.md): Shows a text in a message window.
- [OPEN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/open.md): Opens a page
- [OPENWEBPAGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/openwebpage.md): Opens a web page based on a url.
- [PAGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/page.md): Returns the name of the previous page, which is helpful for popup pages.
- [QUESTION](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/question.md): Opens a question window and returns the answer selected by the user.
- [STARTTIMER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/starttimer.md): Starts a timer that executes a widget action at regular intervals.
- [STOPTIMER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/stoptimer.md): Stops a running timer.
- [TIMERLIST](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/navigation-functions/timerlist.md): Returns information about all currently running timers in the current app.
- [Range functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions.md)
- [AGGREGATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/aggregate.md): Aggregates rows of a range based on duplicate elements.
- [CELL](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/cell.md): Returns a cell of a range.
- [CLEAR](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/clear.md): Converts an error to an empty value.
- [COLUMN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/column.md): Returns a column of a range.
- [COLUMNS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/columns.md): Returns specific columns of a range.
- [COMBINE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/combine.md): Returns the combination of two or more ranges.
- [CONVERT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/convert.md): Converts values to a specific value type.
- [COUNT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/count.md): Returns the number of numeric cells in a range.
- [CROSSJOIN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/crossjoin.md): Creates a cartesian product by combining rows from multiple ranges.
- [CSVTORANGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/csvtorange.md): Returns a range which has been extracted from a CSV (comma separated version) text.
- [CUMULATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/cumulate.md): Cumulates a range of values, i.e. every number of the range is added to the sum of all previous numbers.
- [DIFF](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/diff.md): Removes rows from a range.
- [EMPTY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/empty.md): Returns empty cells.
- [FILTER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/filter.md): Returns a range which is filtered based on a condition.
- [FLIPCELLS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/flipcells.md): Flips a range of values in a specified direction.
- [GETTYPE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/gettype.md): Returns the type of a value.
- [INSERTRANGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/insertrange.md): Returns a range where another range has been inserted.
- [INTERSECTION](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/intersection.md): Returns elements of a range which are included in another range as well.
- [LEVEL](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/level.md): Returns the hierarchy levels of visible rows in a hierarchy widget.
- [LOOKUP](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/lookup.md): Maps rows from a range according to a column of key values.
- [MOVECELLS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/movecells.md): Moves non-empty cells within a range in a specified direction, optionally removing empty cells.
- [PIVOT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/pivot.md): Converts a row-based range of values to a column-based range of values.
- [RANGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/range.md): Returns a part of a range.
- [RANGETOCSV](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rangetocsv.md): Returns a CSV (comma separated version) representation of a range.
- [RANGETOHIERARCHY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rangetohierarchy.md): Converts a range to a hierarchy.
- [RANGETOROW](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rangetorow.md): Converts a range of cells to a row range.
- [RANGETOJSON](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rangetojson.md): Converts a range of cells to a json text.
- [JSONTORANGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/jsontorange.md): Converts a json text to a range of cells.
- [ROW](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/row.md): Returns a row of a range.
- [ROWS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rows.md): Returns specific rows of a range.
- [ROWTORANGE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/rowtorange.md): Converts the cells of a row into a range.
- [SEQUENCE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/sequence.md): Returns a range of sequential numbers.
- [SORT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/sort.md): Returns a range which is sorted based on values in one or more columns.
- [TRANSPOSE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/transpose.md): Returns a range with exchanged rows and columns.
- [TRIMCELLS](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/trimcells.md): Removes empty rows or columns from a range.
- [UNIQUE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/unique.md): Removes duplicate rows or columns from a range.
- [UNPIVOT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/unpivot.md): Converts a column-based range of values to a row-based range of values.
- [VISIBLEHIERARCHY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/range-functions/visiblehierarchy.md): Returns for hierarchy widgets the currently visible rows.
- [Text functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions.md)
- [CHAR](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/char.md): Returns a Unicode character based on its number.
- [CODE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/code.md): Returns the Unicode value of a character.
- [CREATEMEMBER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/createmember.md): Returns a value containing two texts - the display text and a hidden text.
- [FIND](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/find.md): Returns the position of a text within another text.
- [HASH](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/hash.md): Returns a hashed representation of a text.
- [HIDDENTEXT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/hiddentext.md): Returns the hidden text of a member value.
- [HTMLTOJSONTEXT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/htmltojsontext.md): Converts a HTML text to a JSON text which can be assigned to formatted text widgets.
- [JSONTEXTTOHTML](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/jsontexttohtml.md): Converts formatted text widget content to HTML markup.
- [LEFT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/left.md): Returns the first n characters of a text.
- [LEN](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/len.md): Returns the number of characters in a text.
- [LOWER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/lower.md): Returns a specified text in lower case.
- [MID](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/mid.md): Returns a segment of a text.
- [RIGHT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/right.md)
- [SUBSTITUTE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/substitute.md): Replaces sub-texts in a text.
- [TEXT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/text.md): Converts a value into value type “text”.
- [TRIM](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/trim.md): Removes leading and trailing spaces from a text.
- [UPPER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/text-functions/upper.md): Returns a specified text in upper case.
- [User management functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions.md)
- [ADDUSER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/adduser.md): Adds a new user to the current workspace.
- [APPLIST](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/applist.md): Returns a list of all apps in the current workspace.
- [APPSHARELIST](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/appsharelist.md): The APPSHARELIST function returns a list of all users with whom an app is shared.
- [REMOVEUSER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/removeuser.md): Removes a user from the current workspace.
- [SHAREAPP](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/shareapp.md): Shares an app with a user.
- [UPDATEUSER](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/updateuser.md): Changes properties of an existing user in the current workspace.
- [USERLIST](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/userlist.md): Returns a list of all users in the current workspace.
- [USERNAME](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/user-management-functions/username.md): Returns information about the current user.
- [Widget functions](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions.md)
- [CELLREF](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/cellref.md): Inserts an area at a desired position in a table widget.
- [COPY](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/copy.md): Copies a range of values into a widget at a specified position.
- [GETSELECTION](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/getselection.md): Retrieves the current selection of a menu widget.
- [LOADWIDGETCONTENT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/loadwidgetcontent.md): Loads the current content of a widget from the nedyx database.
- [NAME](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/name.md): Returns the name of the widget which is executing the current formula.
- [SETSCROLLPOSITION](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/setscrollposition.md): Sets the scroll position of a table widget.
- [STOREWIDGETCONTENT](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/storewidgetcontent.md): Saves the current content of a widget in the nedyx database.
- [SWITCH](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/switch.md): Changes the setting of a menu widget.
- [UPDATE](https://docs.nedyx.com/version-1.66/nedyx/clearlines-functions/widget-functions/update.md): Updates the content of a widget.
- [Security](https://docs.nedyx.com/version-1.66/nedyx/security.md)
- [User Management](https://docs.nedyx.com/version-1.66/nedyx/security/user-management.md)
- [Workspaces](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/workspaces.md)
- [Workspace Roles](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/workspace-roles.md)
- [Adding Users to a Workspace](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/adding-users-to-a-workspace.md)
- [App Roles](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/app-roles.md)
- [Share an App with Other Users](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/share-an-app-with-other-users.md)
- [Guest Access](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/guest-access.md)
- [Change Password](https://docs.nedyx.com/version-1.66/nedyx/security/user-management/change-password.md)
- [Appendix](https://docs.nedyx.com/version-1.66/nedyx/appendix.md)
- [Keyboard shortcuts](https://docs.nedyx.com/version-1.66/nedyx/appendix/keyboard-shortcuts.md)
- [Error handling](https://docs.nedyx.com/version-1.66/nedyx/appendix/error-handling.md)
- [Feature preview](https://docs.nedyx.com/version-1.66/nedyx/appendix/feature-preview.md): The feature preview option provides early access to functionality which is not general available.
- [Supported browsers](https://docs.nedyx.com/version-1.66/nedyx/appendix/supported-browsers.md)
- [Version changes](https://docs.nedyx.com/version-1.66/nedyx/appendix/version-changes.md)
- [System requirements for on-premises installations](https://docs.nedyx.com/version-1.66/nedyx/appendix/system-requirements-for-on-premises-installations.md)