All topics

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

Calendar not updating clients (macOS, iOS etc)

Today my Appointment field events are appearing in the Calendar view (macOS desktop version). Usually they sync also with my calendar client apps on macOS and iOS, but not today.…

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…

Ninox on iPad Stopped Saving Changes

It's only happened once, and I got around it, but it's made me nervous about making changes, so I'm hoping for a bit of feedback - has it happened to other people,…

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…

populating pdf fillable form with Ninox data

Has someone been able to use an app or a way to take the data of a table from Ninox and fill a Pdf

populating pdf fillable form with Ninox data

Has someone use an app or extension or anything that "populating pdf fillable form with Ninox data " without paying monthly subscription? Or maybe something reasonable. I use a MacBook

Trigger after update not triggered when updating by copy&paste

I have a table with code for trigger after update (for the table, not a field). When I edit an existing record by typing in a field, the trigger gets called as expected.…

Sorting Problem

Hi There was a problem sorting into a table Format for display in the table text + Number the same problem in dynamic selection formula for display 'Machine Room'.…

Select from Choice Dynamic from button go to record in another table

let selectedDocument := 'Document Choice'; // Choice Dynamic let rD := first(select Document where 'Document Name' = selectedDocument); openRecord(rD) The Choice Dynamic is in Dashboard and the…

• Answered

Multi-Choice Menu Style Adjustment

I have a multi-choice menu (see attached). Is it possible to manipulate the code for this particular field to either hide the (all) button or change its action to select a specific value?