About the issue of allowing edits only when conditions are met…”

I have created two tables for employees’ orders. I want to allow modifications to Customers.text only when Orders.Salesman is the same as Customers.Creator.…

• Answered

How to locate N:1 relationships that contain data?

I have created an Orders table that is associated with three tables named after people's names. I want to use a code snippet to locate the associated tables (the ones that contain data).…

• Answered

Triggers and table conditionals limitations in Local/Cloud

Hello. I am on the Starter subscription and I found two problems: The same Trigger on create that works in any workspace (cloud) does NOT work in local (in MacBook app).…

• Answered

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