Copy fields definition within a table or across tables

@Jacques TUR I am addressing this question to you, as you came with amazing and so useful solutions for Ninox : the search fields usage, or multi language implementation are so smart....…

Copy table including line items from subtable, to another table and subtable)

Hello everyone. I am trying for a few days to get this working but am stuck. Maybe someone can point me in the right direction. I have a table "Quote" and it has a subtable "quLineItems" where I add…

• Answered

Dynamic coloring of a number field

Hi folks, On a number field, I would like to highlight if the number exists already by coloring it red. I tried different approaches with functions and conditional coloring.…

• Answered

Calendar Month View - More Information?

When I look at my Appointments in the Calendar Month view, I see very little information compared to Week view. I desperately need to see a similar block of data according to the Show as settings.…

• Answered

Code Simplification - Loop ?

Hello, I am trying to simplify this code let num := number(Deduction); let rec := record('Taxes/Deductions',num); let ths := this; if rec.Calculation then ths.(Calculation := rec.…

• Answered

Multi-Choice (Dynamic) Field

Ahhh, Multi-Choice (Dynamic).... Truly a wild animal. I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.…

• Answered

unknown base type undefined

I have just created a HUD toggle on/off field pair, yes/no toggle with formula to hide icons. I have created a load of them so know what to do. But this error is popping up for a new one I have…

• Answered

Create Button PDF

Hi . I have the 3 lines script on the Button (Crear PDF) my report name in Report_1 and need to view it in Emisiones (field pictures), the pdf The script don't work, some help ? Thanks

• Answered

Two fields sum

I have two fields and in the third it shows me the sum of these two fields. They must be summed if one of them is not equal to zero. Can anyone tell me the formula please

duration() format?

I'm using duration() to find the duration of an appointment. However, it always displays as h:mm. I've tried all kinds of format() and can't get it to show as just h.…

Sum of fields for a period of time

I have a table "credit_Fill" and the second table "Tables". In the Credit table there is a credit field, in which credits are recorded that are related to a particular table.…

• Answered

How to select current register within 'select' function

Hi, I need to select all records linked to XXX register in a given table . i.e.: Table named 'VEHICLES': Registration: XXX S/N: YYY etc which has a child table called 'Status' and which has some…

parseXML: Assign corresponding elements of same hierarchy level

Hi everyone, I am trying to import an XML file (GAEB, German construction industry format) and I want to create a Ninox table from it. The XML file always has some categories and one category can…

popupRecord for child record via button

Dear Support-Community I'm new at using Ninox and I try to figure out some things. I want tho give the user the possibility to go directly to a child record with a button.…

• Answered

Sort table by month name in numerical month order?

I have a table grouping data by month. When I leave the column as month(my_date) I get months 1...12 and the table is nicely ordered Ascending from 1 to 12 (my choice).…

ninox Docker image

Hi folks. Great to be part of that amazing community :). I can't pull the ninox docker image mentioned here https://docs.ninox.com/en/private-cloud-on-premises/docker-installation .…

OpenAI - GhatGPT

Hi there, Has anyone played around with ChatGPT for Ninox yet? I have just this minute registered on OpenAI and having a look around. It a code generator based on natural language input.…

v3.7.11 on MacOS does not like Ninext

Hi all - Anyone else having issues loading @Jacques TUR Ninext with the latest version on MacOS? I just upgraded, always while holding my breath, and when I open a DB with Ninext I get:…

• Answered

Global function to work with out all parameters

Is it possible to have a global function that works with out having all parameters defined? Right now I can't see a way, but I'm just diving into global functions.…

• Answered

Database for money management

Hello, i am trying to create a banking database. I want to setup two (or more accounts) with the option to create positive and negative transactions for the specific account,…

Select using []

I have two related tables Projects and Work Reports. In the scrren shot below you can see Projects (formula) in the Projects form and below the View of the related Work Reports.…

Hours accumulated

Hi, I have a list of time records ordered by date, i.e.: - 01-jan-2022, used time 01:30 Hours - 02-jan-2022, used time 00:25 Hours - 05-jan-2022, used time 02:35 Hours. ...…