-
Can I write comments inside the code?
Hey, I want to give comments inside the code. Example : sum = number(a) + number(b) (// this is the sum of two numbers).
-
Can I write comments inside the code?
Hey, I want to give comments inside the code. Example : sum = number(a) + number(b) (// this is the sum of two numbers).
-
Loops syntax
Hi, guys: I'm running into something that I just can't get past. I have a loop structure that I can get to work; here's a general summary: let xCounter := 0; let xTotalMatchingRecords := cnt(Table);…
-
Calendar item with detailed info
Hi, Is there any option when creating a date field or a apppointment field in Ninox to set "Show as" and fill parts of the Calendar event - "location", "person",…
-
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.
-
What's with all the garbage
Exactly that. Recent posts are all garbage. Anyone dealing with this spamming?
-
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?
-
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.…