Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: add field by script
The "select" statement does indeed return an array of records in all circumstances. But in this case, the "select" statement is not needed at all. One can establish a relation by setting the N:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Splitting data or trimming where a space is
Another way to solve this class of problems is to apply some magic, er, I mean, some regular expressions. The two following functions, entered in two Formula fields,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Views
Since there are relations in place between the tables, it should be possible to fill the view by navigating those relations instead of resorting to the almighty 'select' function.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Auto create records in sub-table
May I suggest a slight variation? The advantage is that, if the set of named topics changes, one must just update the vector, without needing to also separately update the number of elements.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice triggers twice
Let "x" be the value that must be converted. Applying "offset" and "factor" once must give the same result as applying "o2" and "f2" twice: (x + offset) * factor = ((x + o2) * f2 + o2) * f2 x *…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
When doing something once, finding the optimal solution is not indispensable. Nevetheless, you could have saved yourself some work by: opening the "Treatments" table,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Duration( Appointment ) = End( Appointment ) – Start( Appointment ) result in hours only ( hh:mm ) not days (dd:hh)
This formula gives the duration of an appointment in (fractional) hours. The magic number is the number of milleseconds in one hour: number(duration(Appointment)) / 3600000
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Whi does while loop not work
While Steven's formula is the best way to solve your problem, it may still interest you to understand why your script does not give the expected result.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
Hi,It seems indeed possible to produce a more focused view by selecting records from the "Treatments" list. In the "Treatmentlist" table, I defined a number field "Days" to hold the "standard" number…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
Strange that it does not work with a "Choice (dynamic)" field (not "Multiple choice (dynamic)". Technically, a N:1 reference field fits, but there is a risk to inadvertently create new records in the…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
At any time, in any place, "Id" represent a handle to the record that is part of the current context. In the conditional expression of a "select" statement, the context is, in turn,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
@John: if by "this technique", you mean encapsulating a condition on a reference inside the condition of a select statement, it is something I just came to while looking for the solution to this…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
It seems possible to solve the puzzle with only the existing tables and relations: let myT := "," + Treatment + ",";let myD := today() - Days;(select Visits)[last(Patients.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Timestamp - 24 hours
"+" works, but not "-"… Ninox is an inexhaustible source of fun. And just to enjoy the funny side of life, this works: let d := -86400000;'Date / Time' :…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
This problem can be solved by turning it upside down. I mean, instead of selecting Patients, select Treatments. To ease the tests, in the Dashboard table,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
The issue with "numbers" is of course the same as with "select", namely that Ninox has a problem with formulas returning an array appearing as a column in a tabular view.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Purging Job History
After getting your wife back, are you still looking for a way to automatically delete records that are more than 6 years old, with a pivot date set at April, first?…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Timestamp - 24 hours
You said "prior"… Replace "+" by "-".
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Timestamp - 24 hours
'Date / Time' := now() + 86400000 The magic number is the number of millisecondes in a day.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Purging Job History
Maybe: if myDate > today() - 2190 then
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: the chosen one (or not)
About the issue concerning the display of arrays in column formulas, did you read my answer in the thread you initiated ("disappearing formulas")?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: the chosen one (or not)
The subject has been discussed here: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/vlookup-formula-between-2-tables-5e7893acd7072204e5f22704?post=5e7893acd7072204e5f22705
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
It seems that a new record is created each day, hence the default values. How is it created? Manually, by a script, … ?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Import into table with Multiple Choice (Dynamic) field/column
I had to check this… Unfortunately, the array notation is not interpreted correctly when importing data fron an external file. What is more surprising is that "Update multiple records…" does not…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Import into table with Multiple Choice (Dynamic) field/column
Just an idea — I did *not* test this. The blog entry announcing version 3.4.0, which seems to have disappeared, mentioned that a MC(D) field can be set by using the "array" notation — actually an…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view

1 7 8 9 10 11 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: add field by script

Re: Splitting data or trimming where a space is

Re: Views

Re: Auto create records in sub-table

Re: Dynamic Choice triggers twice

Re: Help with SELECT query needed!

Re: Duration( Appointment ) = End( Appointment ) – Start( Appointment ) result in hours only ( hh:mm ) not days (dd:hh)

Re: Whi does while loop not work

Re: Help with SELECT query needed!

Re: Help with SELECT query needed!

Re: Help with SELECT query needed!

Re: Help with SELECT query needed!

Re: Help with SELECT query needed!

Re: Timestamp - 24 hours

Re: Help with SELECT query needed!

Re: disappearing formulas

Re: Purging Job History

Re: Timestamp - 24 hours

Re: Timestamp - 24 hours

Re: Purging Job History

Re: the chosen one (or not)

Re: the chosen one (or not)

Re: YES / NO Default value

Re: Import into table with Multiple Choice (Dynamic) field/column

Re: Import into table with Multiple Choice (Dynamic) field/column

Overview