Scripting and Functions

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

Help with Google Charts in Ninox

So, I just wanted to start with a very basic Google Chart in ninox. With Google's default data, the chart shows, however when I try to replace it with my data it no longer works. Below is my code.…

How to select different options in bulk?

I have a table, and I want to select 'Star' as 1 for all 'old code' less than 100, and as 2 for all 'old code' greater than 100. How should I write the code in the button? Thank you for your response.…

• Answered

generate PNG invoice files?

Can Ninox directly convert PDF to PNG and other image files? Or generate PNG invoice files? If so, how to write the code? Thank you for your reply.

Multi language solutions best practices

Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…

• Answered

Thoroughly delete image elements with code

I have image elements in a table. I found that using the code "Images:=null" does not completely delete the images. How can I use code to completely delete them?

• Answered

Payment of several unpaid invoices

Hello everyone, I have something difficult (for me at least), but I'm not afraid of you, I trust you :-) I have built a database of my finances. All good so far,…

• Answered