double click in cell to activate input - buggy sort of

I notice that the 2 x click in a cell does not always work as expected. I recall others having this problem and advising how to get around it. Sometimes when I 2 x click the record slides in rather…

Retrieve the data from a button variable

Hello! I have a database in which I have a table "Dashboard" which is the page that displays when I open Ninox and another table "Accounts" containing all the contact details of my customers.…

• Answered

Is there a way to automatically display an attachment in a formula/image field?

I have paperclip attachments and would like to see them without opening/viewing via the paperclip. Is there some clever script that can be used to display the content of an attachment on screen via a…

create options in choice field from variable/loop

It's easy to fill a dynamic Choice field with options from a table/query but how to dynamically create options through something like var options:=[] for i from 1 to 3 do options:=options + i end;…

• Answered

conditional unique() in column

my view should select all records in elements where the column "text" is unique for one label (being a linked record). So text "a" might appear both for label1 and label2,…

• Answered

Version 3.11

Where does one find this if it is in the Public Cloud New colour themes in Ninox settings New colour themes are now available in the Ninox settings to give your application a modern look.…

Dynamic Dropdown sorting

Is there a way to sort the contents of a dynamic dropdown?

Reference field trigger error

Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…

• Answered

Coding a popup dialog in a for loop if error

I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…

• 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

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

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

Collaborator field options

Is there any way to display more than the default for a collaborator field? For example displaying the email address for the collaborator in an adjacent formula field or in the drop down selection of…

How to open an image through a function field.

I have an image for a registrant in table A I display that image in other tables using a function field. Is it possible to open that image by clicking on the function field?

in Print pdf when..

如何将这些元素居中？ （红线） 谢谢！

Single Dynamic field that populates other fields

I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…

• Answered

How to display image in original quality?

I'm trying to display some charts made in excel (because ninox chart making is way too complicated) with an image field in a form view set up as a dashboard.…

import duration values from Google Sheets

Hi New to Ninox but not databases. I have a sheet in GS with titles & durations of musical scores. The format are 00:00:00 (hours,minutes,seconds) how can I import those values to Ninox?…

Formula help

Hi to all! i am trying to activate function through a formula to open specific record. this is the formula: html("<button class='customButton' onclick='openMaster()'>Open Master</button> <script>…

• Answered