-
New to Ninox - How to create and link a "lookup" table?
I'm creating a Media Collection database consisting of 3 main tables; one for LPs (albums), another for CDs, and a third for DVDs/Blu-ray Discs (movies).…
-
Create a sales ranking
Greetings, I am from Ninox members (sellers), and I would like to create a sort of ranking based on the achievement of monthly goals. Eg: I have Massimiliano who has a sales goal of € 10,000.…
-
How to duplicate a record with reference to the original one?
I am using a button-script like this let d := duplicate(this);d.(“Yes / No” := false);d.(Customer := 0);popupRecord(d) This duplicates the record and empties the fields: “Yes / No” and Customer.…
-
Question
I need help identifying a particular year in a multi-year database.
-
Switching between databases
I use 2 databases back and forth - is it possible to write a code snippet on a button that when clicked closes "DataBase1" and opens "Database2" - and vice versa?
-
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.…