LogoLogo
Version 1.48
Version 1.48
  • nedyx
  • Welcome to nedyx
  • 🚀Getting started
    • Preparation
    • Basic widget formatting
    • The first formula
    • More formulas
    • Combine several tables
    • Add a new page
    • Widget references across pages
    • Add a chart widget
    • Further adjustments
  • 🖊️Working with nedyx
    • Apps
    • Live and Edit mode
    • The Header bar
    • Pages
    • Widgets
      • Widget types
      • Adding widgets
      • Widget selection
      • Widget positioning
      • Style tab
      • Content tab
      • Table widget types
      • Cell styles
      • Chart content
      • Chart properties
      • Undo / redo
    • Databases
      • Connect to a database
      • Get external data
    • File management
  • 📖ClearLines Functions
    • General Aspects
      • Formula structure
      • The formula editor
      • Actions
      • Calculated widget properties
        • Content property
        • Cell styles property
        • Chart labels
        • Column widths and Row heights
        • Connection property
        • Editable property
        • MinY and MaxY properties
        • Style property
        • Tooltips
        • Visible property
      • Ranges
      • Widget references
      • Widget cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • SECOND
      • TODAY
      • WEEKDAY
      • YEAR
    • Import / export functions
      • DOWNLOAD
      • DELETEFILE
      • DOWNLOADFILE
      • EXCELCREATE
      • GETFILELIST
      • PDFCREATE
      • POSTMESSAGE
      • SCANCODE
      • SENDEMAIL
      • UPLOAD
      • UPLOADFILE
    • Logical functions
      • AND
      • IF
      • ISEMPTY
      • ISUSERACTION
      • LOOP
      • NOT
      • OR
    • Mathematical functions
      • ABS
      • EXP
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SQRT
      • SUM
    • Navigation functions
      • CLOSE
      • GETURLPARAM
      • MESSAGE
      • OPEN
      • OPENWEBPAGE
      • QUESTION
    • Range functions
      • AGGREGATE
      • CELL
      • CELLREF
      • CLEAR
      • COLUMN
      • COLUMNS
      • COMBINE
      • CONVERT
      • COUNT
      • CSVTORANGE
      • CUMULATE
      • DIFF
      • EMPTY
      • FILTER
      • GETTYPE
      • INSERTRANGE
      • INTERSECTION
      • LOOKUP
      • RANGE
      • RANGETOCSV
      • RANGETOHIERARCHY
      • ROW
      • ROWS
      • SEQUENCE
      • SORT
      • TRANSPOSE
      • UNIQUE
      • VISIBLEHIERARCHY
    • Text functions
      • CHAR
      • CODE
      • CREATEMEMBER
      • FIND
      • HIDDENTEXT
      • HTMLTOJSONTEXT
      • LEFT
      • LEN
      • LOWER
      • MID
      • RIGHT
      • SUBSTITUTE
      • TEXT
      • TRIM
      • UPPER
    • User management functions
      • APPLIST
      • ADDUSER
      • APPSHARELIST
      • REMOVEUSER
      • SHAREAPP
      • UPDATEUSER
      • USERLIST
      • USERNAME
    • Widget functions
      • GETSELECTION
      • LOADWIDGETCONTENT
      • NAME
      • PAGE
      • SETSELECTION
      • STOREWIDGETCONTENT
      • UPDATE
  • 🔐Security
    • User Management
      • Workspaces
      • Workspace Roles
      • Adding Users to a Workspace
      • App Roles
      • Share an App with Other Users
      • Guest Access
      • Change Password
  • Appendix
    • Keyboard shortcuts
    • Error handling
    • Feature preview
    • Supported browsers
    • System requirements for on-premises installations
Powered by GitBook
On this page
  1. ClearLines Functions
  2. General Aspects

The formula editor

PreviousFormula structureNextActions

Last updated 10 months ago

With the formula editor, the editor can define the properties of widgets, or specify which action should be taken if e.g. a button is pressed or a menu is switched.

The formula editor consists of the following elements:

"Execute formula" button

Property menu

In the property menu, the current action or the property can be selected, for which the formula is displayed.

The "="

The "=" between the property menu and the formula editor is displayed for properties. This emphasizes that the result of the formula is assigned to the currently selected property. For actions, there is no result returned, so the "=" is not displayed.

The formula editor

In the formula editor, all nedyx formula can be entered. There are many options to simplify the creation of formulas:

  • Autocomplete - provided by a menu during typing. Autocomplete is provided for formulas and widget references.

    The following options are provided during autocomplete mode:

    • Type on the Return or Tab key to insert the currently selected function or widget reference into the formula editor.

    • Click on the "...info" tag behind the function to open the online help for the function

    • At the right side you find information about the type of the autocomplete entry, if is is a function, a widget, a page, a constant or a property.

  • Widget insertion - By clicking on a widget with the CTRL key pressed, a reference of the widget is inserted at the current position in the formula editor. If the cursor is already on a widget reference, this reference is exchanged with the reference of the clicked widget.

The "Delete formula" button

The "Collapse" / "Expand" button

The "Execute formula" button executes the current formula.

Widget identification - After clicking on the reference of a widget in the formula editor, the widget is marked with a dotted frame.

Error tooltips - If a formula contains an error, this is identified right beside the formula editor and by a red underline below the erroneous formula segment. After hovering over the underline, the according error is displayed.

With the "Delete formula" button , the current formula can be deleted. If multiple widgets are selected, this formula type can be deleted either only for the main selected widget, or for all selected widgets. A corresponding selection then appears as a dialogue.

With the "Collapse" / "Expand" button , the formula editor can be switched from single line to multi line. If the button is colored blue , the formula contains multiple lines.

📖