-
Help to figuring out work around for MacOS app
Hi all - For those with access to the MacOS app and a cloud subscription. Upload the attached DB to your cloud account and as a local DB. With the MacOS app: Start with the cloud DB.…
-
Checking if a record has been linked to another one
Today I noticed an unexpected (to me - as non professional coder) behaviour when checking if a record is linked to another one. I haven't found info about it in the forum nor the documentation,…
-
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.…
-
Automatic adaptation of views
Hello everyone. I would like to know if there is a solution so that the views adapt in height (number of rows) automatically according to their content.…
-
Create nested array in the form [[51.12344,34.876342],[26.987430,45.123459]]
Sometimes third-party programmes require data in the form of a nested array. Ninox is unfortunately not able to create these simply with the array function.…
-
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.…
-
OPENAPI
I'm trying to write the openapi-api code to import company data from the VAT number. I can't figure out how to tell which value to put in which field. I don't understand anything about API but I'm…
- Answered
-
Proper Syntax for counting any combination in a multiple choice field that includes at least one selection.
I have been trying all sorts of syntax along with using +, and, or to no avail. Here is my formula. let xStart := 'Start Date'; let xEnd := 'End Date'; count((select Chronos)['Date + Time' >= xStart…
-
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. -------------------------------------------------------------------…
-
For each record
Hey, Really new to this - so bear with me.
I have table full of OrderNo. (Salesheader) Once a month - I need to fetch the related invoicing costs from a HTTP request.…
- Answered
-
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.…
-
Using a Dynamic Choice and filter for records.
Hi, I raised this on Tuesday Ninox Webinar and sorted it out using the conventional related table look up method but I am trying to use, for the first time, a dynamic choice field.…
- Answered
-
Unique / Concat giving different results
Hi all. I have a table showing Orders, in which I have Items that are linked to Products, which each have their own Product Categories (in a multiple choice field).…
- Answered
-
Determine Net New customers via Select Statement for Dashboard
I would like a formula field that will represent the number of clients we have in a month that are first time customers. We are an event company. This will be via a field on a dashboard I'm creating.…
-
Formula ID count also deleted records
Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…
- Answered
-
Formula turns into letter references
Hello, I am wondering if anyone else has experienced this. I am adjusting some of the structure of my app, and therefore have removed some fields and added new ones.…
-
Wrong ID in Multiple Choice?
I have a multiple choice field where I write a Note, and then assign it a Note Type. I'm trying to make a view where I can see what the Note is for ones that are "Issues".…
- Answered
-
Mail table
Hi, I would like to send a table via email. Is this possible! Regards Michel
-
Reverse Order by
Hi all - I was blown away by what a FB user posted in the Ninox English forum. I don't remember seeing this any where else. To do a reverse order by you can just put a "-" in front of the field name…
-
chatGPT - Ninox code
Just for laughs I asked chatGPT to give me some sample code for Ninox. This was offered: Second request it offered Let in place of var
-
displaying map/location in iframe in Ninox.
Is there a sample DB that has an iframe that shows Google Maps of a location field in Ninox? If not can anyone help with a solution? In other words once a location is found a formula field displays…
- Answered
-
Laptop vs iPad
Hi, I have a database with code. When I perform a certain action (processing and saving) it takes about 4 seconds on my laptop and less than a second on my iPad.…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…