Scripting and Functions

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.…

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

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

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.…

Hide button if selection in Multiple Choice

I need to make the button "ESENZIONE BOLLA" appear only if the flag is active on DAF FF 058 PS 2600KG in the dynamic multiple choice field. Otherwise I need to hide it.…

• Answered

Converting a text string to a multiple choice field

Hello! I've been having trouble figuring this out and I would love some help. I have a work flow that involves a potential guest (school groups visiting our site) filling out a form that…

• 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…

Change lookup field based on the year

I need to look up one of two fields depending on the year. The two fields are labeled as follows: ‘2022-HHG-Mileage’ and ‘2023-HHG-Mileage’. Then, the correct field name needs to be inserted in the…

• Answered