-
date function
Hi, How can I calculate the first day or the last day of a year?That is, given a field that contains the year, for example 2019, use a calculation to have a field with January 1,…
-
Frustrated with poor help guides- Is there a full guide to formulas anywhere?
I want to do what seems like a fairly simple CountIF formula but find the Ninox help guide to be incredibly frustrating. I can't find any mention anywhere in the instruction manual of a COUNT…
-
How to count the same value in different field
I have 3 table : one to manage rides boats, one to manage divers, one to manage goups of divers. This last table is linked with the boat (N groups for one boat),…
-
Refer to a specific value in a cell
I'm fairly new to databases so forgive me my silly question. I want to refer to a specific value in a cell in another table and use this value in a mathematical function (e.g. mutiply or divide it).…
-
Report Printing in Chinese through Webapp
Hi, I've found that when I print a report from the Webapp in browser, the Chinese appears as random texts. If I print it through the desktop app or iphone app, it is perfect.…
-
Calcolo ore
Ciao a tutti sto facendo una tabella in cui mi deve calcolare delle ore trasformarle in numero e moltiplicarle per un importo orario. Esempio ora inizio 10.00 ora termine 10.40 ossia 40 minuti.…
-
Add record Button
I want to create a button to add new record in a table named 'Interventi' from a table 'Caldaie'. The button on click must add a new record in a table 'Interventi' inheriting some field inserted in…
-
A developer-oriented admin UI would be very helpful!
First post! I must admit to being sceptical of Ninox and decided to try it out as i needed a relatively quick and painless replacement for a complicated Numbers spreadsheet system i use to manage my…
-
Linked table view/custom view not showing columns
Have this weird thing where the view for a linked table, or even a custom view, isn't showing specific columns I've selected. They're jsut based formula fields,…
-
Odd results with a Workdays count on an appointment field
At our school we are trying to calculate the workdays of a school term. We have a term start date field, we have a term end date field, and we have an appointment field that has the mid-term break…
-
How do I return the result of a logical operation as the value for a formula field?
I have a Formula field with a series of nested IFs to calculate a value. How do I "return" that calculated value as the content of the formula. i.e. I want the formula field value to be calculated…
-
Use table information in another database
Hello, I was wondering if it was possible to use table information from another database? Or can one only use the tables in the same database? For example,…
-
Global Functions
Can anyone point me in the direction of some good examples of Global Functions? I haven't been able to find much on the forum.
-
Learning about the Calendar
Today was our first attempt to use the Ninox Calendar as a shared office calendar. I first went through all our existing tables and set the properties of the Date fields to not show in calendar.…
-
List of names and count number (+1)
I have a question. How to make a table with a list of names and field of number that will keep increasing by (+1) every time I click on the name until the number reaches 15 then the whole line turns…
-
Pulsante Apri tabella
Salve ho creato un database per gestire la mia professione, ho cercato di fare dei pulsanti senza riuscirci considerando che il linguaggio VB non lo accetta.…
-
Date
Hi date is : 4 oct 2018 , i want be 04102018. How can do it?
-
Keyboard Shortcut List for macOS & iPadOS
Quick question, does anyone know where I can find a reference list of keyboard shortcuts for macOS and iPadOS?
-
Afficher une vue
Bonjour à tous, Je souhaiterai pouvoir afficher une vue de mon choix à partir d'un bouton sur un formulaire. Je ne trouve pas le code qui permet d'opérer cette action. Cordialement, Mathieu
-
can we use a regex to filter a column ?
hi all, i think the title above says it all… i'd like to filter a column using a regular expression… is that possible ? how would i enter the regex ? thanks for your answers laurent
-
Sending bulk emails
I am trying to modify and use the method described in Julian Kirkness's blog article "Sending Bulk Emails in Ninox". For anyone interested, the URL is https://www.onlinedatabase.…
-
Concurrent schema modification...
I'm the only user (and Owner of course) in one of my teams and I was trying to make some changes but I keep getting this message: "Concurrent schema modification. Your changes have been reverted.…
-
What are the Record Comment Notification capabilities?
I'm looking at using a table for a simple internal communications platform. Can users get notifications when someone adds a comment to a record? Maybe a better question is,…
-
Treating string with commas, as an array?
Hi, I have a string in a text field, lets say it is 'colours' : red, blue, black. If I use item(colours, 3), it will return 'e', instead of black, due to it being a string and not an array.…