Conditional Formatting at a stretch using a Filter

Sometimes I miss the filter funnel in the header which throws me when I know there are more records than I see. Especially if the column being filtered is off to the right out of sight so to speak.…

Expiration date in colour

Hello. I am at loss. Been trying many configurations but can't get the fields work. I have a table with one field called expiration date. I would like the field expiration date to be displayed in RED…

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.

Exported Printpages to Imagefield getting overwritten after selecting a different datarecord

i have a table which has some values stored which are getting printed and also saved in a image-field. i have like 10 different Print-templates and every template is used to save it as a PDF in the…

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