Issue with the 'select ... where...' function

Good morning ! I create a personalized address book in Ninox. For each company, there are several contacts and I need to display the names of the company's managers only.…

• Answered

Ninox API issue

Below am able to query the records But while trying to use `where` am getting `null` why ? ``` { "query" : "(select 'Klant_Client' where 'Skinvision_Customer_Id' = 'FX0000000108_412').…

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

Info radar chart

Hi ! I would like to use a radar chart to create a wheel of life. Example : The data comes from 10 number fields that can range from 1 to 10. the problem I encounter is that if no field contains the…

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

Can Anybody help me about Dynamic Print Layout ?

Hi, I'm not a programmer, I need somebody that can help me to create a Dynamic Print Layout for my business. Is there anybody interesting to work on it ?? I will pay for it.. Thanks all. PS..…

Button to Send Email (PDF)

In this Table I have a Choice Field, I select one of the three option pdf Report, on the button I print the pdf on a image for each Report, now I need to send vía EMail the Report selected.…

Multiply a number to get a status

Hi ! How would it be possible to modify a loyalty status (which corresponds to a number) according to the sums spent. Example: the threshold for changing loyalty level is every €600 - Case 1:…

• Answered

Clean field when i duplicate table

There is a table 1 and a button to make it a duplicate for a new day with formula let x := dialog("NEW DAY TEMPLATE", "Do you want create template for a next day?", ["No", "Yes"]);…

• Answered

Bug button

Can someone tell me what is wrong with my button? I would like my button to generate a pdf file and then send the pdf by email as an attachment. When I create 2 buttons,…

• Answered

Number as written text?

Hello, Is there a way to format a number into text e.g. 1 - one, 2 - two etc. THNX Kruna

• Answered

Trying to find a solution (pivot view??)

I have a simple trading journal database. My main form collects initial trade data with opening "trade date". I have a sub-form in that form to collect data for any further adjustments to that…

How to contact support???

I have tried email support@ninox.com, contact form https://ninox.com/en/support/contactus and a phone number. My subscription have expired and I need to speak to support before renewing it.…

• Answered

Send mail with attachments from different tables

Hi ! I would like to know how can I send by email, as an attachment, the documents for lines 29, 40 and 51? The "Documents" table is not linked in N:1 --- Générer les textes ---; let nomFacture :…

• Answered

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

Dynamic value formula for choice field

I have a table called “contacts”. One of the fields in that table is called “group” and that is a choice field. One of the choices is called “Guests”. I have another table called “entertainment”.…

Printing?

Seems so hard to get a print layout. Is there a way to create a form that can be used to print? I see either a list print view, or a one page per record print view.

List of attachments in the sendEmail() function

Hi I have the following problem - I am trying to send a list of attachments in the sendEmail() function. Only unfortunately the files in the email can't be loaded.…

Need transfer only the Approved.

I am using this table for the documents that will be incorporated into the main Documents table as scope changes, will not be included in the main table until the scope change is approved by the…

• Answered