Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Alain Fontaine
Alain_Fontaine
426
89
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Timestamp - 24 hours
You said "prior"… Replace "+" by "-".
Alain Fontaine
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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Purging Job History
Maybe: if myDate > today() - 2190 then
Alain Fontaine
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
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
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
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
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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
1
7
8
9
10
11
18
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics