Count number of records that fulfil a search criterium

Hi! I have a table called Residents that are based in different towns. Each resident has their town as a field entry in a drop down list that includes Gothenburg, Skaraborg, Ludwigsburg.…

Extract year from date field in text format

Hello. I have a date field in text, format DD/MM/YYYY. How can I have an fx-formula field that returns only the year? For today, 15/09/2022, the formula field must return 2022.…

Sub-Tables - Add existing record

Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…

• Answered

Script for transfer record N:1

I had to create an additiona table with relation N:1. Table A Reference N:1 to Table B On Table A now I have records included and I need to Include them in the Tabke B, isthere any scripts to do that.…

• Answered

Detect list selection

In a table view/list, select a row and the form slides out. One can move the selection up and down the list and the form data changes to reflect the selected row. Standard Ninox behaviour.…

Get data from unlinked table

Never finish! I have "Service" table that contains: Insurance End Service Date Linked Table "Car Registry" Data From a "Repair" table I have to make a formula to calculate the price the customer has…

Update Reference field from Text Field

Hello everyone. Assume I have 2 tables. 1. Customers -- It includes a field named "Company Name" 2. Service Reports -- It includes a popup field named "Customer" where I can select the company name…

• Answered

Ninox Database for Mac - New Entries not Saving

I have Ninox Database for Mac (3.7.6) running on a MacBook Pro laptop with macOS Monterey 12.6. I have a large “Home Inventory” database with 859 items, that will no longer save any new entries.…

Problem with creating PDF after update

Hello Everyone I need your help, because the only answer, that I am receiving from Ninox is - take a part in our Webinar! I have the following problem - my system is working already more than two…

Google Maps - iframe in Ninox

Does anyone know if there is a sample DB that uses a location field in conjunction with an iframe to display a location field in a map?