How do i add up totals

Hi i am a new user trying it out and i just can not see how to make it work to add up numbers. I have loaded in CSV files of data and in that includeds jobs booked with a total price of a package,…

It is posible on Ninox.

Hello, please I need to know if this is possible. I need to copy the Values of the fields indicated in the Documents Form to the Progress Form. These values in documents change every Friday and I…

Dynamic Choice Field reference in a function

Hi all, I want to make a function out of a formula I often use in my Database. The function involves the following fields: FieldA: text FieldB: text FieldC: date FieldD: choice FieldE:…

• Answered

Trigger after update record not triggered when linking/adding records to sub-table

I don't know if this is a bug or a feature, but the Trigger after update is only triggered when editing data in normal fields. Any change in a sub-table does not trigger the script.…

• Answered

today() function giving yesterday's date

Today I've been having two big issues with date functions in Ninox: 1 - If I use the today() function, it returns yesterday's date. 2 - I am trying to compare two dates within an if statement.…

How can I calculate age at the time of an event in years?

I have the fields for Date of even and date of birth (DOB). I would like to calculate the age using these and display it in years. When i use the formula Date-DOB then the time elapsed displays in…

Update Yes/No Slider on one table from slider on another

I'm working on my "order tracking" database and today decided to add another table to make a list of projects that I'm going to manufacture on a daily basis.…

Number value of multiple choice not correct

Hi guys, big problem here: I am using a multiple choice field, but the numbers assigned to the values are not correct. Option 3 doesn't work in a formula.…

Choose more than one?

This has turned out to be a day for questions. Here's my next burning question: Is it possible to select more than one item in a Choice field? For example,…

Conceptual Problem.

Conceptual Doubt about the Disciplines and Activities Tables The Disciplines table has some specialties, example Civil has Foundations etc as a specialty and each specialty has different activities,…

• Answered

Search with Multiple Choice problem

@Fred I use these Formula and work but the problem is I have only 3 items in the table Tipo de Documento and need to use aleatory case number. I try one by one I'm lucky to find the case number,…

• Answered

Integration with a POS

Hi there, I'm new to Ninox and very excited about the potential .. but I couldn't find a clear answer in the forum/docs to the following : Is it possible to build a custom integration between my…

How to sort on multiple columns in interface?

Is there a way via the interface to sort items on multiple columns (like an ORDER by in a SQL statement) and have the grid view update to show that combined order? Thanks

Native Ninox form embed

Hi there, I wanted to find out if there is a native Ninox form that can be embedded in for instance a WP site. Hoping for a positive response Edwin

How do I perform an update?

I have a local copy of the Ninox app on my MacBook Pro. Where would I find the version number for the copy I'm running, and how do I update to the latest version? TIA for assistance with this,…

Ignore hyphens when sorting

I have a list and am sorting by a reference number. The reference numbers have two formats, AB-C-01 and ABC02. Some have hyphens and some don't. With or without hypens, each reference is unique.…

How can I recover lost data???

Yesterday we lost 1800 records from my data base, and I am afraid that it's because we recently paid our data plain and it's not reflected in my app

ExtractX help!

Hello everyone! From this RAW text, I need to extract 2 timestamps (in 2 separated formula fields) for the patterns: q101_agendaCita q126_agenda126: {"slug":"submit\/221023934014341\/",…

Converting an input to an output

I have three input fields: Watts Input BTU Input Temp Input The Output field is: BTU OUTPUT In the case of Watts Input - BTU OUTPUT is Watts Input * 3.…

Script permission attribute

Hi Ninox users, There is a way to run a script with different permissions than the current user? thanks !

I Made A Wrong Payment and Ask For Return My Money Back

I Made A Wrong Payment and Ask For Return My Money Back, I double buy licenses, please return my money back.

• Answered

Syntax create record

Hi, i know a sintax for creating a record : sample : let p := create Person; p.Name :="myName"; ok nice, but i have one time see a other syntax for creating a record.…