Welcome to the Ninox community

SELECT with where doesn't work where [] does

Guys I am puzzled. This works let filterCat := text('Category Filter'); let filterMonth := text('Month Filter'); let filterYear := text('Year Filter'); (select Expense)[contains(filterCat,…

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