Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Iterate over DC
It is possible to extend the model with dynamic selections.
Attachment
- Alain_Fontaine
- 2 yrs ago
- Get help
- Reported - view
Re: Iterate over DC
Do you mean something like this:
Attachment
- Alain_Fontaine
- 2 yrs ago
- Get help
- Reported - view
Re: Sort / Order by based on total count
You could perhaps try something like: let lieferantName := record('ProjektStückliste',number('Lieferant Auswahl')).Lieferant; let nennweite := record('ProjektStückliste',number('Nennweite Auswahl')).…
- Alain_Fontaine
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to select current register within 'select' function
I tried to explain my understanding of this issue here: https://forum.ninox.com/t/h7hrz3a?r=83hrsl3
- Alain_Fontaine
- 2 yrs ago
- Get help
- Reported - view
Re: Show "1" instead UNDEFINED
You could try: if trim(x) = "undefined" then… P.S. "debugValueInfo()" is your friend.
- Alain_Fontaine
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Need Help with view table.
When no search field is filled, this option is selected: case "": (select Data) You could try: case "": (select Data)[false]
- Alain_Fontaine
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred In had to solve a similar problem some time ago. Here is a small database I made to test two possible solutions.
Attachment
- Alain_Fontaine
- 2 yrs ago
- 2
- Learn and share
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@John Halls Here is the minimum mockup I made to test the idea.
Attachment
- Alain_Fontaine
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@John Halls I did not test this on a large database, but it is possible that the variant below could be somewhat faster: let cId := ClientId; (select Chronos)[Subset].(Subset := null); Chronos.…
- Alain_Fontaine
- 2 yrs ago
- Get help
- Reported - view
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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs ago
- Get help
- Reported - view
Re: Choose more than one?
@John Halls Not a one-liner yet, but close .
- Alain_Fontaine
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 yrs 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
- 3 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
- 3 yrs ago
- 1
- Get help
- Reported - view

1 3 4 5 6 7 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Rich Text Field frustration - help :-(

Re: multiple conditions is Display if:

Re: Iterate over DC

Re: Iterate over DC

Re: Sort / Order by based on total count

Re: How to select current register within 'select' function

Re: Show "1" instead UNDEFINED

Re: Need Help with view table.

Re: Track selection of Dynamic Multiple Choice field

Re: Creating a Button That Goes to Table with only Linked Records

Re: Creating a Button That Goes to Table with only Linked Records

Re: Cascading Selection Fields with a twist

Re: Cascading Selection Fields with a twist

Re: Dynamic Choice Field reference in a function

Re: All I want for Christmas!

Re: All I want for Christmas!

Re: Choose more than one?

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Dynamic Choice Field reference in a function

Re: Search with Multiple Choice problem

Re: Search with Multiple Choice problem

Re: Converting an input to an output

Re: All I want for Christmas!

Re: All I want for Christmas!

Overview