-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Disable Duplicate Function
Hello, How can I disable the duplicate record function for one of my team members?
-
Switch Case statement in Ninox
Another great structure in Ninox that can help you in the automatization of your processes is a Switch Case statement. Simple syntax, fewer lines of code, and faster result in your app.…
-
How to "scan" a table?
If I want to loop through all records in a table, how do I do that? I don't see a way to create an independent script I can call. So, even within a button,…
-
Set Choice Value
Hello, I am creating a button to set a value of Box1 to 'Active' (id1). How do I set the choice value of clicking the button instead of: Box1 := 1 I tried: Box1 := text("Active") Box1 := "Active:…
- Answered
-
Question new functions
Found some new functions in the .js files. Anyone knows what these functions do? createTempFile(string,string) and appendTempFile(string,string) or are these not yet implemented?
-
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free.
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free. The Ninox Learning Lab has provided training and support to thousands of Ninox users all over the world…
-
Delete all attachment from a subset of record
Hello My plan is to delete images from records older than 2 years. I am thinking of the following steps: 1) Identify records older than 2 years. 2 then I need to delete the images from the database.…
-
Creating Chart with Multiple Series
I've searched around to see if Ninox supports this, but can't find anything. Can I create multiple series for 1 Ninox line chart?
-
Weird browser constraint bug
Hi all - I've encountered a strange bug with the browser vs app with a constraint that is based on a choice field. I have reference field that has a constraint and it was working in February.…
-
transaction or deferred
the query below currently takes almost five minutes (browser) with just 30% of the final data expected. It's okay to wait this long , but I was wondering if anyone has an idea how to tweak its…
-
Duration in days, months and years
I'm fairly new at Ninox. I'm building a research database for history data in which we use a lot of dates, for ages, duration of events, etc. An easy readable display of duration would be great for…
-
Help with a search
I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…
- Answered
-
openTable() with sort order.
Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…
- Answered
-
Copy to Clipboard
Is there a Ninox function now? I was looking for a way to copy the content of a field and found this post from way back: html("<button onclick='copyToClipboard(""" + concat(SERIAL) + """)'>Copy to…
-
Count of records in joined table
I have a table for our Corporate Events we plan called Event Details. There is a table named Staff that is joined to it containing all of our staff. One event could have multiple staff and a single…
-
QR Code management
Hello everyone. I would like to start managing QR Codes in my database. I saw on the forum that creating a QR Code is actually quite simple. “It is enough”, in summary,…
-
A new way to comment out code in the console
With my friend Jan, we discovered a new way to add comments in the Ninox console. Simply add /* before and after the text you want to comment out : var a := {lastName : "tur"}; /* var a := {firstName:…
-
attachments: Add from another table
I have a child table in which I have an email button. This is the script: sendEmail({ from: "alan@blah blah", to: EMAIL, cc: " ", bcc: userEmail(), subject: "A new Task has been added for:…
- Answered
-
Ninext not closing in spite of "True"
Just started happening in the last couple of tries. When I open a database the Ninext loads but the dialog which is set to close (true) does not. Anyone else have this happening? Cheers
- Answered
-
HTML/Rich Text does not work on print record
I've noticed that HTML and rich text do not display in the required format when printing a record. Instead, the text is displayed normally. Does anybody know a work around or whether Ninox plan to…
-
Link multiple records to a parent record
Hi everyone. I develop a database for creating a schedule for trainings. I have table with clients' applications for trainings and a table with training groups dates.…
-
Create new incremental record within a selection
Good morning, I have an application to issue work requests. These requests refer to different car license plates. I would need a code that would do the following.…
-
Select result if more then one - Rest API
Hi, I have an API-Code in Ninox let auth := { Authorization: "Bearer TOKENNR", 'Content-Type': "application/json" }; let Paiva := 'Inserisci p.iva (solo nr) o cod.fisc.…
-
Bug in MacOS v3.8.7 and iOS v3.8.11 app
Hi there - I seem to be having an issue with some code that doesn't do what it is supposed to do when I add "do as server" to it. This happens on iOS v3.8.11 and Mac OS v3.8.7.…