All topics

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

How to fix an error

Hi, I'm using the iOS app (3.13.6). Recently (once in a while) I get the error: TypeError: undefined is not an object (evaluating ‘this.query.database’) This happens (not every time) when I'm trying…

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

Avoid new records

How can I avoid adding records in the main table?