-
Trigger after hide bug
Hello, When using a table with a Tab “Water” (as first field) with a « trigger after hide » action which updates table fields, that works fine. But when you delete the record,…
-
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…
-
Let’s Look At The Top New Features in Ninox v3.13
Let’s Look At The Top New Features in Ninox v3.13 Thursday, 5 September at 12pm EDT/ 5pm BST/ 6pm CEST Join the party for free: https://us02web.zoom.us/webinar/register/WN_suzu4kttTqeKTRv9O6mifA…
-
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
-
Resolving a bill of materials
Hello, I am currently building a bill of materials. There is a table PARTS and a table BOM (which is an n to m relation of PARTS with PARTS as well as a field QUANTITY.…
-
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
-
Data Modelling
I know it was written a few years ago now, but this book has become my go-to for all things data modelling. The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All…
-
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,…
-
Work around for styling colour not working for formulae with html
I have formulae which are hidden by styling to blend in on TABS regardless of colour. Even a formula on a non coloured TAB is visible if the styling does not 'take' due to html in the formula in 3.13.…
-
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)
-
Test print with watermark
Download and print a test PDF to verify that the rendered report contains the desired data and looks as expected in your layout
The test print contains a watermark.…
-
Example: invoice PDF
Use the sample data below to understand how to get from a document (= template, here: DOCX in Microsoft Word) to a rendered report (= result, PDF in Ninox).…
-
Option B: with a custom script
Follow script notation in template Assign alternative field names to be used in your template. Your field names do not need to follow the CamelCase or underscore _ notation.…