Table relationships, data model

Very new Ninox user here, used to use FileMaker long ago. I'm trying to learn how to create relationships between tables. I tried creating a relationship between two tables (in the same database),…

Scrip to unlink table

I have a table linked to another. Users linked to type of users. I want a script in a button to unlink the type of users. The same that click the red circle option in this image.

rsort not working

Hi all - rsort is leaving out the first item in my array, see pic. Forumla2 is the the regular sort order and Formula is the reverse sort. As you can see 7 stays in the first position.…

More in-depth instructions (or video) on Ninox Private Cloud on Premise install

Is anyone able to provide detailed instructions, or a video on how to install on premise? I have Windows 10 and got as far as running the installer exe and downloaded my ninox.license.…

Data type?

Hello guys i am new at ninox but i understand database data structures and normalization rules, however i would like your help to understand ninox since my business runs a lot of records and proceses,…

Doppelte berechnete Werte Je Monate vermeiden

Hallo Ich berechne in einer Tabelle die Summe je Monat mit folgender Formel let myMonat := yearmonth(InvoiceDate); sum((select Haushaltsbuchdos where yearmonth(InvoiceDate) = myMonat).…

Count number of characters formula? (Spaces, numbers, letters, etc)

I cannot figure out a formula to count the number of characters for TextField1. Any help?

Find repeating characters in a string

Hi, I want to find the index of a string segment in a string, say ther 3rd comma in a list oif comma seperated values. I want to create a string that will return eveything up to that index value. i.e.…

Ninox to MS Word

Is it possible to link a Ninox table with MS Word mail merge? I would like to print a document with variable fields. Unfortunately the print function in Ninox (pdf) is not good.

Print all records in date range.

Hi, l would like to print all invoices in a date range. Is there a script for a button l can use? I'm sure this question has come up before but struggling to find anything on the forum.…

Print a field image from a linked table don't work

Hi, I can't print a simple image from a second table. Here the formula in the document editor : (select JOB where Atelier.Nom = "CHAUDRONNERIE" and Ordre = this).…

Verification of email sent

I am using the sendmail function for a button to email invoices to our clients. How can I verify that they are receiving the email?

when I create new record (at that time I enter email address to on field of table ), can I send email to email address that I entered?

Programmatic CSV import/export

Is there a way via the API or other method to programmatically import and/or export CSV content to/form a table. Basically a scripted way to match CSV and table columns without going through the…

I’m doing a questionnaire

On the questionnaire there is "Agree, Slightly Agree, Unsure, Slightly Disagree and Disagree" Im trying to make it so Agree is = to 5 points, Slughtly Agree is = to 4 points etc.…

compare arrays’ values

Hi all, I have three arrays that represent three diffrent limits restrictions and that are invariable: Array1 (x1;x2;x3) Array2 (y1;y2;y3) Array3 (z1;z2;…

I need to have label in different language. What is the best way of doing that? Formula fields? too much space

Formula fields with images

I'm using a formula box to refer to images in other tables. When doing so, the formula field auto adjusts to the full size of the image rather than the size I've set up on the for.…

How can I add two arrays?

Any idea how you can add arrays in NINOX let a := 1;let b := 2;let c := 3;let d := 4;let ar1 := [a, b, c];let ar2 := [d];let ar3 := [ar1 + ar2];ar3 This will give the result 1234 instead of 1,2,3,…

Have field remain blank if sum is zero

Hello, this is probably something simple that I'm missing, but... I have two number fields in a table that I are added together to make a total. If this total is zero - as in £0 - then I would like…

How do I send a return in a TXT?

This sms://0401111111?&body=Hello World sets up a TXT in Messages on my Mac ready for me to press RETURN. How do I include RETURN in my command string? sms://0401111111?…

Will the Forum Admin please clean this massive spam dump up ?

Will the Forum Admin please clean this massive spam dump up ? This is a train wreck. Thanks

Serious?

Are you kidding me? more than 230 pages spam.... I've given up on 230... who knows how many more there were...

Database Degradation

Was wondering if anyone else has experienced issues with their database where scripts stop executing, formulas calculate haphazardly and dynamic choice fields only work sometimes.…