Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Alain Fontaine
Alain_Fontaine
390
72
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
Re: Character Occurrences Count
@Gianluca Yes, the three strings must have the same length. The same applies for the latest way to compute the checksum, of course.
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Character Occurrences Count
@Gianluca Of course, regular expressions are well known to be "write only"
.
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Get help
Reported - view
Re: Character Occurrences Count
I suspected that such a convoluted specification could only come from an administration 8-). So, knowing the specification, I am submitting my last word on the subject.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
2
Get help
Reported - view
Re: Character Occurrences Count
And a proposal for the complete computation of the checksum (boy, I had some spare time today, and it rains): let xCarDis := substr(cfparz, 0, 1) + substr(cfparz, 2, 1) + substr(cfparz, 4,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
4
Get help
Reported - view
Re: Character Occurrences Count
Still digging into your script… This: if length(text(day(DataNascita))) = 1 then "0" + text(day(DataNascita)) else text(day(DataNascita)) end seems to give the same result as:…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Character Occurrences Count
I did not try to understand it all, but I can see, for example, that the computation of "finalC" can be reduced to: let finalC := item("ABCDEFGHIJKLMNOPQRSTUVWXYZ", round(resto));…
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Get help
Reported - view
Re: Character Occurrences Count
@John Halls Unfortunately, your solution fails if two occurences of the letter of interest are immediate neighbors. The reason is that this produces a null element in the array,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Character Occurrences Count
Another way to solve such a problem would be to harness the power of regular expressions, replacing the loop by: length(replacex(myString, "[^" + myLetter + "]", "g", ""))
Alain Fontaine
Alain_Fontaine
2 yrs ago
3
Get help
Reported - view
Re: Are there Trigger limitations?
What you are seeing has nothing to do with the use of triggers, but is just the result of how Ninox treats type casting. You would have exactly the same result in a script attached to a button.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field text (Value) vs Number - Where can I find them?
You can create a global tabular view in you "MAIN" table, called for example "Export", and include as columns the fields you want in your export. For the DCF fields, don’t include them,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
A way to access the fields of the record hosting a view from a formula column of the view, as discussed here:…
Alain Fontaine
Alain_Fontaine
2 yrs ago
2
Get help
Reported - view
Re: All I want for Christmas!
"Auto Number", as you call it, would also be immensely useful as a choice in the context of "Update multiple records…"
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Get help
Reported - view
Re: Linking populated tables
So you have discovered that Ninox does not make links between tables by looking at the values of some data fields, but that it only uses its internal record identifiers.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: acces to array items like with Where fonction
And yet another one: it seems that, inside the square brackets, the keyword "this" represents, in turn, the value of each element of the array. So one can do things like: myTable[substr(this, 0,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Learn & Share
Reported - view
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
Alain_Fontaine
2 yrs ago
1
Learn & 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
Alain_Fontaine
2 yrs ago
Learn & 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
Alain_Fontaine
2 yrs ago
1
Learn & 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 yrs ago
Learn & 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
Alain_Fontaine
2 yrs ago
Learn & Share
Reported - view
Re: NEW FORUM
Perhaps more annoying: all the existing links to previous threads now return 404...
Alain Fontaine
Alain_Fontaine
2 yrs ago
Learn & 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
Alain_Fontaine
2 yrs ago
Learn & Share
Reported - view
1
3
4
5
6
7
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics