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

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,…

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

Avoid new records

How can I avoid adding records in the main table?

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…