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

Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

I have an issue with a trigger in the 'Liste' field. I would like to create multiple triggers in the 'Liste' field that check if certain text is contained within it.…

• Answered

how to add to variables

Hi, This seems like a basic question, but I can't work out what I am doing wrong. I have two variables, and I want to create a third variable that is to be the result of taking the second from the…

an you please help me optimize the code structure?

I have a piece of code as shown below. The entire code contains three 'switch' statements, but the 'alert' reminder no longer works after running. Is it not possible to have 'switch' statements…

• Answered

Query Help - Count of records in joined table that meet X criteria

I have a tables called Staff and Event Details. There is a join table called event_staff_join to show what gigs they worked. The join is "Relationship from Staff to event_staff_join (1:…

How to run chatgpt or Claude…

Hi is it possible? I’m not a programmer. I understand ninox script, I can write some simple things but still: it’s far from REAL PROGRAMMING :)) I want to achieve simple things,…

• Answered

How to send double quotes

This is a littlebit connected to question about ChatGPT. I'm searching, trying, fighting... Now the idea is, that I can't proper authorize wit OpenAI API.…

Icons Problem

I use Ninox in the web cloud version. Lately I've noticed that the style of the icons has changed. At the same time, "styled" functions containing icons and text are no longer displayed correctly in…

• Answered

Is it possible to merge two records in same db?

I have a contact db and wanted to update the records that originate in Google Contacts. I created a csv and mapped the fields, then mapped the fields with identical labels, e.g. First Name, Surname.…

• Answered

The problem of writing N:1 code.

Hi there, I have two tables, (HOME & copy), both contain an option named 'Y&N'. I want to set up a button that will copy the selection status of 'Y&N' in the 'copy' table to the corresponding 'Y&N'…

• Answered