How to create a button that clicks through forms

I'd like to put a button on the first tab of my form that, when clicked, opens the next record down on the table. The same as using the down-arrow on the keyboard.…

Link a subtable to a phantom table

I've been stuck on this script since last night. I want to create a phantom table from the Quotes table and the Prices sub-table. Everything works fine,…

• Answered

csv export problem.

'Ver Archivo CSV' := null; let xMd := 'Busqueda por Mes'; let registros := select 'Datos Transferidos' where month(Date) = xMd; let csvContent := "Cliente,Date,Transferido Dato 1,Transferido Dato 2,…

• Answered

POST multipart/form-data query to external API

Hi everybody, I need to post data to an external API who accept only "Content-Type: multipart/form-data". Ninox http function seem able to send only "Content-Type: application/json".…

save archive NOT IMPLEMENTED

Good day when I try to save archive as from cloud to my mac it shows up a message NOT IMPLEMENTED. how can I resolve this? Thanks

Secure Ninox API calls

Hi, I've just started looking into the Fetch API to make calls to the Ninox server from the Ninox client side (web app). I'm a bit worried about exposing the Ninox API Key this way.…

Sort concatenated values in table view not working

Hi, I have a parent table "Programmes" and a child table "Works" . In the "Works" table I have a number field called Order and then a field which combines the WorkTitle with the order…

• Answered

Dialog not working.

In the 'Trigger on new record' I have the following let title := "Serial and/or Bundle Required"; let message := "Does this new record need it's Serial Number logged? If so is it part of a Kit/Bundle?…

Passing Dropdown Value to Another Page

Hi everyone, I'm trying to pass the value selected in a dropdown on my Dashboard page to a dropdown on my Job Setup page. Here's the setup: Dashboard Page:…

• Answered

3.13 Popup Close Delay

Has anyone else experienced a delay when closing a nested popup window? When closing a popup window for a subtable, the one popup closes and then there is a slight delay before the parent record…

Dynamic multi-selection in the subform: Display of selected and unselected items.

I have an inspection form that needs to ensure all items are selected at least once. I would like to know which items are missing from the inspection in the subform.…

access a specific user inside a ninox function that's called through the api

Hi everyone, so I'm accessing some table in ninox through the ninox api with an api key. For security reasons, the api call is done through an external script,…

Not all fields showing

I have 15 fields but only 8 is showing how do I change it to show all the fields?

How to create a column in a view with a sequential row number

I have searched the forum and did not find anything that directly answers this. i have a table with two columns gross and net values. I created two views each sorted by the Gross value and the net…

• Answered

History in calendar

Hi all, it seems to be that every time I do something in calendar, it will be marked as history on top og each date. Does anyone know if it is possible to hide this history for the end user ?…

Duplicate a sub-table while omitting fields.

I have a table that I duplicate using a button and a script for which I received help on this forum. This table has a sub-table which is also duplicated.…

• Answered

Problem organising a report.

I've just followed Andy's video on this page: https://www.youtube.com/watch?v=_FA5-uMV8u8, which explains how to make a report. However, in my version of Ninox (for iPad),…

Calculate Cumulative Time with Code

Hello everyone, I need a piece of code to calculate the continuous days of placing orders for sales (using weeks as the time interval). For example, today is Friday,…

• Answered

Formula returning a record causes type mismatch

I have a formula that returns a record. This formula works fine. But whenever I try to use the returned record in a then or else branch, I get a type mismatch. The formula field is OrderItems.…

Create new record in another table and transfer all fields across

Hi, I have created a table that I am using as a "kiosk" type function where external parties can enter their form details. Once they click on a button called "Sign In" I want that data to transfer…

• Answered

Using Ninox ChatGPT to create a search

Hi, My first shot at creating a button to search a field (RTF) to find and mark results. I have a field SEARCH for the search terms and the RTF field is NOTES.…

• Answered

V 3.13.3 - Database import impossible

Even if I create a new empty database on my MAC and export it to icloud drive I could not import on iPhone or iPad any more. Nothing happens. If I try to import it on iPhone with the "Files" app and…

calculate stock

Hi all I have a table "Fakturalinier Materialer" (Invoice lines articles) from which I want to control my stock. Therefore I made this calculation for a start, for later to set the stock value,…

• Answered

Search for words (not sequencial) in a string

Hi All, I need to create a search field where I put two or more words on a string and try to find it in a query result. The problem is that with the "like" I could add more than one word but they…

Email multiple BCC receivers.

Does anyone know what is wrong with this code? let sender := userEmail(); let bcc := "receiver2@mail.com, receiver3@mail.com"; let receiver := "receiver1@mail.…

• Answered