How to use order by with constraints

Hi, Say, I have two tables (T1 and T2) table T1 has a reference field Ref1 (from table T2). I have successfully been able to implement constraints in the reference field to only show selective…

• Answered

Send Email no error, but don't work

let today := today(); for i in select INVOICE do if i.'BALANCE DUE' > 0 and i.'DUE DATE' - 7 = today and i.Reminder = null then let message := "Estimado cliente, su factura #" + i.…

• Answered

Sending requests to an external server

What options are available for sending requests to an external server and receiving responses with data for the cash register and store in the local version of Ninox?

Chart with "where" on subtable

Hi All, I'm been trying to do this for ages and I can't figure it out or know if its even possible to do what I'm trying. I have a page called "Performance Dashboard",…

• Answered

make Ninox the cell text bold

Given that I know little to nothing about html coding. and usually use a sledge Hammer to crack a nut! God know why Ninox would give us property change values to text input fields ( had this for…

Issue with true value stored in number field

I am having a bit of trouble with a selling price field and its associated (extenedSell - field which is a formula field in my image below I can iner my cost price then either key in the sell price…

• Answered

Issue with sending data via HTTP request in Ninox (JSON format)

Hello Problem Description: I am trying to integrate the eKassa API with my system via Ninox and send data using an HTTP request. However, when attempting to send the request with data in JSON format,…

Output format doesn't  work for me

vTme: format(Time, "hh:mm"), vTo: format(To, "hh:mm"), vThrs: format('Total Hrs', " hh:mm"), I have two time field, Time and To. Other formula field (To - Time) the output format doesn't work for me

• Answered

Image disappears, replaced by spinning wheel

Hello, I have just tried to add an image field. When I upload an image, I can see it normally. When I move to another record and then return, the image is gone and has been replaced by a spinning…

• Answered

Multiple Choice not working on iPad/iPhone app

For a few weeks now i am not able to choose an option from a multiple choice field both on the iPad and on the iPhone app. Still working perfect on the Mac.…

Different color for field of text

How can you give a title to a field or the field itself a different color?

• Answered

Compare two fields from different tables with summing

I am trying to compare two fields that should have the same data, and where one or there other doesn't have a matching, I'd like those to be in the list as well.…

• Answered

file unzip Fail

Hi, When I am trying to import Ninox database from Dropbox into Android phone I get "file unzip Fail" message. Even though the database appeares in the app list. And even opens.…

Issues with sorting in an overview of linked fields from another table

If a reference is made within a table to another table via “Choice (dynamic)”, the correct data is displayed in the form. However, in the view, sorting is based on the ID of the subtable,…

• Answered

Word Template Problem

let vTbl := ((select 'EAT Documentos') order by Areas); let vObj := vTbl.{ vTotal: sum((select 'EAT Documentos').Presupuesto), vFGst: format('Fecha Real 5', "DD.MM.…

• Answered

has the 'styled' function stopped working?

no colours are showing: let x := 'First Message' + 'Zoom message' + 'Appt Day' + ", " + Appointment; if 'Appt Date' < today() then styled(x, color(214, 214, 214),…

DELETE multy attachments

let method := "DELETE"; let rid := text(this); let teamid := first(select Settings).DatabaseTeam; let dbid := first(select Settings).DatabaseID; let tid := tableId(this); let file :…

Create a custom component in Ninox

@Jacques TUR Hi, I was wondering if it was possible to create a custom component in Ninox using programming that we can reuse in any project. If this is possible at all then what is the starting…

file in .xlm format

In Italy, there is the "electronic invoice", a "document " in XML format. Would a function be possible to create invoices according to that standard? Thanks.

Populating a linked record by code

Hi all, This is likely to be a really basic question, but I just don't seem to get this to work. I have a patient database. Each patient has multiple prescriptions that are filled at a specified…

• Answered

Send Email Only Once

Hi Team, See attached screenshot, I have a field called "contract renewal date" and a formula on the "contract renewal status" as per the below. How can I ensure the email only sends once?…

• Answered

Request Regarding the "+" Button Formula in Ninox

Hello! I need to know the formula for the "+" button located in the top-right corner of Ninox, which is used to create a new record. Actually, what I need is to close the current record and…

Open a custom URL in Ninox

Hi, Is it possible to open a concatenated string url upon clicking the URL button of the URL element. I have a url element that has a value "scan.Polygon.com" in it.…

Looking to automate record creation based on a date

Long story short; I have a 'Tenant' record, which has their 'Rent payment date' in a date field. I've so far been unable to find a way to reliably create a new record triggered by a date. I.e.…

Embedding HTML code?

Hi there. I'm trying to embed the following graph chart from TrendingView to my dashboard but cannot make it work. Any ideas as to how to make this work? <!…