Skip to main content

Ninox-Documentation

Alain Fontaine

Alain_Fontaine

422
87
2

Joined: Thu Jun 04 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Automated Multiple Choice: Is it possible?
To set the option identified by "Number" without touching the state of the other options: 'Multiple choice' := array(numbers('Multiple choice'), [Number]) To clear the option identified by…
- Alain_Fontaine
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
Or even simpler: let a := [article,Color,more stuff,kg,lt]; let b:= join(a[!=""]," ")
- Alain_Fontaine
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
While the formula works in most cases, it can lead to false positives in certain cases. For example, if the list of countries includes “Guinea” and “New Guinea”,…
- Alain_Fontaine
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
In this formula: let c := numbers(Country); select tHotels where cnt(numbers(tCountry)[contains(c, this)]) > 0 I supposed that the table “tHotels” contains a DMC field “tCountry” indicating in which…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna I have zero experience with printing, but I understand that the function is severely rotten. So one should not try to print a DMC field, even if it has been correctly sorted,…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
@Sean One word of caution: on the iOS version, strangely, it works with replacex, but NOT with extractx. Go figure…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
replacex("000" + trim(text(Localisation)),…
- Alain_Fontaine
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
Another possibility: let t := this; ((select Subcategory)[contains(numbers(t.Category), number(Category))] order by Subcategory) order by Category.Category The trick is to order by the least…
- Alain_Fontaine
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
@Julien First question: extractx("000" + trim(text(Localisation)),…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
@Jarno Vande Walle Doing so would also imply some kind of selection, which is probably the operation that takes time. Are you working in a client/server context?…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
So, if if the children that have been linked to a parent stay linked with the same parent forever, one only needs to take care of the orphans, which should take less time than processing the whole…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
May the value of “field” in either table be changed? To say it otherwise, once a child is linked to a parent, can it become necessary to link it to another parent?
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Subtotals
From the example given, it was clear that a single "Ingredient" can be referenced by several "Activities" depending on a single ticket. What was not clear was if a given "Ingredient" can be used in…
- Alain_Fontaine
- 1 yr ago
- Learn and share
- Reported - view
Re: Sub-BOMs Cost Managment
I just reinstalled an example database in this thread, which is only one of those one finds when searching for "recursive":…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Resolving a bill of materials
While I did not remove the file, it seems that the link somewhat expired. Since it is now possible to store files as annexes to posts, I am adding it here for reference.
Attachment
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Sub-BOMs Cost Managment
It seems that you are venturing on the rough seas of recursive structures. Searching the forum for “recursive” will return some food for though.
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Subtotals
I'll try to explain how it works. As a first step, we put the identity of the chosen record from the "Tickets" table in the "focus" variable, since we will need it at several places: let focus :…
- Alain_Fontaine
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Subtotals
Sometimes, after building a solution to a problem, further study reveals that the first try can by streamlined. In this case, a much simpler solution is indeed possible…
Attachment
- Alain_Fontaine
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Subtotals
In the design of a relational database, one creates tables to model some objects in the real world, and then defines links to represent the relations between those objects.…
Attachment
- Alain_Fontaine
- 1 yr ago
- Learn and share
- Reported - view
Re: Subtotals
No proposals yet? Let try something… From the formulas listed, it seems that a relation exists between "Activity" and "Ingredients"; I supposed that one also exists between "Tickets" and "Activity",…
Attachment
- Alain_Fontaine
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: More Vieweirdness
Really strange indeed. If you replace text() by its explicit development: concat(for i in numbers('Multiple choice (dynamic)') do record(Table2,i).Text end) you get exactly the same value,…
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Rich Text Field frustration - help :-(
Rich text in Ninox is actually interpreted html. This small database shows the relations between the raw and interpreted versions. You can do anything html can do.…
Attachment
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: multiple conditions is Display if:
Either: not (x or y or z or …) or: not x and not y and not z and …
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Iterate over DC
It is possible to extend the model with dynamic selections.
Attachment
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view
Re: Iterate over DC
Do you mean something like this:
Attachment
- Alain_Fontaine
- 1 yr ago
- Get help
- Reported - view

1 2 3 4 5 17

Back to top

Ninox-Documentation

Overview

View all topics