-
Using a button to select related records
One of the tabs in my property management system shows rows of diary entries for the selected property and one of the diary fields is a choice field for Type such as Repairs, Tenant, Lease or Council.…
-
Calculate Distance using 2 location fields (Road miles)
I am working on a project for a friend that works for a delivery service. The table is called “Deliveries”. In this table I have 2 location fields, “Restaurant Address” and Customer Address”.…
-
Use a button to increase the value in a table - counter
The reason is pretty silly but.. When we go with the car with the family there is a game: each red car is 100 points, yellow is 1000 and green 2000. I wanted a basic form with three botton for player…
-
How do I split a table?
I've got a very simple Ninox database for storing notes. There is only one table with the fields "SUBJECT" (a text field), "NOTE BODY" (a rich text field) and "PICTURE" (an image field).…
-
on click example please
sadly i can not find anything about the new on click trigger feature. can anyone post a quick script example for this feature. thank you
-
How to make a field that compile datas from an other table in an array
Good evening, I am quite new to dtatabase and here is what I want to achieve. I will use an example from the tutorials video : I have a table that describes an hotel.…
-
Circular Reference
I had some formulas on a few fields that worked fine. When i tried to introduce some qualifying statement, they suddenly fell apart, giving me "Circular reference" errors.…
-
Results in form not showing in table
I have some results i can see in a certain field of my form. However when i look in the view of the table, no values appear. The results i can see in my form are from a formula field.…
-
Can I default some values of a new record to be the same as the previous record?
I'm working through and adding lots of records manually as we work on a project. It would be really useful if I could set a few of the text fields so that they default to the same value as the…
-
Switch statement stop working?
I noticed that in the new version 2.6.0. (and 2.6.1.) the switch stetement is no longer working.Did anyone else notice this? Ninox Mac App
-
Changing ID numbers
Hi, I'm new to Ninox. I want to add new records, but I don't want them to go to the default at the end, I'd like to be able to insert them in between current data and have the ID numbers adjust…
-
Way for "guest" to "accept" a job and have it update database
Hey all I have a system set up to send jobs to our warehouse, which is pretty good except that I don't have a way for them to automatically accept the job (they get sent an email from the DB,…
-
Multiple Forms for Printing
I use multiple forms when I print from a Table. Such As Employement Application, File Folder Label etc. I have set up individual buttons to print the forms however after I have selected one and then…
-
how do I delete a table?
how do I delete a table?
-
Anybody else seeing strange character sets within text field in the MacApp?
I have a text field that I type a JSON string into.. something like { "foo" : "This is foo", "bar" : 77 } When I use parseJSON.. I got an undefined error..…
-
Database too big?
I don't understand why my Database is so big: 3,2 GO ? The architecture looks very simple: 3 tables (houses, visits, customers) with only on relation (houses-visits-customers) and for each table…
-
HTML text
Hi, before the last update in the "long text" field I could paste text keeping html formatting. Now it is no longer possible. Why?!
-
How to calculate years and months from a date to the current date?
I am new to Ninox and haven't yet learned the scripting language. I need to calculate the length of time in years and months from one of the dates on my form and insert it into another field.…
-
How can I reference the present record/table in a select statement?
I want to use this select statement in a trigger after update in my Projects table: select Invoices where SameAsProject = true and Client = Client I want the first Client to reference Client in…
-
Multi-dimensional array
I'm just pointing this out. The Table is an array of objects and it can be assigned to a variable. I don't know what the size limitations are, however. If you made a Table generic enough,…
-
check box report : When yes print X
when I set a "checkbox" field yes / no. How do I get an "x" for Yes and empty for no in the print report? tks
-
Please create a configuration management utility that can be used to export / import design configuration between Ninox databases.
I am going to add this into the Change Request database. but I thought I would also add it here to get more feedback.. Please create a configuration management utility that can be used to export /…
-
OpenFullscreen
Esiste un modo per aprire un modulo alla massima ampiezza alla sua apertura, senza creare un pulsante? Ho provato la seguente formula Let a:= the If num !…
-
Print report not the same in iOS and Mac OS compared to web app
Cannot print čćžš letters or emojis using printout with web app. It works perfectly using iOS and Mac OS (desktop app)
-
Since Ninox upgrade on the Mac, rich-text fields are now read-only
I can no longer edit my rich text fields since updating to 2.6.0 on the Mac. The previously-entered info is all there, but the fields have become read-only. Any cures?