All topics

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

Does the 'page' feaure work on tablet devices?

I have created a 'page' in a database using the 3.10.x versions of Ninox on both an ipad and an Android tablet. However, the page 'elements' (views, relationships, etc.) seem to be non-functional.…

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

Alert not working

I have a formula that looks for duplicate records and if it finds one or more than it should bring back an alert. Not working anymore. Any suggestions? let xLast := 'Last Name'; let xFirst :…

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