Views

The way it's being planned looks very natural and clever to me. But that also makes the learning curve a bit steep for general user. May I suggest to put all those "Font Setting" "Cloud setting" into the menu, under separate title "Preference" / "Cloud/Sharing".

I understand the technical issue involved, as it would be safer to close the database first, before changing those. But we can always do a popup windows to say "Database will be closed for this action".

Please consider this seriously. It took me so long to find out the global font setting. I am sure many will have the same feeling.

I want to create a view that does not show related tables as sub-tables. I just want the single-valued fields in the form.

For every field - even subtables - there is the property "visible if": Just give the word false to make fields invisible.

Birger - Ninox Support

Great...

Is it possible the change the displayed column heading or field label in a form or view without changing the column name in the table?

It is possible. But the other way around :-)
Click the column Head in table view and change the display name. Now you can rename the field in the form view as much as you want.

Birger - Ninox Support

Hi,
Is there a limit to the number of fields displayed in a table grid view ?
I have 12 fields but only 8 (incl. id) appear in the table grid view.
All 12 appear in selected record view.

By default only the first 8 fields are displayed in table view. Click any column head and select "Show column" to have more fields displayed.

Birger - Ninox Support

Hi,
Thanks, that worked fine.

I have two fields that have values crated according to certain criteria. However, when I try to drop them into a list of fields to display in a view, they won't add. See https://screencast.com/t/o5B71zEZsLDj

Hi Paul,
thanks for your hint. This looks like a bug. Could you provide us more information? Which Ninox version and which OSX are you using. Please write to support@ninoxdb.de
Best regards and thanks for your help, Alex

I want to sort two columns:

1st is a text (descending), 2nd is a number (ascending).

How can I do that? how can I combine correctly a third column?

THKS

You can create a thrid column as sort number. 

the formula:

---

let TT := yourtext;
let NN := yournumber;
cnt((select YOURTABLE)[yourtext > TT]) + 1 + cnt((select YOURTABLE)[yourtext = TT and yournumber < NN])

---

now you can sort this column (ascending)

Leo