[HELP] Ninox Can't Perform Basic "Sumif" Function

I have two tables: "Orders" and "Line Items." The "Orders" table records the Orders, while the "Line Items" records the items ordered associated with the Order ID from the "Orders" table.…

need help with the replace function!!

I get an error on the replace line output2 := ""; let cr := "<br>"; let lr := " "; let myText := myRichText; output := myText; let cText := myText; let cText := replace(myText, cr, lr); let cText :…

• Answered

sibling tables

I've been struggling with this for a while but no nearer to a solution so looking for inspiration from here. I have a parent table (p) with 2 child tables (c1 and c2).…

Cannot save views

Hello, I am new to Ninox and the Mac App. I have created my first database with inner and outer joins. When I create a view from a table (i.e. any form or pivot table) I cannot save the view.…

statistics

I have a database in which I have a field "Neighborhood"" another "Type of Property" (e.g.: house, apartment, etc.) and another "range of sq meters"(<70 m2, <100, etc.…

Copy text field to reference field

Hi Brain Trust, Is this possible? I would like to trigger after update a text field (copy a text field) to a reference field. They are both in the same table.…

• Answered

Get time in minutes from the duration field type

How is the formula to get time in minutes from the duration field type? I entered this formula, I expect a value of 60 minutes but I get 0 zero! number(timestamp(format(Durata,…

Storage Full

Bonjour pour résumer, j’ai atteint la fin de l’abonnement, j’ai renouvelé sur l’Apps Store (licence Starter), mais on m’a dit que je devais prendre une licence professionnelle ce que j’ai…

Search by Suppier from  a Choice field

Here again Hi I import a large excel file with 23.652 Items. I try to search by Suppier from a Choice field but I haven't had any luck. Some help On the Search Tab do that with let search :…

• Answered