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

Fleno Storage

Hi, Yesterday I had used 2.6 GB of the 4 GB I have and without doing much today it appears as used 4.47 GB. Now I am having problems. Does anyone know why this is? How can I fix it?

• Answered

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.

Record the previous day's figure

Hello There is a DB for a gaming club, and to calculate the result for the day, you need to rewrite the counter indicators of the previous day. In order not to do this manually,…

• Answered

Is there a way to find overlapping appointments?

I would like to create a formula that shows / checks if an appointment is overlapping with another appointment. Is this possible? Thanks!

Accounting Tutorial

Hi there. I'm wondering if there is a tutorial anywhere about setting up the accounting side of the database? I've been using Excel, and am wondering if I could switch over to Ninox for that part of…

set values in a child

Hi there I am fighting a little with setting a marker in a child based on a value in the parent. The case is that I have for example a project nr which is the parent and the children are persons…