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

Ninox Date and Time Issues (continued)

I have a date on a form set for January 17, 2023. I have a view looking up Transactions from a table with the filter of let xDate := datetime(Date); let xNewDate := extractDate(xDate, -6); let xTime :…

Adding record when in sheet view (all),

I have noticed that sometimes there is no response when using the '+' here or the top right icon to add a new record. Nothing happens at all and when I click the refresh for the sheet that too does…

Make/Integromat doubt

I need to automate a process with Make and I have a problem. I have created a Yes/No field and from Make I´m able to modify it. In this field I have written a code in Trigger after the change like…

Issue with creating related record from script

I have a Combox that a user can apply "Tasks" to the Client they are working with and normally that occurs from a Triggered Update within a form in the Clients Table.…

Unable to populate related table in Choice (dynamic) field

I have two tables: Category and Subcategory, each with single Name text fields. Here's the data model: I'm using these tables to populate choice (dynamic) fields in another table named Entry.…

use array or better selection query?

Hi I am developing a database to assist with followup on patients attending our hospital. I am trying to create an list of patients who were admitted during a specified date range (usually 10-14 days…