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

How to Unlock PDF With PDF Unlocker ?

I have a pdf file i need to unlocked how can i unlock my pdf pleasss help me

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

Show value in Choice (dynamic)

Good evening everyone In d table "Mine Table" - "Table1" field "Choice (dynamic)2" need to show table records from "Wendors" - "Name" - "Salary" - "unit" I can't create a formula for the select…

• Answered

Export to excel

Hi, Is it possible to export a table to excel to a specific folder of your choice and execute this with a press of the button. So using code. Tx Regards Michel

Formula for deriving the value

Hello I am attaching a table because it will probably be difficult to explain and will confuse everyone. Everything is done and configured in the table,…

• Answered

Trigger on create with numeric fields

I am creating a table from another table with trigger on create with this code. let a := Factura.Cliente.Cliente; let b := Empresa; let c := Monto let d := Fecha let p := (create Flujo); p.…

• Answered

Dynamic Choice/Multi-Choice

Hello, Is it possible to add a list item to a dynamic choice within the Dynamic Value code section? For example, I have: (select Building where Entity = ent) order by Entity.…

• Answered

Regarding issues with editing the chart code

Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data…

Duplicate a quote a change its number

Hello, I have a quote table. On «Trigger on new record», I have that script: let myLastNumber := last(((select Quote where 'Quote #') order by 'Quote #').…

• Answered

goto another record from calendar

Hi there, have anybody ever tried to jump to a record from calendar where the record I not the one which created the calendar event. I have this situation that I am in a table where I create a…

Print Report Layout

I noticed I cannot access the Print layouts to edit etc. when using the latest Ninox Mac app vers 3.13.6 I have a script that prints out data using the previously built layouts,…

How to write code for data filtering?

How can we filter out the top three salespeople with code? Xiao Ru $382.00 Jiang Ningwei $648.00 Xiao Ru $1,704.00 Jiang Ningwei $2,883.00 Xiao Li $11,760.00 Yang Daibing $4,640.00 Li Yanping $980.…

• Answered

adding eg 7 days to a date+time field

Hi, I just cant figure out how to add days to a date+time field and I couldnt find anything in forum. Lets say eg 15.10.2024, 9:00 date+time field := date(year(date+time), month(date+time),…

• Answered

Delete view tabs

I'm trying to learn how to use Ninox. I'm coming from 20 years of Filemaker. I clicked on the + to create views (Table, Chart, Kanban, etc.). Now I'd like to delete these tabs,…

Dynamic printing and join tables

Hi, I have several join tables set up because I need the many to many relationship. So I have a Programme table that links through a join table to a Staff table for ex.…

• Answered