-
Filtering a view
Here's the thing. I have a table of vehicles, some 'Cars' and some 'Motorcycles', differentiated by the 'type' column. I want a view of just cars and another of just motorcycles,…
-
command similar to Duplicate(this)
Is there another command similar to duplicate(this) that instead of copying all field data in one record to a new record in the same table, it will copy that record and put it into a new table (that…
-
Styling of text labels on a form?
In the absence of a dark mode option, I've attempted to reduce glare by changing the background colour for each tab to mid grey. But now the text field labels become black on grey and are difficult…
-
Batch rename image files using 'field data' + 'suffix'
Example: I have multiple columns / fields. I want to rename all my image files to show 'ID' + Suffix e.g P001-A, P001-B. I have no coding experience and only just started using Ninox and can't seem…
-
Log base other than 10
I need to calculate logarithm to the base 2 instead of to the base 10. Is it possible in Ninox? In case it is, I would appreciate knowing the syntaxis. Thanls
-
View sort on 2 columns ?
Silly Qustion I want to sort a Jobs tables view by 2 columns Ie First by 'Customer' the that list odered by 'Date' in reverse Individulaly both are easy but I can't sort 2 headers to become one if…
-
How do i create a record on a SubTable button?
I have an Invoice table and Invoice Items is the subtable. Im trying to add a button on Items to create an Invoice and a new record on the Subtable Invoice Items linked to the Item.
-
Buscar una tabla con parte de su nombre o que cumpla determinas condiciones
Buenos días. Tengo una base de datos en mac y voy a necesitar crear desde un botón una tabla independiente por cada cliente de mi base de datos (el listado de clientes es otra tabla).…
-
syntax "last(select table)" issue
Hi, I have small problem with this syntax. Does the select statement of a record from a table only goes with the first last 9 entries? I have a table of many about 100 records and ongoing (currency…
-
2 pages à l'impression au lieu d'une ...
Bonjour à tous, désolé cette question est en Français parce que je ne suis pas sûr de réussir à la traduire :) J'ai fait une mise en page de prise en charge dans Ninox,…
-
Count Saturdays an appointment ?
Plz how to calculate the number of Saturdays between two dates or an appointment ?
-
Case statement
I'm sure I have somewhere seen mention of this NX functionality, but I can now find no reference to it in either the manual or this forum. Is there such a thing and if so,…
-
leap years
Hello, I have to compute the number of days between two dates. I'am using the following code : days('DÉBUT - FACT. - FRAIS', 'FIN - FACT. - FRAIS'). But these code does not compute the 29th of…
-
Reformatting text via a formula
Hello. Just starting with Ninox. Imported some data from a Filemaker file into 3 fields: LastName, FirstName and PhoneNumber. The formatting was inconsistent in the Name fields.…
-
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.…
-
Still can't print all records or even printTable with script
Here's a list of what I've tried with the results - in the Manual or on the forums. Ninox iPad latest version. Any help is appreciated.... for i in select Table doprintRecord(i,…
-
Converting min/mile
Is there a formula in Ninox that can convert a time of say "32:14" for 2 miles into Min:Sec per mile? In other words, I don't want 15.50 min/mile, rather I which to generate a text of "15:…
-
Oversight, or To Be Added?
In administrative mode, I can choose a field type from the pop-up graphic menu, but the new dynamic choice field types are missing. Is this an oversight, or is this being added in a future update?
-
Last (or First) function breaking down?
I have a slight issue with getting the last (or first) job date from a child related table Parent table is 'Customers' - Child table is 'JobDockets' So I have a view that shows all the jobdockets in…
-
Why is "Find" and "Find & Replace" greyed out in the menu?
I've been trying to use the Find command, but it's always greyed out in the menu. How can I get it to work?
-
New Time field
Just discovered that the style for the time field has changed. How to return it back? or tell me how to make the time recorded automatically, I'm at a loss
-
Print formula - how to edit?
Since I haven't found a solution to printing all records in a table, I tried using the Print Formula. I have a test table with 3 records to print only records 14 days or more from the current date.…
-
Font Size? Backups? Registration?
I've recently purchased Ninox from the app store, (I want to keep the database on my computer without cloud backup) and I'm slowly "finding my feet" but I have a couple of questions 1.…
-
Ninox Mac version "falls asleep"
Am I the only one having this problem?: if I'm not working constantly (typing, navigating, etc.), Ninox (for Mac) falls asleep, and I have to wait for it to respond,…
Answer questions and share your knowledge