Dynamic reports with JSON formula - loop

Dear all, Bonjour, Je travaille actuellement sur un rapport dynamique qui a besoin d'afficher un enregistrement à imprimer, ainsi que des sous enregistrements.…

Problem with dynamic report

Hello to the community, Hello everyone, I have a problem with dynamic reports. I created a word document with the tags but my mac application crashes every time I try to test printing.…

• 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

iOS calendar entry duplication

Whenever I update a date entry in my Ninox database, my calendar entries on my iPhone are duplicated. That is, if I have a calendar entry from the database for, say,…

Getting pdf file from the API response

Hello API experts! I would appreciate your help saving/opening a PDF file, which is the response to an API call. This is the code of the API endpoint call inside a button: let url := "https://testeps.…

• Answered

Account flows

In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…

• Answered

Lead Scoring Assistance

I need some help creating a formula to build Lead Scoring. I have created a formular field in all Lead Records called Engagement Score. I want it to build a score based on their status value with…

• Answered

Constraints issue

In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…

• Answered

What is "Handle file as" in Image field properties

Hello! In this "Handle file as" selector there are options like: Size Small, Medium, Large, Original size. What do they do really? I thought that selector compresses the uploaded image or keeps its…

Create a Date showing Day of Week, Month, Day of week

I have a simple date input where I choose a date. I would like it to show the day of the Day of the week, Month and day of month. For example: Friday, December 15, 2023 Instead of the default "Dec 15,…

Export .csv to excel not work

https://youtu.be/Eo6WUmG86fE The Scrip on formula is: let me := this; --- GENERAR COMBINACION FILTRO ---; let myCon := ""; myCon := myCon + if Alpha then "X" else "_" end; myCon :…

• Answered

Build a Report Advice

Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…

Is there a known problem with dynamic printing?

In the last couple of days, all my attempts to dynamic print failed. Even if I try to print a blank page, I continually get an error message! Does anyone else face the same problem?

• Answered

Convert XML API call response into JSON object.

Hi, after a successful call to a public API, the response that I get is of the following form:…

• Answered

Lost something here

• Answered

Using triggers for yes/no field

I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…

• Answered

Email - SendMail - Verses EMail field triggering local email client

So as I have been using Ninox a number of years now. I thought it about time I asked on of those stupid questions! Every day I send various emails to clients - using SendEmail every day.…

Button to open a PAGE

Hello Ninox Brain Trust, Has anyone been able to open a PAGE with a button?

• Answered

Code about random numbers

I want to write a code for generating a random number that consists of six digits. The number should change every month, reflecting the progression of time.…

Word Wrap doesn't function when you apply a rule to a table

Typical of Ninox, they implement a nice feature with rules in the table but then mess it up because they don't completely make the feature work cosmetically.…

Reference Error

Hi all, I started using Ninox a while back and so have completely forgotten all that I learned when setting up my data base. Now when I want to duplicate a record I get this> ReferenceError:…

Help with multiline text field inside an html() function

Hi, is there a way to display a multiline text field inside an html() function without losing the multiline feature? I mean, when a use html(" + 'multiline text field' + ") the text is displayed as…

• Answered

Close the cell after editing

Hello Everyone I have a table, where my colleagues can write there requests for vacation. I need to protect somehow the data after adding from future changes. For example - I need a vacation from 05.…

Bloccare documento emesso

Buongiorno...ho il seguente problema che non so come risolvere: Ho creato un record (che rappresenta un documento fiscale contenente prezzi e date). Vorrei che una volta emesso e stampato,…

Questions about charts

I found a problem with my chart today. My chart has three sets of Edit columns, one for product names and the other two for numbers. They are all in the same View.…