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: How to sort SubTable fields in summary formula field in MainTable
It seems that you are expecting the function that gathers the linked records to be somewhat "aware" of the sort order set in the subtable display. It is not the case:…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Counting records in a child table and storing the value in a field of a master table
In a "select" statement, the context for the evaluation of the filtering condition is, in turn, each record of the table named after "select". You are calling table "T2",…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Initials
The expression matches a suite consisting of: (\S) : a single non-space ; put in parentheses so it is memorized if found ; \S* : zero or more non-spaces ; \s+ : one or more spaces or equivalent.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
1
Get help
Reported - view
Re: Initials
This kind of problem can also be solved with a regular expression ("Text" is the name of the source field): replacex(Text + " ", "(\S)\S*\s+", "g", "$1")
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Many-to-Many relation: how to create lists for printing
There is nothing below "MN relation" because that table does not include any data field. Drag a formula (first item in the list on the right) into the list on the left.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Select from array
Another way would be to populate the dynamic choice with a formula like: (select Table1)[let myText := Text; Id = first((select Table1)[Text = myText])] "Table1" is the source table,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Choice (dynamic) as view filter
Are you trying to show filtered records from the "Entry" table in some kind of Dashboard table? Another option is to fiddle with the formula used to fill the view.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Showing top performers based on linked records
Before going further: it seems that there is a N:1 relation between "Participants" and "Challenges", which means that a participant can only... participate in one challenge. Right?
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
If you really want to use a "select" statement to fill the dynamic choice, you could write: let cat := text(Category);(select Subcategory where Category.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: How to use text from textfield in a formula
If the Text field "MyFormula" contains a formula, the formula "eval(MyFormula, this)" in a Formula field will read and interpret it.
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Ninox for Mac not responding
I posted another data point showing the difference in performance between using the "select" statement and following the references in this thread: https://ninox.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Working with charts
In the "Table" visualization of a 1:N relation, you can add columns showing the value of any field of the child table. Just tap the header of the table: a popup appears,…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: Replicating a value in a different field via a button
Hi John, Brilliant solution! Will keep it in mind for solving the "last - 1" puzzle…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
Re: using formula to update fields or delete records
Another way to solve the problem: create a formula field in the "Student Information" table, name it, for example, "Best Score", and set the formula to: max('Typing Scores'.…
Alain Fontaine
Alain_Fontaine
2 yrs ago
Get help
Reported - view
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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 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
2 yrs ago
Get help
Reported - view
1
5
6
7
8
9
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics