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

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