Code lock in Ninox

Hello friends, just wanted to know if we can lock our code in Ninox. When we create the database app for a client, can the admin open the code and see how it’s been written?

If the value is not different from the previous one

I have a digital field containing information and a 'Date+Time' field to record the time of change. I have a question: Is it possible to set it up so that if the new value is the same as the old…

• Answered

Best practice to duplicate a record

Hello friends, I am using the Ninox macOS client (now that it has been updated to 3.13.3) I have created a "Duplicate Product Item" button to create a duplicate record of any product item in order to…

Sortierung von formatierten Daten styled(date)? / Sorting formatted data styled(date)?

Hallo Community, gerade stehe ich vor einem Rätsel. Es geht um die Tabellenansicht und die Funktionen styled und order by bzw. das Sortieren von formatierten Daten.…

Alert in cloud version not working?

Im doing this at Table level update trigger, but there is no alert showing up. Whats the trick? let checkthis := NameField;if cnt((select Customers)[NameField = checkthis]) > 1 thenalert("Customer…

Home Button Hidden

One of my workspaces has a sidebar where the Home Button is hidden to users. In edit mode I can access the Home Button menu and hide Search, Calendar or the whole Sidebar, but not the Home Button.…

Auto-increment?

Is there currently an auto-increment field of some type? If not, is there a way in code? (I found some old posts, so I don't know how relevant they are anymore,…

Filter by date in a sub database

Good evening, I would like to know how to filter on a table that uses a subtable. For example, the one that groups the total accounts cannot be filtered by month, or quarter, or year.…

View from another database

I have a database in Ninox called Anniversaries and another database called Work L41 where there is a table called Jobs . I would like to create a view in the Anniversaries database that would show…

Hash of a string and check

Hello everyone. I use SHA-256 algorithm to generate hash from strings. Hashing is generated correctly and the value is copied to the clipboard. function sha256HashAndCopyToClipboard(string :…

• Answered

Using the Filter option

Is it possible to filter a field based on criteria in another field. eg: Field 1 Serial Required is 'Yes/No' Field 2 Serial Number is 'nnnnnnn' In Field 2 Filter: Field 1 = Yes

Ninox App Settings

I'm wondering if anyone knows of an accessibility option for Ninox, like the one on Macs "reduce motion". Where instead of sliding the record in from the right side when you click it,…

Trigger after update: refresh table view

Hello. How can I force a table view refresh after updating a record? I have a button that closes the record but I would like to also tell it to refresh the parent table view so I can see the changes…

Video Field versus Image Field

Is there a field for importing a video into a database that can later be played on demand? - John

Choice fields in dynamic print layout

Hi everyone, Is there a way to access a column other than the first one, in a choice or dynamic choice field, in the custom JSON of a dynamic print layout? Let's say I have a choice field,…

• Answered

Trigger After Update does not get Triggered

, Hi@fred @sean I am facing a very weird issue. I have some code written in the "Trigger After Update" event of a DCF (Dynamic Choice Field). When I physically choose "empty" from the list in DCF,…

NINEXT Idea for table view (ALL)

@Jacques TUR Is it possible to freeze a column in (all) or even a view so that columns to the left are locked but scrolling to the right is enabled. Much like Excel where one can lock a column to…

Hide the trash, duplicate and add buttons globally

Hello everyone, Is there a way to hide the trash, duplicate and add buttons globally? I find I have to add the formula to every separator of every tab in every form...

• Answered

Colorcoding an appointment in calendar

Hi there, I am trying via "show as" in the appointment field to colorcode the appointment with no success. I have in the employments table created a choice field where the color show which kind of…

• Answered

Retrieve a field from one table in another

I have a database dedicated to events. In this database there is a table called “contracts” and another one called “processing” In the first table (contracts) there is a field that indicates the…

• Answered

How to track the selected item in a DCF

@Fred @Sean I was following the below post, but I think it got too long and complicated for me to understand.…

• Answered

Some help here

These days on vacation I'm making a small database. I have a problem in the Games table. Ihave each game with the goals and points . How do I to sum the gols and points in the Teams Table.…

• Answered

multiple choice: delete option and set option on create new record

I'm sure that until recently it was possible to delete a row from the options of a multiple choice field. Now I can only edit the text and re-order the options.…

Selecting Product Items based on Product

Hello@Fred I have a Reference field where I select the main Product from Products table. Product Items is a child table of Products. I have added a button (Update Records) and a new column (Product…

Formula for table ' Choice Dynamic'

In the main table I want to display the value of the dynamic selection. but it outputs the value as a serial number. I use the formula text( position held) the problem is that it is not displayed,…