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…

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