-
Regarding issues with editing the chart code
Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data…
-
Duplicate a quote a change its number
Hello, I have a quote table. On «Trigger on new record», I have that script: let myLastNumber := last(((select Quote where 'Quote #') order by 'Quote #').…
- Answered
-
SAML SSO with Okta
Note: We're in the process of rewriting this guide. Please refer to our Private Cloud SSO setup guide – Microsoft Entra (SAML) in the meantime. -
Modularity V1 – Reconnect modularized databases
The Ninox 3.11 release introduces a simplified way to reconnect modularized databases imported to another workspace
Reconnecting modularized databases is available for Private Cloud and On-Premises.… -
Modularity concepts
For users testing modularity v2 in Ninox 3.17 beta on Private Cloud
Note: This article explains the ideal, conceptual model of Ninox modularity. It isn't a specification of modularity v2,… -
goto another record from calendar
Hi there, have anybody ever tried to jump to a record from calendar where the record I not the one which created the calendar event. I have this situation that I am in a table where I create a…
-
Print Report Layout
I noticed I cannot access the Print layouts to edit etc. when using the latest Ninox Mac app vers 3.13.6 I have a script that prints out data using the previously built layouts,…
-
do as database ... end
The Ninox 3.10 release introduces a transformative feature to enhance your experience: the do as database ... end transaction
do as database ... end is available for Private Cloud and On-Premises.… -
Enable timezone-independent date
Finally! This option ensures that a date is always output correctly—regardless of the timezone in which a record is accessed.
The enable timezone-independent date option refers only to the date… -
Generate QRCode to File or Image field
Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
-
Add licenses
Purchasing additional licenses for your current subscription How many collaborators can I invite to my workspace? You may invite as many collaborators to as many workspaces as you like.…
-
How to write code for data filtering?
How can we filter out the top three salespeople with code? Xiao Ru $382.00 Jiang Ningwei $648.00 Xiao Ru $1,704.00 Jiang Ningwei $2,883.00 Xiao Li $11,760.00 Yang Daibing $4,640.00 Li Yanping $980.…
- Answered
-
Mimic spreadsheet
I have a spreadsheet designed to provide payout for 1st thru … positions for 8 people through 24 people. In excel I can do vlookup for number of players and get the payouts for each position.…
-
openTable
To open a given table This function closes the current table and opens a given table. You can specify the request by adding a view you want the table to be opened with.…
-
adding eg 7 days to a date+time field
Hi, I just cant figure out how to add days to a date+time field and I couldnt find anything in forum. Lets say eg 15.10.2024, 9:00 date+time field := date(year(date+time), month(date+time),…
- Answered
-
Delete view tabs
I'm trying to learn how to use Ninox. I'm coming from 20 years of Filemaker. I clicked on the + to create views (Table, Chart, Kanban, etc.). Now I'd like to delete these tabs,…
-
openRecord
To jump to the related table and open a given record This function closes your current form and opens the form of the given record together with the respective table.…
-
openPrintLayout
To open a record in a given layout in the print layout editor This function will open a specific print layout of a given record. Syntax openPrintLayout(nid,…
-
openPage
To open a given page This function closes the current page and opens the given page. You can specify the request by adding a tab you want the page to be opened with.…
-
Dynamic printing and join tables
Hi, I have several join tables set up because I need the many to many relationship. So I have a Programme table that links through a join table to a Staff table for ex.…
- Answered
-
Visualizing Data, Graphs & Charts in Ninox Webinar
Back by popular demand: Visualizing Data, Graphs & Charts in Ninox. Join us this week! Thursday, October 17th at 12pm EDT/ 5pm BST/ 6pm CEST FREE REGISTRATION: https://us02web.zoom.…
-
Avoid new records
How can I avoid adding records in the main table?
-
openFullscreen
To open a given record in fullscreen mode This function will open the form view to fullscreen. Specify the record, which you'd like to show in fullscreen mode.…
-
odd
To return Yes (true) if the number is odd With this function, you can check whether a number is odd, i.e. not divisible by 2 without remainder. The return value is either Yes (true) or No (false).…
-
numbers
To return the IDs of the selected choice values of a given multiple choice field With this function, you'll get the IDs of the selected options. Multiple choice field:…