Fx Field to Display Date or Text Depending on If Statement

Hi, In the standard view (all) for record entries, I would like a column that displays either a date that was recorded as a field or text if that date field was not completed. So far I have..…

• Answered

Date of Birth? manually entry

hi, i have to set DOB but I found that on apple app, we I touch date field always display calendar to add a date, that is too annoying when you must set for example 1953 as year of birth,…

Date function

[Previous experience with MS Access & FileMaker; semi-new Ninox user. Using local Ninox app, on a MacBook Pro running MacOS Monterey v12.3.] [I'd add the version of Ninox I'm using,…

Private Function to Check Empty Fields on Button Click

Hi, Is it possible to create a function and pass it an array of fields to check if any of them are empty? My example is that I want to send a send a task to outlook using integromat,…

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…

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

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…