Is it possible to add a condition at the beginning of the table?

I am using concat here to display the data from (invoiceitems.‘1 or 2’). Is it possible to use conditional statements in the code, for example: if it returns 1, then display 0; otherwise,…

• Answered

Regarding the issue of matching records after splitting the data.

I have created three tables: "product," "invoice," and "Create." In the "Create" table, I have set up a button. I want to quickly create orders by clicking the button.…

• Answered

Argument with Ninox AI and reference field

Hi, I'm new to Ninox and the AI option is just an amazing lifeline I have an argument with Ninox AI that asks to establish a "Reference Field" when I am supposed to open from the attached…

Is there another way to display the filtered data?

I want to display the data according to the SHOW in HOME, but I can't sort it by the number of repetitions in descending order. Is there a way to use Functions to display it?

• Answered

Buttons in Tables View (Ansicht) needed

I need to have the possibility to have few buttons in the view of tables, because i want to have a list of different Students and then have a button for each day and if i press a button,…

Dynamic choice (programatically selected)

Hi All, My doctor only wants to see the items that are relevant to an appointment. Items is a dynamic choice field. I am able to find out the items that he can't charge for that appointment,…

If condition not working with comparison operators

Hi, I have got a headache trying to understand why can Ninox scripting engine comprehend such a simple If condition together with "and" and "or" operators: let currentDate := today();…

• Answered

Questions about loop code...

let aa := this; let mois := ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; let sommes := [];…

• Answered

(JSON) Object parser Browser vs. Client

I am despairing of what I would call a bug. I have a function (global) that works fine in the browser, but fails in the app and breaks the entire global script.…

• Answered

loop in query for view -- how to aggregate?

I use the below formula for a view and a dMC. Yet, it will only return the last record i, not all of them. When I create a button to alert all i, it will prove the loop works correctly.…

I encountered a very strange problem.....

I encountered a very strange problem. I set up a table in one of my databases, and the code is as follows: let Table := (select 'Procurement').--- <tr onclick="ui.…

Regarding the issue of popping up another table record from a table...

I set a button in table1 to jump to the first record of table2, but there seems to be an error. Where could the problem be? Thank you for your help.

• Answered

A question about writing HTML code.

I have two pieces of code. I want to write the table data from code one into code two while retaining the style of code two. How should I write the code?Their structures are different,…

Regarding the issue of modifying a sub-table of a sub-table.

Created an order database. The Orders table records the product details of an order; the Products table records product names and quantities; the code table records code information, etc.…

• Answered

Help with code to create non-repeating set of 10 numbers

So I'm working on trying to create a non-repeating set to 10 randomly selected numbers between 0 and 9. I have this in a formula field: let x := [number(void)]; while length(x) < 10 do let newItem :…

• Answered

How to use code to remove extra information?

I have set up two text elements in the database, and text1 contains the following information. 2222 333 44553 1234 How to set up a button to remove the extra spaces in the content of text1?…

• Answered

POS System ( Sales,Income,Expenses,Stock,Supply)

Hello, I have been working on a POS System all created in Ninox, What I'm trying is that when the sale of 1 product happens (Sales Table) the product is deducted from the Stock table and money added…

Embedded eCharts into Ninox

I have tried to embed eCharts into Ninox but have yet to succeed. For example, I put the following code inside a function field, but nothing: var _style := "* { margin: 0; padding: 0;…

• Answered

Sub table query - limit to current record

I have a table -> Event Details and a subtable - Event Expenses. Each event can have expenses of different types, there is a "Type" field in the expense table.…

Script to update records in another table

So I for this scenario I have 2 tables. One is called DID the other is called E911. I have data in both tables. In both tables there is a piece of information that may be the same.…