End time MINUS start time = total time in hours and minutes. Then total time X hourly rate = $xxx.xx

What is the above called (calculation?) and can someone recommend a tutorial?

YES / NO Default value

in the table I am using a yes / no switch. How to do it so that after switching to YES or NO, the value will not be changed for the next days, until it is changed.…

Display image from a remote server?

I“m told I can display an image in a record where the image resides on a remote server. I know how to get my images onto my remote server, but what do I need to do in my record field setup so the…

The online user manual

Do Ninox publish a list of features added to what version page?. As it would be useful to know what has been added/fixed on various versions. I'm a still newbie to Ninox and already I can see that…

Trouble emailing PDF attachment

Hello, I'm trying to send emails with an attached copy of a record. I've read many of the threads, and I've tried using "do as server", but I get an empty attachment when I do it this way.…

Open email client with pre-populated email, subject and attachment

I'm trying to combine the Email function and openURL I use the following for invoices, which is 100% fine let myEmail := userEmail();let myPdf := printAndSaveRecord(this, "Quotes");let myName :…

Print pivot table?

Is it possible to print a pivot table?

Registro presenze

Salve, ho un database con indicati data e ore lavorate per ciascun dipendente. facendo una "VISTA PIVOT" mi vengono visualizzati in modo corretto per ciascun dipendente (RIGA) i gioni (COLONNA)…

Importing addresses into the location field in a Ninox table

We are trying to import a csv file with the list of our members and their addresses into our new Ninox database.But unfortunately we cannot import the address into the location field in Ninox.…

Newbie question: Lag or delay in response to clicks/scrolling

This may be a very simple question: I'm finding that increasingly my database is lagging before responding to a click, or when I try to scroll down a view.…

How to delete multiple/all records in a table

I only find the option to delete a single record in a table at a time.Is there an option to select multiple records in a table and delete them all at once?

Agenda

Double date

AGE function

Not so long ago I watched a video lesson where they talked about the global function ageYM. but I can't find where to copy this formula. can anyone tell me where all the global functions can be…

• Answered

Formula for colour change

Hello there I have a colour field which i would like to either be red or green depending if a membership has run out based upon another field 'membership expiry date' having gone past the date.…

Deploying New Versions

I'm working on a database with a significant amount of custom scripting and will eventually deploy it into production, after which new features will be added over time and for sure there will be bugs…

Select Projekte nach E-Mail

Hallo, ich möchte aus einer Projektliste nur Projekte anzeigen, bei denen der Nutzer in der verbundenen Tabelle als Ressource eingetragen ist. Hier ist der Code:…

how do i change the date format?

how do i change the date format?

Is it possible to use a global function (defined in Ninox) via Ninox API query endpoint?

Hi, I try to make use of the query endpoint of the ninox API. I use the Ninox API Call task in Integromat for this and I am able to successfully test the API connection (I could successfully test it…

Fields as a Global Variable on Mac app

Been trying this new feature without any success. If I use a choice field and select an item, nothing selects until I move to another record. If fact Ninox doesn't acknowledge the choice until its…

YES/NO use like to show / hide table element

There is a table where YES/NO we use how to hide show fields for currency exchange rates. This currency rate is displayed in other tables as well. When we disabled in the main table,…

Connexion with OneDrive API

I'm trying to connect Ninox with OneDrive API to be able to move folders inside the drive but it doesn't work. Is anyone have a solution?

Connexion with OneDriveAPI

I'm trying to connect Ninox with OneDrive API to be able to move folders inside the drive but it doesn't work. Is anyone have a solution?

Restriction of rights for users

Hello I want to make a tab for the admin and bring the following functions there for configuration for users like Allowed to Show tab Write, Allowed to read, Create new record, delete record

Don’t create record if a required field is not filled

Hi, is it possible to not create a record if a required field is not filled

Bedingung Anzeigen wenn "FELD !=0" funktioniert nicht wenn die Eingabe im bedingenden Feld 0.- € beträgt

Liebe Leute,Ich möchte ein Feld dann anziegen lassen, wenn ein anderes nicht leer (also befüllt) ist. Konkret: Ein händisch einzugebendes Feld (Währung) muss befüllt sein,…