Formula needed:

Hi I need a Formula to find the different between the 'Horas Ganadas Real' for each week Example w37 5024.30 - w36 4660.10 = 364.2 for each week

Ninox DB viewed in a Wordpress Website

Hi there, I would like to know if is possible to share a DB to be consulted by anyone in a Wordpress Website. If yes, how can I do that. Thanks

Can I use a "sum" function to add up just the items found through a search?

[Bear with me, I'm still new at anything but the most basic ways to use Ninox.] Here's my case: I've got a simple db set up to catalog a comic book collection.…

• Answered

Trying to copy Date and Date + Time to new Field

I imported some date info but noticed some lines have dates and other lines have date + time. Ninox couldn't seem to get the import correct in all cases.…

Ninext loading modules not requested

Hi @Jacques TUR I just saw that my DBs are now loading all modules even when I specify only specific ones. Here is what I have in my formula: var configLoadModules := { badges: true, evalJS: true,…

custom size of a module

Good morning, I would need to open a form with custom dimensions, as if it were an alert popup, could someone help me?

Moving To Ninox from FileMaker

I think Ninox is brilliant, but I need to be able to access the data programmatically using a language like Python, Go, JS, or similar to so some automations.…

GANTT Export

Is it not possible to print or export a GANTT view? If not is there any plan for future? thx

Ninox Version Number

How do I find my current version number of my Ninox database. I click "about", and it takes me to the Ninox Webpage.

Array trouble after update

I have some code that creates 2 arrays of records, which I then combine thus:- array(thoseDirect, thoseDupes) The combined array then gets used in a Dynamic Choice field.…

The Formula don't work. For Approval view

let me := this; if 'Rev 0' != null then 'Approved Rev.0' = 0 else if 'Rev 0' is not null then 'Approved Rev0' = 1 else 'Approving Signature' := "Signed by: " + " " + userFullName() + ";…

• Answered

Automatically go back to the first tab

Hello everyone,how can I automatically return to the first tab every time I open it? thanks

how to parse a location from google geocode json?

I am able to get the JSON to return from the google API call, but when I attempt to use item function to parse the JSON, I am getting errors. I attempted to use the solution at Parsing…

Select multiple rows from en embedded table

Hi everyone, the tile speaks for itself but I will use my own database as an example. I have a database that contains information about art objects. Under the heading 'Administration' I have embedded…

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…