Use choice fields in a formula field

Hello, Here is what I have: - A number field called (Bedrag) where I put in a value, the number field is in an parent table called (Kosten). - A choice field where I have 6 options in parent table…

• Answered

Reading JSON list

Hi, how can a list of JSON objects be read like all the values nthe "Monthly Adjusted Time Series": {"Meta Data": {"1. Information": "Monthly Adjusted Prices and Volumes","2. Symbol": "MSFT","3.…

Payments plans and Location Fields, demo

Please please, I need an option for monthly payment. I cannot afford yearly payment. Also, I need a demo Then how does the location field work?

Blue Screen of Death

For whatever reason, Ninox has now given me the blue screen of death. When I access the app on my iPad Pro, it goes through the normal opening, showing my desktop with my databases but with a…

BUG or what?

Hi to all! i am experimenting a simple dashboard formatting fields in a CSS way: the problem is when I go out form this and open a new table: you can see the consequences if I refresh the page:…

• Answered

Extract Record from a Table meeting some criteria

Hi to all, i have a table called Album, with a relationship with another Table Called Release (1:N) Each album could have 0, 1, or multiple Releases i am trying to extract in a formula field the name…

• Answered

Dynamic Reports - my first attempt

Hi there, Here I was thinking it would be straight forward. I have a docx template and in Word I added {d.'PROJECT TITLE'} as a data field (it's spelt correctly, all UPPER).…

• Answered

Close all windows except the active one

Hi, Is there a way to have a button that closes all the windows except the active one (from which I click on the close button of the other windows)? Thanks for your help.

• Answered

Is there a way to output a PDF file with the contents of one RTF text field?

Ideally, one =would press a button and the contents of the RTF text field would be outputted to a PDF or WORD file and downloaded to the host. IS THIS POSSIBLE? Can this be done in JS?

Override result in formula field

I've got my hourly rate field working, it fills in the field based on the number of hours in the Appointment. But... can I override the result. Can I override any calculation field's calculation?…

Join without empty lines

Hi all, I have a few fields (yes/no) to list all the papers that i might receive from people when they sign a contract. Let's say it's a list of ten different documents.…

Automated Multiple Choice: Is it possible?

Is it possible to automate Multiple Choice field based on trigger/update from another fields – which is two or more fields. See situation below: Multiple Choice (MC):…

• Answered

Re-connect iPad v.3.8.17 to database stored on iCloud

I have the mac desktop app with the database shared on iCloud --which is accessible on my iPhone app (so it the basic sharing works). However, suddenly the database doesn't appear on my v.3.8.…

• Answered

How to get passed time in months from two dates?

Hi there, I hope you can help me out. I have two date modules: 1. Date: 01.01.2020 2. Date: 01.01.2021 How to create a formula which tells me how many months have passed? (12 months?…

• Answered

Calculating hours from Appointment

I bet there's a better way of doing this: if text(duration(Appointment)) > "2:00" then "More than two hours" else if text(duration(Appointment)) > "1:00" then "Two hours" else if…

Database corrupted - Local database

The local disk was full and iCloud got confused and was trying to upload and download at the same time. After this, Ninox opens with a corrupted database. Only some data showing in tables.…

create a new record in subtable

Hello,I have an invoice table and a sub-table for the invoice items. I'd like with a button to reproduce the same behavior as when I create a new item when I'm on a record of the sub-table.…

Run python script from Ninox

Hi to all. I don't know if running a python sfript from Ninox is not possible and just for fun i asked to the AI. Here's the response: To launch a Python executable from Ninox,…

How to pop up a dialog if a record in a table meets a criteria.

I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…