-
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:…
-
Android (Chromebook) selecting a record in table view using mouse click issue.
Hi, For some reason I am unable to select a record in some table views when using a mouse the only way is to use TAB to go through records one by one, am I missing something or is this the only way…
-
View of table sorted by date within groups
I have a table that I want to create a view group my people, sorted by date of records by people and then sliced within each sorted group. I have it working for a specific person but want to process…
- Answered
-
Enterprise plan
Hi, I just found out that Ninox has a new pricing page. It doesn't say you need at least ten users for the Enterprise plan. Can you buy the Enterprise plan for one user?
-
Filter by icon in a column
Hi everyone, I'd like to know how can i filter icon in a column. As you can see in my screenshot, i have a column with a formula that returns differents kind of icons.…
-
Data Model
I have the Mac version of Ninox. I believe something has changed recently as I am unable to find the "Data Model" option. Any help would be appreciated.
- Answered
-
Create lines for CSV
Hi there has anybody done a transfer from one table to another where one record in the in the main table become 3 or more records in another table - the thing I am trying to solve is that I today has…
- Answered
-
Photos are way too big
I take photos with a iPhone and put them in my Ninox app. Ever since the update from apple or Ninox, the photos are super big when they are uploaded on Ninox.…
-
JSON and for loops
Hi all - I was reviewing the set() command and noticed this: for i in response do let new := (create Contacts); for key, value in i.fields do set(new, key, value) end end Look at line 3,…
-
Fire email field from button
Hello, I have an email field, which is populated this has an email subject and body based on other fields. Is there a way I can create a button on another tab that would fire the normal functionality…
-
Put comments in the scripts
I discovered that it is possible to easily metre comments in scripts with a notation that was not documented: #{here I can put any text}#; var y := year('Start date'); var m := month('Start date');…
-
New Ninox Features & Future Releases Webinar
Let’s Explore the New Ninox Features & Future Releases with an Open Q&A Thursday, October 10th at 12pm EDT/ 5pm BST/ 6pm CEST FREE REGISTRATION: https://us02web.zoom.…
-
Styled text
Hello How to style text negative positive and zero? there is a formula when there are two values, but you still need to add a text color when there is zero let AA :…
- Answered