how to lock a cell at a given value?

hello, I have a catalog with the price of the parts and this price is reported on the estimate. the concern is that if the price changes, the amount of the estimate is modified,…

Trigger button and code to open calendar

Hello Ninox Community. Question: Is a code to open the calendar directly while being in a dataset (in my case a dashboard with table view) ? In Ninox you can open a table via button and function.…

How to make a query in Ninox

Hi, I would like to merge several tables into 1 table/view. By this I mean, all fields. I don't know how to do this. In Microsoft Access this is very simple.…

ORGANIZE TABLES ON SIDE PANEL

Is there a way to organize the tables on the side panel in to groups. Maybe by icon or how bout line breaks between them. it could look like this.

Database size spiraling out of control

Anyone else experiencing database 'bloat' in the cloud? I discovered on Friday that my main database had grown to over 3GB with automatic backups taking the team size to 7GB which had the effect of…

Deleting attached pdf file

Hello, Is there a scripting function to delete an attached pdf file from a record ? Best regards, Pierre.

Dynamic Choice "order by Id" gives incorrect order

I'm trying to use a Dynamic Choice field for the first time. My "Dynamic Values" formula selects values from another table and uses the "order by" statement to sort the values by the table's standard…

Display value from unlinked table

Hello. I have a global Value (Exchange Rates) which I want to use in various other tables. So far I have a table called "Exchange Rates). There is a subtable for USD-THB exchange rate which will be…

• Answered

Import Users into Microsoft Active Directory from Ninox

Hello, I have a table in Ninox used to manager users. What is the best way to automatically import (create, modify) users in AD based on the changes in Ninox?…

Week_Appoitment

@Fred @RoSoft_Steven Please I try this app look to good , but I have problem on Android, on Web work fine without problem but too slow, I think is problem is refresh.…

Making a single reservation, blocking all other requests

We are developing a system, that allows to make a reservation of an item for an offer. In an early phase, the item can be reserved by many offers. Thats not the problem.…

Problem in Calc_Dynamic

Hi I have two problems with this models. The Weeks field is Multiple Choice Dynamics can I groups by weeks ? In the example I have two hours on the same week 2.…

• Answered

[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

Global Change (yes / no) field

Hi all There are any way to global change the Field yes / no Example is now is No change all registers to yes or otherwise. I Have a lot of registers and manually is annoying. Thanks

• Answered

Body of Email field

Hello, Is it possible to add logic within the body of an email field? For instance I am creating an email body with fields from my view, but some I only want to show if another field is ticked…

• Answered

Get Previous Month

Hi, Hopefully a simple one. Im editing the body of when the email field is clicked. Whats the syntax to get the previous month. I have tried everything with no luck. Thanks