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

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

Dynamic Multiple Choice Field - How to Programmatically Assign

Hi - the latest Ninox update has lots of interesting new features to play with, great to see it launch. Dynamic lists is something we've all been clamouring for.…

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

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