-
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
-
Display a maximum number of data
Hi! I use a formula field to display text data which is itself from another formula field which contacts data. I would like to find a solution to display only the last 5 lines and not all of them as…
- Answered
-
How to pop up a dialog if a record in a table meets a criteria.
I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…
-
Sending emails - ChatGPT example
Can anyone confirm if this would indeed work in Ninox? I'm guessing not. do you have an example of code for sending emails using Ninox ChatGPT Certainly!…
-
What3Words
Has anyone used What3Words in any way shape or form with Ninox.
-
JSON: add a block based on a given condition
Hello. I am creating an XML file and would like to start with a JSON because it offers greater readability and ease of maintenance. In the structure of the JSON how can I decide to add blocks…
- Answered
-
How to style a numeric fields?
Good morning! I've had issues with the styled() function these days and after having read several articles in the forum: it seems that the stlyed() function converts the variable to text.…
-
Those pesky"" when you don't want them.
Just noticed that if you want to comment something out and you type the first " - you get the second ". Well that I knew already which is annoying. On the off chance I selected the word/line first…
-
Delete a record and related records in other tables
I have a table named « Accounts » which is the main table where I add all my customers. From the Accounts table, I created a Yes/No field which has the mission of deleting the selected account…
-
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.…
-
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…
-
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,…
-
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.…
-
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 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.…
-
Matching Phone Area Codes to Region
So, for a lot of Data I receive, I don't have any location material besides one's phone area code. I know that the area code is not the most accurate in todays cell-phone age,…
-
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…
-
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
-
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
-
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