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

Need help with my JS/HTML Kanban Board

I've been working on a selfmade Kanban Board in Ninox for some weeks now. I am a beginner and just starting courses + searching for code snippets everywhere.…

Button script to select all items in defined Dynamic Multiple Choice field

Contents In a jewelry database, I have a series of Dynamic Multiple Choice fields to identify items and add them to orders/invoices. As an example: Choose Items in Article table with Dynamic…

Using a table selection in script

Hi, I'd like to be able to scroll through a set of records in a table and update values on each record. I want to select the records using the selection feature on table view, as used for bulk update,…

• Answered

Delete all attachment from a subset of record

Hello My plan is to delete images from records older than 2 years. I am thinking of the following steps: 1) Identify records older than 2 years. 2 then I need to delete the images from the database.…