All topics

Non-Stacked Bar Chart, Customize "Y" Axis Minimum Value

Is it possible to customize the "Y" axis of a non-stacked bar chart to have a minimum value of zero even when none of the displayed values on the graph is zero?…

Type in a date on 1 table and it populates also in another table

Hi I would like to type in a date one the fist page of my report (1 table). I would then like another table within the same database to automatically pick up that same date.…

Find special Codes

I have to kind of Code 'AUxxx' and 'AUxxx_x1' There are way to find all codes finish on _x1, on a select 'Audits Plan' where 'Audit Code' ???

• Answered

trying to add 6 months to a date

Hi I have trying to add 6 months (ideally less 1 day) to a date. The formula I am using is date(year(date('Format date')), month(date('Format date')) + 6, day(date('Format date'))),…

• Answered

button to number records incrementally

I am trying to write script for a button in order to number a series of records. Here is the situation: It is to give a candidate number for an audition.…

How to count number of lines and contents

Hi. Your help is greatly appriciated. I am going to be surveying fire doors. for my report I have a question (Is the door compliant) 1st - I would like to be able to have a formula to count the total…

• Answered

A way to find out where a specific field is referenced anywhere in your tables?

So, one thing that I find would be helpful, is if there was a way to search for everyplace where a field is referenced or another formula is dependent upon in your tables.…

Ninox will not open on my Mac

I installed and reinstalled Ninox and it still won't open. Is there something else I can do to get it working?

show only relevant table columns based on two criteria

Objective Map relevant terms, people, and institutions to respective slides. Hurdles Show appropriate table columns based on source/target language. Hey Ninox Experts, Hey@Fred /@Jacques TUR ,…

Delayed emails

Recently when I send an email using the sendEmail, there is a big delay (upto 24 hours) before the message is actually sent. It used to work fine. Any ideas? I have a public cloud account.

Automatically link record from one table to open record in another table using a button

In Audits Plan I have the field 'Audit Code' and need to open on 'Non Conformity' field the same 'Audit Code' on the 'Non Conformity' table the 'Audio Code' is a N1.

• Answered

This code works erratically sometimes it works and other times it doesn't

This code works erratically sometimes it works and other times it doesn't. delete (select 'Evaluation table'); let myY := year('Evaluation Date'); let myYM := yearmonth('Evaluation Date');…

• Answered

Formula returning specific values depending on multiple choice selection

Hi all, I have a multiple choice field with around 40 options and I would like to set up a formula that returns a certain text depending on the options selected.…

• Answered

Invoice in XML (structured format)

Hi all, Do you have a tip : how to export invoices in XML structured format ?

Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined)

Hey, When I add an image (PDF, JPEG or JPG) to the Ninox database I get this message: Type error: i.updateUI is not a function. (In '.updateUI()', 'i.updateUI' is undefined).…

• Answered

Hiding Icons HUD - choosing which to hide

I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…

• Answered

Local, iCloud or Public Cloud ?

The ninoxApp() function allows you to determine, for example, whether the database is used from a browser (web) or from the native Ninox app (mac, iPhone, iPad, Android, etc.).…

CALLBACK POST API

Hi, this is an example of api code POST (OPENAPI) to receive information according to the call indicated in the code. Could someone explain to me how to integrate it into Ninox?…

API RESULT

Hello, the result of an API request is this {"data":[{"pec":"test@pec.it","history":[]}],"success":true,"message":"","error":null} I would like only the value test@pec.…

Expression to extract text in a string to the right after a dash character

I need to extract text in strings (product labels) after a dash character. An example string: Pavé Nameplate Necklace - "ADHD". Ideally, the result would be ADHD, but "ADHD" works as well,…

• Answered

Confirm whether all multi-choice in the subtable are selected

How can I confirm that all multiple choice in the subtable are selected?Thanks

How can I extract all attachments from Gmail?

Hii, Is there a solution to extract attachments from the Gmail? please suggest the best software for this same.

Dashboard Help to Compare This Years Data to Last years Data to same date.

So I am in the process of creating an Insights Dashboard. I am needing help in putting together the right syntax to compare this year to present vs last years data to today, but 2023.…

CreateCalendarReminder - Access not granted ---- how did you get around it?

The function CreateCalendarEvent works... "CreateCalendarReminder" does not... it brings the message "Access not Granted" In System Preferences / Security & Privacy / Privacy....…