Alain Fontaine

Alain_Fontaine

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

My Posts

Latest Posts

Re: illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)
Hint: This: max((select QuoteLines).QLnum) gives the largest value of QLnum in the entire QuiteLines file. This: max(QuoteLines.QLnum) should give the largest value of QLnum among the records linked…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Custom maxId reset after 200
Solutions based on the Ninox Id are robust, since it is guaranteed to be unique and never reused. But if you delete a record, its number is of course lost forever, per the non-reuse.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Custom maxId reset after 200
It should work in the same place, Trigger on create. Another possibility would be to make "ID Pratica n." a formula field, defined as: let n := number(Id) - 1;1 + n - floor(n / 200) * 200
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Common field in many-to-many relationship
That's why I suggested to put the attribute as a field inside the Bridge table. Nothing prevents you from adding data fields in the Bridge table in addition to the two reference fields,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Common field in many-to-many relationship
How to set up? Since the "unique attribute" is a characteristic of the relation between the Keyword and the Article, it must be stored as a field in the bridging table.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Are the numbers of fields limited ?
Just another idea: you can start by moving the last field listed in the right column, and proceed from bottom to top. So, once that last field is in place,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Custom maxId reset after 200
One option could be to build the needed serial number by using the record reference number, the numeric part of the automatically created record identifier.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Are the numbers of fields limited ?
The problem is that it is very difficult (but not impossible) to add an element at very end of either list when the list is filled to the bottom. And the trick is to add an irrelevant element at the…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Are the numbers of fields limited ?
What I do in such a situation: I add a "Line break" layout element at the bottomm of the list. I can then add whatever I need before that Line break. When the operation is completed,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Show Ninox's Unique ID Number In Field
Does this give what you need: "ABCD" + format(number(Id), "000")
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Creating a new record in a linked table using code
You are almost there... Two things: - use the "record()" function to create a record handle for the desired record in "Locations"; - set the reference field itself - not the ID of the referenced…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Table - grouped by item, sum value, rate?
I suppose that "Grouped Item" means that the same value of ITEM_ID may happen in several records. In the formula below, replace "Table1" by the actual name of your table.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Help with counting number of status line in subform
I am glad that you git the result you expected. I don't understand why styled() does not work, but if you need to only show a colored patch with no text in it, color() is fine.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Help with counting number of status line in subform
Sorry, I had not paid enough attention to the definitions of the various fields. The formula below, as the definition of the "Alert" formula field, should work better: styled("",…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Not getting past else
Thank you for taking the time to write down that explanation. The code below should do what you expect at this point. It works by taking advantage of the existence of a relation between the two…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Not getting past else
OK, from the context I suppose it is 1:N from Pay to PayChecks. And so, among the fields of the Pay table, there should be a field named (by default) "PayChecks".…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Conversion date en chiffre
Ben oui: comme écrit précédemment, la fonction days('debut', fin), avec "s" à la fin, à ne pas confondre avec la fonction day() sans "s", renvoie un entier qui est le nombre de jours écoulés entre…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Not getting past else
Trying to understand the context... Is the button in the "PayChecks" table, or in another table? if in another table, is there a relation whith the "PayChecks" table?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Conversion date en chiffre
Il y a une fonction pour : days(date_debut, date_fin).
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Help with counting number of status line in subform
"Alert" is a function field, yes? styled("", if cnt(Tracking[Status = 1].Process) >= 2 or cnt(Tracking[Status = 1].Conduct) >= 2 then "red" else "blue")
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Help with counting number of status line in subform
Just a hint? Maybe something like: cnt(Tracking[Status = 1].Process) > 1 or cnt(Tracking[Status = 1].Conduct) > 1
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Can I create a button that will fill a linked field with a set value?
With a left to right arrow, if you click on that line in the list it will open a detailed view titled "Reference from ITEMS to S_CODES (N : 1)". If, in the definitions of the "Source_Code" and…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Can I create a button that will fill a linked field with a set value?
May I ask you: S_CODES: linked to Table S_CODES Is it 1:N or N:1?
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Expiration date in colour
As far as I understand the matter, it is not possible to set the colo(u)r of a data field. it is only possibke to set the style of a function field, because the formatting is done by including the…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Creating serial numbers for group and sub groups
Using number(Id) is indeed a good way to get unique serial numbers. If, in your business case, you need serial numbers that start at "1" for each group inside a box,…
- 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: illusion of Inserting new lines into middle of child table ((invoice/order/quote) lines)

Re: Custom maxId reset after 200

Re: Custom maxId reset after 200

Re: Common field in many-to-many relationship

Re: Common field in many-to-many relationship

Re: Are the numbers of fields limited ?

Re: Custom maxId reset after 200

Re: Are the numbers of fields limited ?

Re: Are the numbers of fields limited ?

Re: Show Ninox's Unique ID Number In Field

Re: Creating a new record in a linked table using code

Re: Table - grouped by item, sum value, rate?

Re: Help with counting number of status line in subform

Re: Help with counting number of status line in subform

Re: Not getting past else

Re: Not getting past else

Re: Conversion date en chiffre

Re: Not getting past else

Re: Conversion date en chiffre

Re: Help with counting number of status line in subform

Re: Help with counting number of status line in subform

Re: Can I create a button that will fill a linked field with a set value?

Re: Can I create a button that will fill a linked field with a set value?

Re: Expiration date in colour

Re: Creating serial numbers for group and sub groups

Overview