Creating a new record in a linked table using code

I have 3 tables linked to create a many to many relationship. The relationships look like this: [Locations] <--- [Location Tracking] ---> [Tracking] Multiple tracking records and be related to every…

Locking Records in multiple tables from one

I have this script to lock records in a table. How would I modify it to lock records in child tables related to this Projects table? In other words lock Inventory and Locations do as server for i in…

Printing an image attached to a record with html

Hello, I'm struggling to include an image in a table. I've included a column with the following html which takes multiple fields and includes them in one cell in the table:…

• Answered

Programming language for Ninox

Please tell me video lessons or programming language to learn how to write formulas for Ninox. I need any literature for beginners, I have never done programming and practically do not understand…

• Answered

Hide empty image field when printing a report

I'm programming a solution that can have up to 10 images (with legend). When printing a report, I want to hide the empty image frames and legends. How can it be done?

Enter the content of another field inside a rich text field

Hello again. I'm just ending the development of a custom application that needs to print and export some rich text fields with lots of text. What I need is some kind of "data merge" inside a rich…

Print engine for Ninox - what is the 3rd party report writer being used?

Can someone advise the name of the report writer and how easy is it to set up

Creating my first Dynamic Report

If using Word does one create a table in Word and then use the fieldnames of the Ninox View in the column headers. Or does one use the View name. Would it be possible to get a template as an example…

Cannot create more Forms!! - Cloud version

I have had this happen before and I finally figured out what it was but now it's happened again and I'm stuck. I am unable to create more forms. Usually when you click the + to create a Kanban or…

• Answered

coding for create record

Hi, When I click the +Create Record in a referenced table, I get a new record in which the client code (a unique code) is filled in as is the link which the parent (client) table.…

adding files to records?

Hi have created a database where for each record I have a bunch of files to add to it (i use the built in attach "add file" upload to add files. However I am concerned that very soon the database…

Calling an image from another table

So, I am probably missing something very simple or having a complete brain fade!! In my 'JobDockets' table, I have a button for sending out a goods dispatched email - which works great and also adds…

• Answered

Where’s the information on learning the NX language rather than just isolated statements?

There doesn’t seem to be any instructional material on understanding the NX language, just reference material. Curiously, even when I enter NX as a tag, which is supposedly the name of the language,…

Display multiple dynamic choice items separated by returns rather than commas in Print

I have a table with a dynamic multiple choice field. I am trying print a record with the contents of the dynamic choice field displayed on separate lines.…

• Answered

Font in print layout

I would like to integrate the Arial Black font into the field where the number 978 is indicated in the print layout. I set the Arial Black font from the desktop app for mac.…

Change lookup field based on the year

I need to look up one of two fields depending on the year. The two fields are labeled as follows: ‘2022-HHG-Mileage’ and ‘2023-HHG-Mileage’. Then, the correct field name needs to be inserted in the…

• Answered

Change the Choice Value or reorder again

There are any way to reorder the Choice number to 1,2,3,4,5,6,7

• Answered

Sort a dMC field dynamic values

I've tried adding Sort() to the select station and also the Dynamic Value field and neither seems to work. Anyone know if this is possible?

• Answered

Elimination of decimal numbers

Hi! How can I remove decimal numbers from a number? I have a Number field which is set to Euro currency with two decimals. But during the calculations what is behind it is considered, i.e.…

How to specify a default date?

I'm experimenting with a db to help schedule tasks for the coming gardening season. Many of the fields will be calculated in reference to our local "last frost date".…

• Answered

Mac Calendar integration not working

The implementation of Mac Calendar syncing isn't complicated however it's not working. I've for it enabled for 1 Month after and 6 months before to my Personal account.…

Insert multiple elements into case of switch

Hi! I would like to fit more items into a switch case but I can't. This works: switch 'Progress Bill' do case 1: 'End data' := null case 2: 'Total Price' := 0 case 3: 'End data' := null default:…

• Answered

I'm doing something wrong with this formula

I have Two Choice File one Status Example ( In Progress, Issue Client, Complete) , and Other Choice with Numbers (10%, 55% 100%) The formula don't work if Status = 2 then Hours * number(Choice = 1)…

• Answered

send e-mail problem

Hello. Please help me to set up nminox app to send e-mails with attachment via native apple mail prog . I tried to set up the e-mail function (sendEmail({from: "sebard@mail.…

api.mixpanel ?? What is that??

I have noticed that when Ninox is loading api.mixpanel.com pops up bottom left while my DB is loading. Does anyone have an explanation for this? " What can Mixpanel track?…