Sum of values if condition is met - looping through records?

Given a table 'invoices' with a numeric 'value' field and a choice 'status' field (status being 'pending' and 'paid') how can I iterate through all invoices and calculate the sum of all paid invoices…

Is Ninox Currently Down?

Is Ninox down for anyone else? At first we were not able to make any changes to existing orders. We'd get an error to a log file and it would say it was read only.…

Comment pouvoir récupérer les données d'un enregistrement antérieur dans un nouvel enregistrement ?

Bonjour, J'ai une table client et une table réparations, si un client revient avec une réparation pour le meme appareil, j'aimerais pouvoir récupérer les données de l'appareil déjà inscrites dans…

Formula to populate a multi-line text field

I'm looking to populate from separate field the name, address1, address2, city, state, zip in a multi-line field that has the look of an envelope address. Yet, I can't find 2 things.…

what!!!!

Hiding Title or/and Columns Names in Views and References

Is there any possibility to hide the columns name?... in many cases if I have a view and the Name of the View (which is mandatory) I dont need (or dont want) to spend additional space...

Dynamically fill a drop down from another table

Again, I'm new. I have 2 drop downs I wish to populate from another table. Example: Odds (table) has field names "team" and "image". I'd like to pull this data from the Team (table). Thnak you.

Open file attached to a record

Is there a formula or a function I could you to enable me to Open a file attached to a record using a Button. By clicking a button the file attached to a specific record would popup. Thank You

Is Ninox ACID complaint?

Is Ninox ACID (atomicity, consistency, isolation, durability) compliant?

Results from Choice Field in If Then Else Formula

I have a Choice Field set up with 5 selections. I want to use the result of the selection in the Choice Field in an If Then Else formula. When I place the text result of the Choice Feild selection in…

Filter to show only free company stuff

Good morning, I have a table with all the company staff. Each one of them is selectable to insert it in an event. Is it possible to filter people and show in the stuff selection table,…

Delete Multiple Records?

Is there a way to delete multiple records?

Google and Ninox calendar doubts

Good morning,I have been trying to synchronize events created in ninox with the google calendar for some time. Unfortunately, the best I have been able to do is to create an .…

on writing html web-links

On a web site, the link to somewhere could be shown as for instance "Click here" and the link: https://scandiproof.com/products-dk.html would be "hidden".…

Referencing Field Names across tables with Variables?

I have two tables, HerbInventory and Client. HerbInventory just contains records of all the herbs I have, and I want to be able to prescribe herbs in the Client table.…

Use aggregate functions in a single table database.

I have a database that is a single table. Is there a way that I can use aggregate functions within a single table? Am I missing something?

Edit formula with URL in print layout

Hi, I have a table with 2 fields : FIELD 1 ( text : hotel name's) and FIELD 2 (url : website ) On my print layout, I have a subtable and in one of the columns I would like to create a link on FIELD 1…

Help open generated attachment file

I created a script on a button that creates an .ics file. I would like it to automatically open that file at the end of the script but I can't because it adds it as an attachment to the record.…

Display Field Only referencing Multiple Choice Field

Hi there, Im making a form for multiple services a company offers. At the start I have a multiple choice switch field with 6 values in it, one for each type of service.…

Displaying number of records in a sub table on each record

Hi there, I'm new here. I'm backing a database to store sales for my company. I have a table for new orders which has a sub table which is where I add the items to the invoice.…

Comment créer une requête sélection dans Ninox ?

Bonjour, En principe, on retrouve dans une SGBD le trio : Table/Requête/formulaire. Mais je ne vois pas comment créer une requête dans Ninox, sur laquelle s'appuierai un formulaire ? Par exemple :…

Condition formula with time

Regarding this code: (The formula was accepted.) if 'Game Time' > "4:05 pm" then"Flex"end However, it does not return TRUE. Thnak you!!!

Receive End Expected

Sean thank you for answering my last question := (fielda - (fielda - 2) * .35) / 6 I receive "End Expected := line 1 column 2 (I'm brand new to Ninox so appreciate your help