Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: How to count days
To count the number of records where type is this or that, I bet that you are implicitly building an array, and then counting the number of elements. What is the formula you use to solve problems #1…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
I would say that you need to gather the dates in an array, and then compute cnt(unique( that array )).
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Trouble with two table references - same settings, different results.
Mmmm... I don't remember seeing this kind of details in the manual. Working with Ninox feels more like an experience in physics (send particles in a collision course, see what happens, build a theory,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Trouble with two table references - same settings, different results.
What is displayed for a N:1 reference shown as a "Popup" is governed by the function entered in the "Show as" option under "More options". If the option if left blank,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
If you prefer to keep the original style of your references, you can define another field for sorting. This field can be a formula producing correctly sortable values from your original references.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
@John: By "the 1.5 trick", I mean the neat idea of adding or substracting the value "1.5" to/from the value of the "ORDER" field in the record that must be reordered,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
The "select" function is so much slower than following references that it is indeed a good practice to avoid it when possible. In a small database, the difference will not be sensible, but,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Showing next months data
The use if a variable ("janu") is not strictly necessary. But since the result of comparing the current month with "1" is needed two times, it makes sense to compute it once and store it in a…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Showing next months data
For the preceding month, something like: let janu := month(today()) = 1;month('Date & Time') = if janu then 12 else month(today()) - 1 end and year('Date & Time') = year(today()) - number(janu)
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Auto increment in subtable
I loaded the proposed solution in the iPad version of Ninox, and, unfortunately, the new records in the "BEATS" table are always numbered "1". I am not surprised,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to copy a row or just few collummns from one table to another using a button
It's a matter of context. Inside the parentheses "c.( … )", the context is the just created record of the table "Delivery List", designated by the handle "c".…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 6 7 8 9 10 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: How to count days

Re: How to count days

Re: Trouble with two table references - same settings, different results.

Re: Trouble with two table references - same settings, different results.

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Auto increment in subtable

Re: Auto increment in subtable

Re: Showing next months data

Re: Showing next months data

Re: Auto increment in subtable

Re: How to copy a row or just few collummns from one table to another using a button

Re: How to sort SubTable fields in summary formula field in MainTable

Re: Counting records in a child table and storing the value in a field of a master table

Re: Initials

Re: Initials

Re: Many-to-Many relation: how to create lists for printing

Re: Select from array

Re: Choice (dynamic) as view filter

Re: Showing top performers based on linked records

Re: Unable to populate related table in Choice (dynamic) field

Re: How to use text from textfield in a formula

Re: Ninox for Mac not responding

Re: Working with charts

Re: Replicating a value in a different field via a button

Re: using formula to update fields or delete records

Overview