Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: Autonumber a filtered list
I suppose that the purpose of the "Counter" field in the first record of the "Counters" table is to keep the last value between executions of the script.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with sorting on 4 columns
When numbers formatted as text are sorted, the sorting is indeed performed on the numerical values of the ASCII (or Unicode) codes of the characters representing the digits.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: If a text field has > 30 '#' then show alert
Another possible approach: item(split(text(Location), ", "), 0). This would fail if the string ", " appears anywhere inside the text of the location, which is not impossible,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Calculating a time duration over midnight
You can add: timeinterval(86400000). The magical number in the argument is the number of milliseconds in a day.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Automatically link two tables
You don't explain how the "Pricing" table is organized. Let's suppose that it has two fields: "To" is the last age at wich a price is applicable, and "Price" is the corresponding price.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Help with sorting on 4 columns
If the numbers are integers, you can also format them with an appropriate number of leading zeroes: format(Value1,"000000000") + format(Value2,"000000000") + format(Value3,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: 2 choices trigger same action
Datefield2 := if Status = 1 or Status = 2 then Datefield1 else null end;Datefield4 := if Status = 1 or Status = 2 then Datefield3 else null end
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Manage stock with unique id
I would define two tables. The first one with one record for each model, with fields containing all the informations needed to describe a given model. The second table would contain the serial number…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Resolving a bill of materials
The data structure you describe is recursive. Recursive data structures are wild animals that are not easy to tame. In CS textbook, the standard solution is to write a program involving recursive…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Field - Filtering for "yes" is blank but "no" shows all records "yes" or "no"
The best formula is the second one. The first one is 200% over engineered... It is strange that the filtering does not work. I have it working both when defining a "Fomula" field and showing it in…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Filter / compare two fields
In the tabular view, I would add a new "Formula" column, with the formula "field1 = field2". It then suffices to define a filter on that column, in this case with the value "No".
- Alain_Fontaine
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Choice field as a switch question.
It is difficult to make an assumption on the performance aspect, not knowing what kind of optimization or maybe pre-compilation Ninox does internally. Something that would probably speed things up…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
Unfortunately, it seems difficult to find tests that gives real inside information. It is also quite possible that the various versions of Ninox, running in different environments,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Inconsitancy by data aggregation
Indeed, the format you define for a number field only affects the display. Internally, I am pretty sure that Ninox stores all the numbers in binary floating point format (BFP).…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Lookup in date range
When a "select" statement is executed, each record of the designated table is presented, in turn, to the test. The test itself is thus evaluated in the context of each record, in turn, of that table.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Lookup in date range
In the select statement, I would replace "SD" with "Valid from" and "ED" with "Valid to", thereby comparing the fixed value contained in the variable "OrderDate" with the values of those fields in…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Choice field as a switch question.
For the sake of diversity, another way to compute it in "functional" style, illustrating the use of the "chosen" function with a second argument: 25 * number(chosen(Lined_Per_Width,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
The problem seems to come from the "Hors_redevances" field. This field is empty in some records of the "Ventes" table. You can correct the isue by updating those records with the value "no",…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: N:M relation in a view
It's hard to debug something without actually seeing it... I suppose that the schema has not changed, except that the "Sales" table is now called "Ventes",…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: follow up on previous question and problem with equation
Or maybe simply : last('Rope Inspection Report' order by 'Inspection Date').Result
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Error: Expression does not return multiple values
My take on the issue: when you add the filter, Ninox applies it to the derefencing of the "'Subject Allocation'" reference field only. This field is N:1,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Get a value from parent table
In a table/subtable relation, the N:1 reference field is in the subtable. So you can fill fields of the subtable with data from the fields of the main table.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Get a value from parent table
The usual reply is that this kind of script must be placed in the "Trigger after update" option of the reference field, which is only available on the "N:1" side of the relation.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Accidently turned table into subtable
While defining a reference field, did you set the “Composition” field to “Yes”?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: if statement
This seems to indicate that there is no record from Table1 linked to the current record in Table2. Did you establish a link, for example by using the magnifying glass associated with the reference…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view

1 11 12 13 14 15 16 17

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Autonumber a filtered list

Re: Help with sorting on 4 columns

Re: If a text field has > 30 '#' then show alert

Re: Calculating a time duration over midnight

Re: Automatically link two tables

Re: Help with sorting on 4 columns

Re: 2 choices trigger same action

Re: Manage stock with unique id

Re: Resolving a bill of materials

Re: Formula Field - Filtering for "yes" is blank but "no" shows all records "yes" or "no"

Re: Filter / compare two fields

Re: Choice field as a switch question.

Re: Inconsitancy by data aggregation

Re: Inconsitancy by data aggregation

Re: Lookup in date range

Re: Lookup in date range

Re: Choice field as a switch question.

Re: N:M relation in a view

Re: N:M relation in a view

Re: follow up on previous question and problem with equation

Re: Error: Expression does not return multiple values

Re: Get a value from parent table

Re: Get a value from parent table

Re: Accidently turned table into subtable

Re: if statement

Overview