How do i connect a table?

I am using a templae (015_invoices different) and trying to make a version of it for my use. I do not see how i can connect the table right. Here is a screen shot of the working template fields you…

How to action a trigger after form close?

Hi, am wondering how can i action the update trigger after i close the edit window? What is happening it keeps on sending numerous notifications on every field i update which is cumbersome.…

print Ordered

i have: if text(InvoiceItemVendor.'Status Item') = "Ordered" then printRecord(this, "Ordered") end but it doesn't work

Filter on hidden columns

Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…

• Answered

Button to call camera automatically?

Is it possible to create a button inside Ninox that automatically calls the camera device (Android tablet) to take a photo? We want to skip the question "you want to take a photo or choose from the…

Readable If within a range

Hello, I want to display only specific records if a user has access to them. I have a table named UserX where Employee is a user field and 'Account Access' which is a Dynamic Multi Choice.…

Return to my Topic

@Fred @RoSoft_Steven Rooryck To Return the topic since it point that I need to have my DB at last 90% . Excuse the insistence but is very important and I can't resolve this.…

• Answered

Conversion into Ninox of old relational data

How would I import data into Ninox from multiple tables of a relational database built in another platform and keep records related? I am able to get primary and foreign keys into the right records…

• Answered

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