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…

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…

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

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…

Right Justify

1: How can I right justify a text field? 2: How can I right justify the sum, count, etc., of a column in a table?

On-Premise: select + order by Syntax

Hallo zusammen, gibt es eine nachvollziehbare Ursache, warum "order by" bei einem select nicht akzeptiert wird, wenn das Ergebnis in einer Variable landen soll?…

• Answered

Creation Date

Hello everyone, I wanted to add a date field in my database, in order to have the creation date of each record. I was wondering if this date already exists within the records and if it does,…

• Answered

Simple formatting challenges

I don’t think there is a solution to my formatting challenges but they are fairly simple capabilities I figure it must be me. I am constantly struggling with things like font size for field titles,…

Dynamic select unique : can you please help me to translate this code on NINOX for dynamic selection

Mileage Chart Spreadsheet to Ninox Table

What would be the best way to put the data from a Mileage Chart Spreadsheet into a Ninox Table for look up? These are the fields that I am thinking of…Origin, Destination, Mileage.…

• Answered

Birthday field not visible in Calendar iCloud or Outlook

I'm working very often with Ninox Calendar. Syncing is very good. However, syncing birthday Fields doen't work anymore. They are visible in the Ninox Calendar but they are not in the Outlook / iCal…

Sort view by initial exam

Hi All, I have a view of all patients examined in a given month. Some of the patients have been examined more than one time during the month. How can I sort the view so that it is filtered to view…