-
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
-
Time to create more work for myself...
Never to leave a functional DB alone, I decide to correct some poor DB design. As you can see in the picture, I break the tenant of not creating multiple fields that store the same type of data.…
-
import an Image from WEB
This procedure allows you to download an image from a public website and display it in an Image field: Usually, I go through the following steps: Image Field text field labelled in this example…
-
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
-
Analysis of your database structure with Ninext
Here's a JavaScript code snippet for analyzing the contents of your database. This code can be run from the Ninox console when Ninext is installed : #{ let tables = Object.values(database.schema.…
-
Known difficulties when using dynamic printing and their solutions
Since version 3.7, many users have reported success with dynamic printing through Carbone.io, as it enables customizations that are still missing in the Ninox print editor.…
-
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:…
-
This is how I run ChatGPT in Ninox app
Hello friends :) Please find code below, allows to run OpenAI ChatGPT in your Ninox apps. It is connected to button OpenAi. After click it sends content of yourPrompt to ChatGPT and display raw…
-
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
-
Interesting HTML functionality
So I have a dashboard with three formula fields that show HTML tables. Here are the Leagues and their respective colors. Now on my dashboard the GCL League looks like this:…
-
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free.
The Ninox Learning Lab is offered most Thursdays at 12pm EDT/ 5pm BST/ 6pm GMT and is free. The Ninox Learning Lab has provided training and support to thousands of Ninox users all over the world…
-
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