# nedyx

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