-
Concatenating all fields in a record
Is there a simple way to concatenate all fields in a record into a string? Of course we can do it explicitly:Field 1 + Field2 + ... But I mean is there a builtin command or function (or any other…
-
Chart - pie
Is there any easy way to show a pie chart with data, for example, how many statuses do I have? 100% all rececord status "done" =? etc
-
Update but only non-existing records
Hi, I am trying to update a subtable but I want that, if it already certain certain records, create only new ones. With the code below if certain records exists, it is duplicating the records.…
-
Force form size
Is there any way to force the size of a form to fill the whole screen when a user clicks on a row of a view ? Jaime
-
Get Line Items From One Table And Add Them To Another On Button Click
Hi, I have a table that contains Orders and in that table is a sub-table Pricing which has to fields - Description and Price.I have created another table named Invoices with a sub-table named Inv…
-
Variable Scope / Empty fields
Hi I am using this code in a "Save" button to avoid empty fields in a record: let MyError := 0; if Nombre = null thendialog("Attention", " ""Nombre"" puedes estar vacío", ["OK"]); let MyError :…
-
Spreadsheet templates
I need to create two databases, one for product inventory control and the other for accounts payable and receivable. Would anyone help me with a model? Lucidio
-
Mac App Crashing
I have the current version of Ninox and Mac OSX 10.15.3. Ninox has been crashing a lot lately. Without warning or any beachball spinning, it is just gone. No crash report to sent.…
-
Boolean If/then/else help needed
I created a simple Boolean if X & Y then A * B else end (sample code below). The idea is for us at our school to only enter date ranges and then have the contribution fees to run the school…
-
I've constructed a database to track revenue and expenses on a number of individual funds. The table titled funds has the general info which is stored in a child called balances and then a grand child called revenue. Each fund has an annual record. I've set up a button to begin a new year and it does start the new balance. It creates a revenue record but connect back to the balance child. Here's the code. Any thoughts?
let currentRec := this;let Nyear := last(Balances.Year) + 1;let Nbeg := last(Balances.'Temp. Restricted-Total');let Nperm := last(Balances.'Perm. Restricted-Total');let i := (create Balances);i.…
-
Ninox webminar in North America
I have been following Andy Marks's webinars on Nioxus.com for over a year now, and I have learned plenty about Ninox functions, scripts, etc. These one-hour webinars are available every Thursday at…
-
How to automatically fill in the field "user" data of the user who created the record
Hi, How to automatically fill in the field "user" data of the user who created the record
-
Attachment locally or in a cloud?
I have 45 licences of Ninox and went my students used the attachment button they only store there files locally. It is normal? so when I check in the database I don't see the attachment
-
Technical Question/ How to choose the lowest value from several fields in a record?
Hi there- I am new to Ninox and was wondering if anyone had any bright ideas- I basically want to just choose the lowest of three fields that are prices of the same item form different suppliers and…
-
Createtextfile: dimension file
Hi, I am using the formula CreateTextFile to create a file.txt in which I have to put a precisely number of characters and I did it completing the field with rpad formuala.…
-
Riportare righe di un documento in altro documento
Salve, dovrei creare da un preventivo un documento di trasporto, e trasportare nello stesso le righe del preventivo. ho provato con la seguente formula, ma mi cancella le righe nel primo documento.…
-
How to create balance table from income and expense tables
Hi. I two tables: 1. Income table - consisting of several fields and a formula named "total income"2. Expense table - with "expense amount" field. How can I create a balance table that will show…
-
Layout PDF View
Hi :), I'm working on my invoice template. The issue I have at the moment is when I had more than 10 Items on it, my invoice goes into 2 pages (wich I don' mind) but split this part ( see picture)…
-
How to avoid a column to be filtered from the table list view?
Hello. How can I avoid my users to change a established filter from "yes" to "no"? I mean, the result is always in "YES", but I can't allow them to change the filter into "NO" (or remove the filter).…
-
Create button in Ninox that composes an email using email client
Hello, I was wondering if anyone can help me with a script that will allow me to compose an email, where the data is across 2 tables? I want to compose an email from a Quote layout I have built,…
-
SQL to sum the sessions for only the current month
Hi, I have this code behind a button and when I click it I want it to populate a table with various information (which is partially working) let me := this;for i in select Pupil dolet myInvoice :…
Answer questions and share your knowledge