Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Reformatting text via a formula
Capitalize is a useful function, but I have to ask, why is it not available is the 'visual' code view? Other transformations such as 'upper' and 'lower' etc are available, but no capitalize.…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: What is "Handle file as" in Image field properties
Almost 2 years have now passed. Are images from files dragged onto the Ninox window resized according to what is specified. Or is that feature still just a 'plan'?
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: Import into table with Multiple Choice (Dynamic) field/column
Any ideas/help here?
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
The formula I was using is:- let marqueid := marques;(select marques where Id=marqueid).name; This was in the list view of the 'models' table, a child of the 'marques' parent table.…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Any relationship between 2 tables is by definition 1:N (or N:1). The foreign key column in a child table can ONLY store the primary key of one single parent table record.…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Import into table with Multiple Choice (Dynamic) field/column

I have the MC(D) working, but need to import a lot of records into the table. They currently exist in a spreadsheet with that column already filled with the correct data,…
- UKenGB
- 4 yrs ago
- 8replies
- 635
- Get help
Re: disappearing formulas
No, the relationship is 1:N (in the right direction), but the crucial point is that I cannot add the column containing the actual required formula, but have to add it via a simpler formular which…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: Unique Field in a table
Really? You cannot specify a UNIQUE constraint on a column? Why is this "not possible yet"? It's standard SQL and also part of SQLite which is what Ninox uses (for the app anyway,…
- UKenGB
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: disappearing formulas
I did state (clearly I thought) that I WAS in 'admin' mode and had exited that to be sure the configuration was then saved. Made no difference. That also does not explain why when trying to add the…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
More specifically, a formula field with a 2 line formula (set a variable and use that to get the desired data) will be discarded and not added to the table list view.…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
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…
- UKenGB
- 4 yrs ago
- 15replies
- 873
- Get help
Re: what format and size for an image field ?
I have the same question about format. Specifically, what image format(s) can Ninox handle. This information should be clearly stated in the manual, but it's not. Cannot find it anywhere.…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Image format

What image format(s) are compatible with Ninox? I'm sure I read somewhere that Ninox can only work with jpegs. While I think it's pretty deplorable that a modern database can only handle a single…
- UKenGB
- 4 yrs ago
- 3replies
- 324
- Get help
Re: UNION selections
That's great. Thank you for that.
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: Display image from a remote server?
Looking into this myself. Can someone enlighten me, what is iCloudDB? I fully understand what iCloud is, but never heard of iCloudDB?
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
Re: SQL “flavour”
In response to Sean's earlier comment (ignoring the last 3 seemingly unrelated posts) I have to disagree. SQL is a very mature language and fundamentally understood by many thousands of database…
- UKenGB
- 4 yrs ago
- Get help
- Reported - view
UNION selections

I want to be able to pull records from 2 (very similar) child tables and present all those records in a single list when viewing the parent record. I could easily achieve this in SQL using UNION,…
- UKenGB
- 4 yrs ago
- 2replies
- 326
- Get help

1 5 6 7 8 9 10 11

Back to top

Overview

View all topics