# nedyx

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