-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
How to create a unique list of records
Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
-
import an Image from WEB
This procedure allows you to download an image from a public website and display it in an Image field: Usually, I go through the following steps: Image Field text field labelled in this example…
-
New functions
Hello everyone, I put up this post to list all the new undocumented features of Ninox. I started a post here (https://forum.ninox.com/t/g9hs0n7/v3-7-11-new-functions) but its title limits it to…
-
Button for create a new record which has a connection to a record
I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…
- Answered
-
Hiding elements - HUD control
In case this might helps folks here are a couple of helps. Please feel free to add anything to this post that relates to the Title. -------------------------------------------------------------------…
-
POS System ( Sales,Income,Expenses,Stock,Supply)
Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…
-
Ninox script to work with csv files
Ninox has a convenient wizard for importing (.csv) data which is well featured and easy to use. If you regularly work with data contained in csv files, you may be keen to to avoid retracing your…
-
CSS Framework & Ninox
Hello, I recently realized that Ninox allows us to use a CSS stylesheet file directly from a CDN link. I wanted to know if we could use a CSS Framework to design a Ninox page faster and more…
-
Has anyone wanted to hide the add new record button on the popup link?
simply add a formula with CSS and add the following .stringeditor-button2 {display: none;}
-
New 3.6 Script Editor
Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…
-
how trasform a time interval into a number?
How can I calculate the cost of a working day by multiplying the number of hours worked by the hourly price?
-
Look up value in table based on two other values
I'm new to Ninox and am trying to set up a database for a distillery's production records. One thing I need to accomplish is a formula that can look up a value in another table based on two inputs.…
- Answered
-
Customized button
Hello everybody, I added the buttonEvent to Ninext. This allows to dynamically change the caption, the color and the help title of a button. Just add the onUpdate function in the "Display field only,…
-
Ninext : Debug Tracer
Hello everyone, For some time, I wanted to offer you a possibility to debug your programs. I am happy to present you a first debugging tool. It's simply a tracer to display the messages coming from…
-
Character Occurrences Count
Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…
- Answered
-
How to get a filtered sum() from a table-value, where all have a common category?
I need to get the sum() Formula working that it not only gets me the sum of a specific field of a table, but also a filtered value. Like, all data-entries have a numbervalue and i just want to have…
- Answered
-
Progress Stepper in HTML.
Ever wanted to create a step diagram to point users to the steps to follow in Ninox? Then this can be done with a choice field but a nicer representation is with HTML and some CSS.…
-
Accessing a single line item on an invoice
I'm trying to pull the TOTAL value of a single line item in an invoice that has 3 line items consisting of £195, £56, and £18. After trying everything I can think of,…
-
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…
-
Multiple Choice Field - How to get possible values/choices
How to get all possible choices of a multiple choice field? With choose() I can get only chosen values, but I need all.
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
Enter the content of another field inside a rich text field
Hello again. I'm just ending the development of a custom application that needs to print and export some rich text fields with lots of text. What I need is some kind of "data merge" inside a rich…
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
Numeric array variable initialization
Hello there. I'm stuck with a somehow simple problem. I can't create a variable type array and initialize it unless I enter a number. Take a look at this code: let myArray := [];…