Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: acces to array items like with Where fonction
And again: it works with the other comparison operators too. So, a very nice trick with lots of potential applications.
- Alain_Fontaine
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
Another note… This trick is even more useful if one can look for a value that is not a literal. So I tried with the name of a field (after "like" or "="), and got an error message.…
- Alain_Fontaine
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
Very nice trick. It also works with [= "Marie"], to look for a perfect match, and with other element types. Which leads to a way to check if an array contains (at least one instance of) an element…
- Alain_Fontaine
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Convert table to subtable
If table "B" already has a N:1 reference field to table "A", just edit this field and set "Composition" to "Yes" to make table "B" a subtable of table "A".
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Info delete Field
It’s even easier, since Ninox will happily set all the component of an array to the same value. One can just write: (select yourTable).Fechas := null or (select yourTable)[field1 = true].…
- Alain_Fontaine
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Pass current viewing record Id to a view element column formula
I also encountered situations where such an access would have been needed, and I have been unable to find a solution. If there is one, I would love to learn.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to import data from text field to dynamic choice field
I did indeed write that trying to put a text in a DC field does not work. But one does not need to submit a full record ID: since the identity of the source table is known by the very definition of…
- Alain_Fontaine
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: NEW FORUM
@Sean Yes, I saw that when I looked at the forum on my mac; I did first use my iPad…
- Alain_Fontaine
- 3 yrs ago
- Learn and share
- Reported - view
Re: NEW FORUM
Hi, Mel, you seem to have better luck than I do. All my attempts to follow a "legacy" (before the change in the forum) link result in a 404 code from "ninox.forumbee.com".
- Alain_Fontaine
- 3 yrs ago
- Learn and share
- Reported - view
Re: NEW FORUM
Perhaps more annoying: all the existing links to previous threads now return 404...
- Alain_Fontaine
- 3 yrs ago
- Learn and share
- Reported - view
Re: NEW FORUM
Seems much better indeed. Just one regret: the old forum did show a precise timestamp for each post; now we are left with a rough estimate.
- Alain_Fontaine
- 3 yrs ago
- Learn and share
- Reported - view
Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters
Updating many records is a job for the… "Update multiple records… " command. A detailed explanation can be found here: https://forum.ninox.com/t/h7hrzwn?r=60hraz0
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Applying filters on a lookup table by choosen field
So, my understanding was not correct. The original way of solving the problem, that is, using the "chosen" function with two arguments, is indeed valid, and can be done in two different ways:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Applying filters on a lookup table by choosen field
If I understand correctly what you are trying to do, you need to access the "Service" choice field of the currently open record in the "Services" table from the search panel that opens when choosing…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Show all records in another record that are related by an ID
I would add that, inside the square brackets, one can put a script, with the statements separated by semicolons as usual. When writing such a script, one should remember that:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to import data from text field to dynamic choice field
One cannot import textual data in a dynamic choice field (well, that's how I understand the matter). A dynamic choice field is defined by reference to a table. How is you field 'Patient Name' defined?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to turn 5x reference columns in a CSV into a single reference column containing all 5?
Each genre can caracterize many movies, and each movie can be caracterized by several genres - up to 5 in your implementation. Which means that there must be a M:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Linking Tables
Contrary to some other well-known database systems, Ninox does not manage links depending on the value of some data fields - what I would call "soft links",…
- Alain_Fontaine
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Find duplicates
Finding duplicates on a single field is easy. Define a formula field, or a formula column in a tabular view, with something like: let myLastName := 'Last name';…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Select last child record
That's the idea... Now, in this particular case, being inefficient would not be a big problem, since the script is to be run once per year and per record in the "Composer" table,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Select last child record
Since there is a relation between the two tables, a "select" statement is not needed. You can just use the reference. If you have not modified the name of the 1:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Maybe Sean was remembering this thread: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/help-with-select-query-needed-60f6ca6882ef8b12c4ca4c36?page=2.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
You have got a nice explanation of the issue you encountered, now what about an actual solution? Here is my take at the magical one-liner (even as it is so long that it takes several lines to display…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
In a "select" statement, the square brackets may always be used instead of a "where" clause. But there is more: they can also be used to filter related records,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
This formula: (select History)[Type = 6]) builds an array containing handles to the records where "Type = 6". You are then counting the number of elements in that array.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view

1 5 6 7 8 9 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Convert table to subtable

Re: Info delete Field

Re: Pass current viewing record Id to a view element column formula

Re: How to import data from text field to dynamic choice field

Re: NEW FORUM

Re: NEW FORUM

Re: NEW FORUM

Re: NEW FORUM

Re: Connect 2 Records from 2 Tables, based on 2 or More Parameters

Re: Applying filters on a lookup table by choosen field

Re: Applying filters on a lookup table by choosen field

Re: Show all records in another record that are related by an ID

Re: How to import data from text field to dynamic choice field

Re: How to turn 5x reference columns in a CSV into a single reference column containing all 5?

Re: Linking Tables

Re: Find duplicates

Re: Select last child record

Re: Select last child record

Re: Order by descending

Re: How to Sort Localisation fields properly ?

Re: How to count days

Re: How to count days

Overview