Hide multiple elements at once

Hello friends, I am trying to hide two or more form elements (text boxes) from within the "Display field only if" setting of one of the elements. How can I achieve this ??…

Performance Issues on Ninox – Has Anyone Experienced This?

Hi everyone, I'm experiencing some performance issues with Ninox and wanted to see if anyone else has had similar experiences and found a solution. Compared to when I first started using it,…

Help with a bit of code

Hi, I have some code on a button that generates 4 bookings a year, currently it generates bookings for: 1st March, 1st June, 1st September, 1st December What can I change in the code below so that it…

Getting help, where has it all gone!?

I use Ninox but rarely need to create a new database. I've managed to build solutions for myself in the past with some help from the forum and the documentation.…

google script POST to Ninox not working

Hi, I want to send data from Google Sheets to Ninox with API. In Google Script editor I added the following code (so its not a Ninox code): function updateNinox() { var sheet = SpreadsheetApp.…

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

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

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