-
Just for information (web version only)
Just for info re web version I placed and alert in combo box trigger after update and it sinply ignored it but rest of script worked well. support have come with :- "Thank you for your e-mail.…
-
Charts personalization
Good afternoon, I had two quick questions regarding charts: - Is it possible to order the bars in a bar chart from smallest to biggest amount/bar, or vice-versa?…
-
what format and size for an image field ?
self explanatory
-
Quick Formula question
When a Formula field is defined in a table (not just a calculated column in a list view) is the result saved to disc or is it only ever held in memory and simply calculated as required?…
-
Purging Job History
I want to delete all main JobDockets records and its child tables) if these exists before a given date (6 years approx) based on a date keyed into a delete for this date fieild (DeleteDate!…
-
disappearing formulas
I have just started testing the trial, which means web based and not the app. So far I have 2 tables, a parent and a child. Currently driving me nuts is that in the list view of the child table I add…
-
Update only some some children
Aplogise for the apparent favouritism, but I need to update the Date field of only those child records whose Date field is either in the future or simply blank/empty and not been able to figure out…
-
Return of the wife
Hey - I can get my wife back! - as long as I purchase a love spell !! These extras are being offered to us via the forum now so often tat I think Ninox should be including them with the next update :…
-
Upload file to image field via integromat
Just wondering if it would be possible to have a cognitoforms -> ninox integration via integromat, and have an image from the form upload to an image field in Ninox?…
-
the chosen one (or not)
I'm trying to access the choices from a Multi Choice (Dynamic) field, named 'colour' in the current table. Before I try more complicated concatenations (well, I tried but they failed),…
-
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.…
-
How to create an invoice for a collection of orders?
Hi all, I really need some help on this. I have a table ORDERS. Each order has 1 customer and multiple items (in the child table ITEMS). Then I have a table SHIPMENTS,…