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: Cascading Selection Fields with a twist
@Gianluca This solution is only possible because there are very few - actually two - possibilities. While working with the choices, I noticed that gigantic switch statement triggered by "Mansione".…
Attachment
Alain Fontaine
Alain_Fontaine
1 yr ago
1
Get help
Reported - view
Re: Cascading Selection Fields with a twist
Yet another problem that would be easy to solve if one could access the fields of the host record from inside a construct that changes the context. In this case, one could:…
Attachment
Alain Fontaine
Alain_Fontaine
1 yr ago
2
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
For a dynamic choice field, the number returned is always the reference number (aka "Id") of the record in the "source" table providing the chosen item.…
Alain Fontaine
Alain_Fontaine
1 yr ago
2
Get help
Reported - view
Re: All I want for Christmas!
A "single record view". The existing "view" layout element allows to display a set (technically, an array) of records defined by a formula. Its operates much like a 1:N reference field,…
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: All I want for Christmas!
Arguing with myself (senility ?)… If such an option would exist, the context for the script execution would certainly be the target record itself. Which means that the fields of that record would be…
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: Choose more than one?
@John Halls Not a one-liner yet, but close
.
Alain Fontaine
Alain_Fontaine
1 yr ago
2
Get help
Reported - view
Re: Search with Multiple Choice problem
@Rafael In the "No Emitidos" view, there is a filter on the "FechaR1" column. Only the lines where this field is empty would be displayed, in addition to the conditions set in the formula.
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: Search with Multiple Choice problem
@Rafael If you want to see the records of the table "Documentos" whose selected date falls in the stated interval AND where the field "Ganado REAL" is "null",…
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
Everything Lars said about "select" always returning an array is true. But did you notice that your original formula did work without specifying "first(…)"? Sometimes,…
Alain Fontaine
Alain_Fontaine
1 yr ago
2
Get help
Reported - view
Re: Search with Multiple Choice problem
@Fred The magic lies in the expression: b[=t]. Its effect is to filter the array "b", keeping only the elements that satisfy the condition inside the square brackets, in this case,…
Alain Fontaine
Alain_Fontaine
1 yr ago
1
Get help
Reported - view
Re: Search with Multiple Choice problem
I had a look at your database, and devised the following formula to fill the view: let b := numbers(Busqueda); (select Documentos)[( let t := number('Tipo Documentos');…
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: Converting an input to an output
You could try something like: switch true do case 'Watts Input' != null: 'Watts Input' * 3.41 case 'BTU Input' != null: 'BTU Input' case 'Temp Input' != null: 'Temp Input' * 1.8 end
Alain Fontaine
Alain_Fontaine
1 yr ago
Get help
Reported - view
Re: All I want for Christmas!
@Fred It is one of the uses I was envisioning for the "On click" script…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: All I want for Christmas!
In the views, and in the Reference fields, an "On click" option. This would be a place to define a script when the N:1 or one of the items of a 1:N or a view is cliked,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Get help
Reported - view
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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 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
Alain_Fontaine
2 yrs ago
2
Get help
Reported - view
1
2
3
4
5
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics