How prohibit changes to the table/field record

How i can prohibit changes in the table of an already made record. Task - If the record has been made, no one can change it, just admin. The prohibition on deletion has been work,…

display of fonts in a "Rich Text" control

Hello,why I can no longer display the fonts or colors of the text in a "Rich Text" field. When I click on show fonts or colors nothing happens. (PC MAC - OS High Sierra)

sendEmail({ help!

Hi, I have the following triggered after update from a date function 'outworker deadline', but it refusing to send an email. Todays date is a formula field today().…

Convert coded text to plain text

Hi. I have this code from Zapier-Jotform [{"N. de llicència":"Ib 1234","Nom complet":"Mateo Domínguez Fuentes","Data naixament":"02/02/1983","Categoria":"Absoluta"},{"N.…

Display two tables at once?

One other question for today... Is there any way to display two different tables, in table view, on the screen at the same time? I want to visually compare some of the data between two tables,…

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