-
Count If... function help
Hi I need help on a formula for my database.. I have a field called Procedure, this field has several posible choices (different procedures), lets call them A,B,C,D,E,F..…
-
Print
Hi, i maked button in form of invoice items, then when i changed a goods i click print form and i can see in attach. Problem is when i change for example items and will print againe ,…
-
How to reference choices in a formula when the choices have no text
I'm trying to make the choices displayed in field A depend on the choices selected in field B. But I want the choices in field A to be icons with no text.…
-
What is "Handle file as" in Image field properties
Hello! In this "Handle file as" selector there are options like: Size Small, Medium, Large, Original size. What do they do really? I thought that selector compresses the uploaded image or keeps its…
-
Relationship between 2 tables - how to?
Hi I'm a musical director with a choir. I need to track which songs are going to be sung at each rehearsal. So I have created a table with all the songs:…
-
Auto-populate pricing from another table?
Ok Ninox wizards, now I'm trying to auto-populate some pricing and job details. Here are the top level details: Main table is 'Job Status Log' which has 100s of job entries that are connected to my...…
-
Trying to find a solution (pivot view??)
I have a simple trading journal database. My main form collects initial trade data with opening "trade date". I have a sub-form in that form to collect data for any further adjustments to that…
-
Help in making queries
Hello i have a db (many thanks to @Fred ) and now i need to make some queries. In a table where i have a list of "transaction", (sum of products sold and product returned) i want,…
-
Close to giving up on Ninox
I am so frustrated with Ninox and their incapable developers. I am mainly using the iPad app (I have a 12.9" iPad Pro) but also the web app. Neither one is working reliable and full of bugs.…
-
Create records from dynamic multiple choice
Hi guys, I hit a bump trying something new: I have a dynamic multiple choice field called 'Keuze kritieke fases' I have a subtable 'Kritieke fases'. I have a button that I gave following code on…
-
Sending invoice by mail?
Hey guys, i love this database i am building, ninox is quite powerfull! Id like to know if there was a way i could create a button on my invoice page that would add the invoice as an attachment in…
-
Connect customer to E-Mail - Help
I am working on making a new e-mail area that can use e-mail templates. I have it all set up and kinda of working but it has problems see screen shots and info.…
-
Unique Field in a table
sorry but I didnt fund it in the documentation... my bad probably How can I force a field in a table to be unique? eg a field that is used in a N:1 table relationship...…
-
Call a button from a trigger
Is it possible to call a button from a table or field trigger. I have 2 applications for this. 1) I have a very long 'Trigger after update' on a table that was easer to work out as a series of…
-
Adding links to records in the child table on the form using a script.
Hello! I can't figure it out: I use a script to create new records in a child table, but they don't appear in the child table displayed on the form. Please help me find a discussion of this issue!…
-
Create a New Record with a Button
Hi all, Please could somebody help out I am trying to setup an 'accept' button on one record which will create a new record in a different table - carrying over the data in each element of the form.…
-
Hosed table
I needed to change a field from Choice to Dynamic Choice. So I created the new DC field and set up the correct data. Deleted the original static Choice and renamed the new DC one to the same name as…
-
Icon and Colour field types
Is it possible to set the value of these field types within a formula? As an example, I would like to set an icon field to a green tick icon if something is true or a blue cross if false.…
-
Date Field Question.
Is there a fast way to enter a date? The best I have found so far is jan12001. I would like it if I could enter it like 1/1/01. Also, can the date format be changed to show as 1.1.01 instead of this?
-
Page breaks in Print view
Is there any way to add a page break in the form print view/layout?
-
Dynamic choice field - showing Id instead of description in print view
Can anyone help please, this is driving me mad. I have a table called 'Inspection Report', and within this is a dynamic single choice field pulling from another table called 'Mechanical Services'.…
-
YES / NO Default value
in the table I am using a yes / no switch. How to do it so that after switching to YES or NO, the value will not be changed for the next days, until it is changed.…
-
Modify a function
Hi, I tried that function. let myV := Ordre; if cnt(select 'Ajouts familles-Tableau 1'where Ordre = myV) > 1 then "Duplicate" else null end It works but when there are duplicates all the duplicates…
-
SPAM!!
The SPAM posts are just HORRIBLE~ On the Latest Activity page, I just kept scrolling/"Loading More", etc, .... many pages. And the problem is once you've opened a post to read ...…
-
Blog Post NINOX 3.3.0
Hello, just thought you'd like to know that the blog post (after selecting link "Read More") ... displays this: (.... can't add photos to posts! :-<<< ) (the >> before each "Ninox" indicates an image…
Answer questions and share your knowledge