Building table relationship 1:N

I have two tables I imported from a previous database. They were linked by an ID number. How do I recreate the relationship between these tables on the imported ID number fields?…

How do i track payments and update the new balance due?

We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…

• Answered

How do i get my numbers $ to format right?

I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…

• Answered

Neither of the two formulas work

I try these two formulas but not work some ideas. select 'DOCUMENTOS' let xFld1 := 'Avance Plan'; let xFld2 := 'Avance Real'; let i := (create AVANCES_PROY); i.('Avance Plan' := xFld1); i.…

• Answered

Related table field reference

ok....I know that by the time I will read the answer I will feel very dumb, but...sometimes you have to learn things the hard way I created a N:1 relationship between TABLE1 and TABLE2 and now in…

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