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: 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
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
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
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
Alain_Fontaine
3 yrs ago
Learn & 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
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
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
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
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
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
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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 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
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: if statement
It works as expected in my mockup of your database... Could you, in Table2, create a formula field containing: “debugValueInfo(Table1.Code)” and post the result?
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: if statement
It seems that you established a relation between your tables by creating a reference field. But in what direction? I mean, if, in the fields of Table2, you look at the Reference field named Table1,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
I am not a professional developer, but a just retired ICT guy having fun with a new toy, and trying to give some help by sharing a few tricks... So, with this new year,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
There should be only one opening parenthesis between “unique” and “Œuvres”.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
Strange… I have made a local mockup of your database to test the function, and it works. But it may be that I did not correctly understand the structure of your database.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Timestamp UTC/GMT - formatted in english
Would you mind sharing the solution? Still eager to learn...
Alain Fontaine
Alain_Fontaine
3 yrs ago
Learn & Share
Reported - view
Re: Timestamp UTC/GMT - formatted in english
The idea was indeed to adapt to the current offset. Maybe the way it is supposed to work is not valid on the Mac version. You may try this alternative formula: let stamp := now();let offs :…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Learn & Share
Reported - view
1
10
11
12
13
14
15
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics