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

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

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…

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

Ninox APP update problem

Today I updated my NINOX App to version 3.13.3. The design has changed, but I probably need to get used to it, no complaints here 1 -The columns in the tables disappeared 2 - when saving the changes…

Copy record Id failing

I have the following script on a button. Everything copies over except the record Id. Any ideas on why? The target newInventory.(PurchaseItem := me.Id);, is a number. No errors are apparent.…

• Answered

Date view format problem

Hi, before update Ninox to 3.13 or update macOS to Sequoia all dates in the tables were in the format: 19.06.2024 05:40 now I have 19 cze 2024 05:50 I definitely prefer clear numeric date format,…

Get()

So, with Ninox's new get() I could do: get(this,"First Name") However, what if I would like to look up the table and field? Could I do something like get(tableFind("Table Name",recID),…

Floating windows in Ninox

Is it possible to create floating windows in Ninox for taking some input? I have customers making pmt for their invoices in parts sometimes. So I want that whenever a part arrives,…

moving database from one account to another

I signed up for a free trial account on Ninox to see how it worked. I liked it enough that I bought a subscription to do work for an organization. I signed up for the subsciption with a different…

Connect 2 entries

Hello. I have this code in the table Solicituds in a button: let dniActual := DNI; let personaEncontrada := (select Personas where DNI = dniActual); if count(personaEncontrada) > 0 then alert("El DNI…

• Answered

openRecord not opening record

I have a database, written many years ago, which I use on macOS and iOS. It contains a table called Start, whose form is designed as a switchboard for database navigation.…

• Answered

Dynamic Printing Table layout

Hi all - So I'm trying to format a table in dynamic printing where every other line is a different color. I thought you could just format the second line in a different color, but it doesn't show up.…

• Answered

Formatting a field

Can someone help me with formatting in a field. I want to have a captial letter first and lower case after, also phone number, and ss#, etc.