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

Table or Sub-Table?

Hi, I'm building a database for my company we do production and sales and I'm confused when to make a related table and when to make a sub-table. I understand when I make a table invoice - with…

select inside "do as database" seems not to work with "let me := this" - or am I doing it wrong?

Hi out there, I'm trying to get a script running (ninox 3.12.8 docker), links between the current table and "Bilderdatenbank" do exist: let me := this; let bilderEmbed := [{}][false];…

• Answered

Regarding the issue with selection

I want to choose “M” for option 2 in Table 1, but as shown in the picture, it doesn’t confirm the selection of “M”. What could be the problem? (I noticed that as long as the option is not covered by…

• Answered

Populate text field based on selected option from a DCF

Hello @Fred @Sean I am trying to populate the email field based on the selected contact person option from the Dynamic Choice Field on the Sale Order form.…

• Answered

If I upgrade to the new version 3.13 what would happen to my current database on the previous version?

Button for writing to another table

Hello There is a button, in the sub table Cash Desk.Expenses, that should make a record in another table. to Table ADVANSE formula for button is let x := dialog("NEW RECORD", "CREATE NEW RECORD?",…

Data in the OrderItems table changes on its own

Hello, I just noticed a weird think happening to my database. Today I was working on the CRM database in the office where I work in the cloud version (since they have windows OS).…

Hiding HUD

Does anyone know how to hide these two elements - the + and Edit Would like to add these two to my HUD formulae. TIA

Button with script to populate table

Hi. I have a database as per the model in the picture. 1. Table with students. 2. Table with classes. Each class has a table of students (3) picked up from 1. 3. Table with assignments.…

Change order of records in Kanban

Hello, Ninoxians! I have a Kanban for leads with several statuses: new lead, attempted contact, contacted, hot lead, booked, etc. Whenever a new record is added to one of these statuses,…

For the HTML/CSS boffins out there please help.

New Ninox release has broken this in the sense that the Ninox setting for background color no longer works. How does one set the background color for a formula that is colored to be invisible with…

Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated! I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field.…

Sum the value of the result field from table1 when the value of deportment is "1"

Hello The table has a result field and a department field. The department field takes its value from another table from Choise filde, value of 1 2 or 3 Need a formula to calculate the result,…

• Answered

Sample printTable with Filter Criteria

Somethin don't work in this script on the botton. When change the criteria, and press the button It doesn't show me the selected criteria, but when click again yes it show me the criteria.…

Rich Text field printing question marks!

RTF files used to print perfectly well. I'm using Ninox 3.12.8 desktop. Now they just print question marks !? Anyone have any idea how to remedy this? (see screen grabs)