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. Getting started

The first formula

PreviousBasic widget formattingNextMore formulas
  1. Click on the widget below the text Year.

Note: Every widget has a name, which is unique per page. You can see in the field left above the page area that the currently selected widget is named year.

We will now assign a formula to this widget that will display all years, from 1 to the number of years which are defined in the widget below Period / Years.

2. Click with the mouse into the formula editor. You find this editor above the page, right beside Content.

3. Now enter this formula into the formula editor: SEQUENCE(#period; 1) and type on the Return key afterwards. The year widget is now filled with the numbers from 1 to 8.

Note 1: You might recognize the autocomplete window during typing content into the formula window. The suggested entries can be inserted by typing the Return or Tab key.

Note 2: The function SEQUENCE(#period; 1) returns all integer numbers from 1 to the defined parameter in one column. If you want to learn more about the SEQUENCE function, you find a description of all nedyx functions in the navigation on the left under ClearLines Functions, or click directly on this link: SEQUENCE.

Note 3: There is an easy syntax used to access the content of widgets: a hash followed by the name of the widget. So #period returns the current content of the widget period, in this case the number 8.

4. In the formula window, click on any letter of the widget reference #period.

Now you see that the according widget period is identified with a blue dotted, marching border. This is helpful to easily read and understand a nedyx formula.

5. With the CTRL key pressed, click on the widget below Additional Rate / Year (containing the value 2,000). Type on the Return key.

This is another very helpful way to insert or exchange widget references in a formula. Now the year widget contains all numbers from 1 to 2,000. Of course that was just for fun, and we have to revert it now.

6. Repeat steps 4 and 5 to again insert #period into the formula.

Note 4: You can also undo changes using the Undo / Redo buttons in the header or by pressing CTRL+z / CTRL+y.

In the next step, we fill the other table widgets with formula content.

🚀