-
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.…
-
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;…
-
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.…
-
Can't find the field width control
I'm new to Ninox. So far, so good, but I've got lots of "how do you ...?" questions. Today's question is this: In the User Manual, Section 5. Tables, 5.…
-
Zoom link gets converted in Sendmail
I'm using SendMail to send Zoom meeting invitations to online students. A link like https://zoom.us/j/2861234557?pwd=TklkRG1oNXNwSHR2awsSk9HaVpKRFppZ ends up looking like http://links.ninoxdb.…
-
How prohibit changes to the table 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,…
-
Need Help to write an email into the desiging fonts style
This community is very unique and here people are very helpful so I am here to ask a question about the fonts style my question is I like stylish font style from <a href="https://anchorfonts.…