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

How to delete/rename a table in web and on iPad?

Obviously I am new here and this seems so baisc. But the truth is, I cannot figure out how to delete a table in web view and/or on iPad.