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. ...…

Very simple excel formula not translating across to Ninox... what am i doing wrong?

Hello All I need to calculate the trade price of an item based on the shop margin. In excel i use the formula: RRP * (100% - shop margin) But i can't seem to replicate this in Ninox.…

• Answered

Reorder tables?

Is there any way to reorder tables? They are added to the end on the right. I would like to be able to drag and drop them, but I do that unless I'm missing something.

Need to show only the Deliverables that will be issue in the next 7 Days.

Need to show only the Deliverables that will be issue in the next 7 Days, from the DataDate. I need the script that give me information, the information must be taken from the dates FechaP1 to Fecha…

• Answered

Upload a single file with POST API

Hi all, Can please someone help me with the following API call within Ninox? What am I doing wrong? I am trying to upload a document in a record and I call this http request from a record with a…

Button to make record

Еhere is a table where all clients are written, and in this table there are several more sub tables. We created a button separately from all tables through it we make entries in all tables.…

• Answered

Pretty star rating field?

Any suggestions for making a pretty star rating field? Here's what I've got and I don't like it much: If you've done something better looking (or even different) please share. Thanks!

How do I do a text calculation (e.g., First Name & " " & Last Name)

How do I do a text calculation (e.g., First Name & " " & Last Name)? So, if the contact's first name is "John" and his last name is "Doe", I want to create a Full Name calculation that yields the…

multiple languages

Hi everybody, Is there an easy way to crearte tables in multiple languages ? I have a company in diferent countries, where they speak different languages.…

Formula Help Needed

How do I write the formula to display only if "Field" is not like x, w, or z? This is what I have so far but it does not work.

View not showing top line on update

I have a view in my form that's tied to the choice a user makes for Client (a --> linked table). When the user picks a new Client, the view (of their Pets) updates but many times (most times) the top…