Script Editor will not accept known field

It is probably me! but after much head scratching I need a bit of help - PLEASE! I have the below script which has been working perfectly fine for a couple of years.…

• Answered

API find relationship

Hi , Is there a API endpoint or a way to find what tables have relationship to other tables. I am pulling up my list of tables and list of fields in each table.…

Change a field's background color: is this possible?

Hi all. Suppose a table with two fields: A and B. If field B is not empty, then change the background color of field A to green. Is this possible? If so,…

How to change the alignment of a button of an alert

Hi. I have created an alert after the user needs to cancel a record. The problem is that by clicking on the "ok" of the alert the user also opens a record again.…

Print and Delete buttons are not active

Hello friends, Can someone please help me understand how can I activate the "Print" and "Delete" buttons on the default Table View in Ninox. I am developing this CRM for my employer that is being…

Automatic Calculating an end date based on new records

I'm quite new in Ninox and have a question on how to let Ninox calculate an end-date based on newly added records in a table I have created a trigger whenever I change the status of a cow to add a…

• Answered

Print Layout is not being saved

Hi there, i am using Ninox standalone version 3.10.11 on MacOS in sync with iCloud. I have made an extra Print Layout and saved it. But when i close and restart Ninox the Print layout is disappeared.…

help please on this script

The following works but not fully. None of the text: >>> Is outputted in the email. Can someone please point out where my error is. let myPdf := printAndSaveRecord(this, "TASKS"); let myName :…

• Answered

Displaying a record in another table

Hello There is table 1 in which there is table 2, record there are made using the button. 'tab.name' - 'number' - 'group' In table 3 there is an sub table 5.…

Assign a sound to a formula button

Hi to all! Thanx to @RoSoft_Steven (who created this post: https://forum.ninox.com/t/35y3lcz , I am using custom buttons. In my record, I created an embed of a small player that plays an mp3 file…

Ninox 3.13

Hello, I just watched my first Nioxus webinar and am excited about the upcoming release. Is there a link to the official Ninox 3.13 presentation?

Countdown Date

Hi, I have a problem with a formula I would like to calculate how many months from today to a certain date this as written but it does not give me any results.…

• Answered

Button that creates a new record for the next month

There is a button that creates a new record in the table for the next day let t := this; let oldData := last(Table1 order by Date); let newRec := duplicate(oldData); Table1.…

• Answered

ninoxLocales.AggregationName is not a function

Hi there I received the following error message yesterday: "ninoxLocales.AggregationName is not a function". What exactly does this mean? Nothing was changed in my Ninox formulas or fields so I don't…

What is the max number of characters that a text field can be defined to hold?

I am using Ninox stand alone - no need to sync to the cloud for my purposes. I have a d=table that includes a text field, but have found I cannot add as much as I had hoped to - is there a maximum…

html undefined error

Hi, What in this script is causing the title error please? let myPdf := printAndSaveRecord(this, "TASKS"); let myName := "New Task.pdf"; importFile(this, myPdf, myName); 'EMAIL SENT' := true;…

Ninox hanging, not letting me edit and very slow

Hi guys, since yesterday I have not been able to work on my ninox db as it is hanging and going into a readonly mode. The order of events is as follows: Yesterday,…

• Answered

Problem with "choice" the correct operation of fields

Hello I encountered a problem with "choice" the correct operation of fields. In the formula field heve funcrion Display field only, if : 'Show 14' > 0 and Choice = 1 or Choice = 3 or Choice = 4 when…

• Answered

How can I add additional fields to the returned array?

I want to add a newline character after each comma in an array. For example, Original code. for loop in select Customers do loop.'Customer information' end Returns Value. [116.3219065673952,39.…

• Answered

Printing with Carbone: Changing line height in table with newlines

Hello, In ninox, I have a table which contains text with new lines. Example: "Introduction This is an example..." When I first printed it to Carbone it would not display the line breaks…

How to disable Create Record button in reference

Hi, This topic was brought up 4 years ago and was closed with a reply about the cloud version of Ninox, however there was no solution suggested for the local Mac app version of Ninox.…

Why can't I move these formula fields?

I'm using formula fields to display an image stored in another table, based on what is selected in the table reference popup field. The problem I'm having is that the formula fields are being forced…

Designing Dashboard or Home Screen

Hello friends, I am trying to design a dashboard/Home Screen for my ERP database app. I am not able to divide the screen in two vertical parts (left side with some buttons like Clients, Sales,…

Calculate the percentage if this result is negative

There is a field, "RESULT", where the result of the past day is shown. I need to calculate the percentage if this result is negative

The multiplication function stopped working

Good evening The multiplication function stopped working. previously worked without errors. after adding a style to the field where the information comes from, it stopped working.…

• Answered