How to query a table using a dynamic combo box value?

I have the code below, i want to return the email address where the the full name of the staff is the one assigned to the ticket. let i := 'Assigned To';…

• Answered

Several newbie questions

I just discovered Ninox two days ago and am wondering where it's been all my life. I'm a consulting applications developer with long experience in multiple platforms (especially but not just…

using if else in formula field

Hello people, I am stuck in a condition where I want to show values of one field (Status1) to a formula field (Status0). I write a code in Status0 formula field which is mentioned below.…

Formula for combine two Alerts Date's

Hi I need combine this two Alerts in the same Formula 1 - These Formula if FechaR5 < FechaR4 then alert("Fecha Real 5 no puede ser menor que Fecha Real 4") else "ok" end 2- And These For Holidays…

• Answered

Formula diferent result

@Fred Hi the Cantidad Doc in the Formula is not the same on Table and Form if Clase = "Actividad" then cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.…

• Answered

Pause function

I am curious if there is a pause fuction, where itll run my first line of code, and then my next line of code. This is what I am currently working with: 'Last Status' :…

List keeps growing - no scrollbars?

I have a link to another table where I "Create Records" to add rows. However, what Ninox is doing is, as I add each new record, just growing the table on the screen instead of keeping the dimensions…

Appointment function not working

Ever since the last iPhone update I am not able to create or edit more than 1 appointment at a time. When I create an appointment with a start and finish time I have to shut down and restart the app…

MailChimp Integration with Ninox

To date I have not had a need to use integration services with Ninox. However I want to now link MailChimp to Ninox and in looking I see that there are several options out there ie Zapier,…

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