Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: All I want for Christmas!
To clarify a bit more: a handle to the host record should be available inside views (the layout elements) and inside reference fields.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to select a row from a composition table to display in a superform
@Fred Hi Fred, this may sound pedantic but anyway. Ninox is not shy of producing arrays of dates. BUT, it does not provide a default way to display such an array,…
- Alain_Fontaine
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Creating an address block from different fields
And another proposed solution: let c := join([City, State, 'Post Code'][!= ""], " "); join(['Address Line 1', 'Address Line 2', 'Address Line 3', 'Address Line 4', c][!= ""], " ")
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Creating an address block from different fields
@Michael The fact that the script works exactly the same without introducing the variable "t" is not surprising, since in this case it is completely redundant.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Are there Trigger limitations?
I did verify that it does not work on the iPad version, with a local database. So it does not seem to be an iCloud problem.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Joining text strings with carriage return
You could fix the multi-line adresses with: replacex('Computed address', " +", " ")
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
A function to determine the position of a given element in an array. The "item()" function can be used to address an element in both an array and in a string.…
- Alain_Fontaine
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Seek help to find array position number in a array loop
I was about to propose another solution: let bAc := "," + concat(bA.Id) + ","; … let fac := index(bAc, "," + text(fa) + ","); It works on the same principle,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice Field text (Value) vs Number - Where can I find them?
@havrup I would add that the formula proposed allows to export the content of any field from the "GEO" table. If you just want to export the text displayed in the DC field itself,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Are there Trigger limitations?
Sorry, I did not interpret the "it does't work" as you intended. And, believing thar it did indeed work in the first case (as IMO it should), I did not perform my own test.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
Unless someone knows better, I would declare the parameter to be a "number", and call the function with number(Sesso) as parameter.
- Alain_Fontaine
- 3 yrs ago
- 2
- Get help
- Reported - view
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
- 3 yrs ago
- Get help
- Reported - view
Re: Character Occurrences Count
@Gianluca Of course, regular expressions are well known to be "write only" .
- Alain_Fontaine
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 1
- Learn and share
- Reported - view

1 4 5 6 7 8 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: All I want for Christmas!

Re: How to select a row from a composition table to display in a superform

Re: Creating an address block from different fields

Re: Creating an address block from different fields

Re: Are there Trigger limitations?

Re: Joining text strings with carriage return

Re: All I want for Christmas!

Re: Seek help to find array position number in a array loop

Re: Dynamic Choice Field text (Value) vs Number - Where can I find them?

Re: Are there Trigger limitations?

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Character Occurrences Count

Re: Are there Trigger limitations?

Re: Dynamic Choice Field text (Value) vs Number - Where can I find them?

Re: All I want for Christmas!

Re: All I want for Christmas!

Re: Linking populated tables

Re: acces to array items like with Where fonction

Overview