Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: disappearing formulas
The first lesson from this thread is that, before resorting to the almighty "select" function, one should always check if the desired result cannot be obtained by perusing the existing relations in…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to update automatically "Trigger after update" option of a field?
OK, I understand why you wanted to use a choice field. Another possibility is to define EtatAvancement as function field, and to compute its value as a number between 0 and 5,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: UNION selections
Parent table: "Table1". Child tables: "Table2" and "Table3". Reference fields with their default names. In "Table1", add a "View" layout element, and populate it with the expression: array(Table2,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: How to update automatically "Trigger after update" option of a field?
By definition, an action defined as a "Trigger after update" will only be executed after a field update, and never by itself. So, as you suggest, a global update action must be defined,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Order by descending
Nice idea. It can be extended to dates: if you need to reverse sort on a date field, you can write, for example: (select SomeTable) order by today() - SomeDate
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Fields as a Global Variable on Mac app
There has been a discussion on this subject three months ago:…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: YES/NO use like to show / hide table element
The select statement returns an array of boolean values, and not a single booelan value as you expect. So you must reduce the array to a single value. How to do it depends on what kind of data is…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field Coding Problem
Indeed, the pair of "---" is the alternative string building operator. One can also write: let zSelected := ", " + concat(numbers(Choice)) + ", ";sum((select Products where contains(zSelected, ",…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field Coding Problem
In another style, if you prefer: let t := 0;for i in numbers(Choice) do t := t + record(Products,i).Weightend;t
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Multiple Choice Field Coding Problem
Dynamic choice fields are weird animals. Your formula would work for a (single) dynamic choice field. Multiple choice are even stranger, and need more elaborated formulas: let zSelected := ---,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
What happens if you replace the first line by: let c := number(Id); Cannot the last line be simplified as: bc.'CLOSE 5000'
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Use Update Trigger to Chnage the value in Linked Record
In the "Products" table, is the reference to the "Features" table 1:N or N:1?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Round to nearest $5?
Maybe a formula like: round(Number / 5) * 5
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Automatic record creation
Since Table2 is a subtable of Table1, there is no need to use a Select statement to find the records of Table2 linked to the current record of Table1. You can simply peruse the existing relation.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Odd Database behavior
I would say that using "this" directly is not really disallowed, but that it is generally useless. "this" represents the record that is current in the active context.…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Link record n:1
The original script can also be reduced to: let myID := Id;(create SecondTable).(FirstTable := myID) Now, if some fields of the newly created record must receive a value,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Link record n:1
I have an immoderate love for one-liners: FirstTable := (create FirstTable) If there is already a linked record, it will be replaced by the newly created one.
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Struggling to get Display Field Only If to work with null values
Strange... I tested it and it worked (at least on the iPad version). Another approach would be to insert the test in the formula itself: if 'Competitor Price' = null thennullelse>>>> insert your…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Relationship between a table and itself
There is no barrier in Ninox preventing the creation of multiple relations between the same set of tables, or even between a table and itself. While it is always a good idea to rename the reference…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
Mmmmm... Seems I did not read your description correctly. The formula shoud actually be: let zSelected := "," + text(numbers('Employé')) + ","; concat((select Collaborateurs where contains(zSelected,…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
Indeed, "chosen()" does not work for dynamic multiple choice (DMC) fields. If you think about it, it does somewhat make sense: a DMC field is "populated" by submitting a function that returns an…
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
How is your dynamic multiple choice field filled? I mean, what is the formula in "Dynamic value"?
- Alain_Fontaine
- 3 yrs ago
- Get help
- Reported - view
Re: Bundled Product Circular Reference
A similar problem has been treated here: https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/resolving-a-bill-of-materials-60099f17f3f37f54ab80cc7c
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Searching in a n:1:n table not working
Not exactly what you are asking, but maybe a way to make the problem manageable. In the "family structure" table, create a button, named "Add payment", with the script: let lastpay :…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Counting the number of
I did use the select statement in numerous formula fields without apparent problems. I mean that I did not notice missing or spurious records. Maybe I just overlooked them...…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view

1 8 9 10 11 12 18

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: disappearing formulas

Re: How to update automatically "Trigger after update" option of a field?

Re: UNION selections

Re: How to update automatically "Trigger after update" option of a field?

Re: Order by descending

Re: Fields as a Global Variable on Mac app

Re: YES/NO use like to show / hide table element

Re: Dynamic Multiple Choice Field Coding Problem

Re: Dynamic Multiple Choice Field Coding Problem

Re: Dynamic Multiple Choice Field Coding Problem

Re: use yesterday's information in the table

Re: Use Update Trigger to Chnage the value in Linked Record

Re: Round to nearest $5?

Re: Automatic record creation

Re: Odd Database behavior

Re: Link record n:1

Re: Link record n:1

Re: Struggling to get Display Field Only If to work with null values

Re: Relationship between a table and itself

Re: VLOOKUP formula between 2 tables

Re: VLOOKUP formula between 2 tables

Re: VLOOKUP formula between 2 tables

Re: Bundled Product Circular Reference

Re: Searching in a n:1:n table not working

Re: Counting the number of

Overview