Describe the problem to be solved
an issue found by @mathieugimenez
Using a reference column to trigger a formula will only trigger if you change the referenced option (as the line/id will change) but won't trigger if you change the value displayed in the displayed column.
Ex: I have a trigger formula to generate an ID :"PROJ" + $project.Name , with $project being a reference column pointing to table "Projects". I set the formula to be triggered when $project is modified or new line added.
I choose a project on a line --> formula is triggered.
I now change the value of Name in the Projects table --> formula not triggered
Describe the solution you would like
Looks logical that it's triggered only when the referenced record changes, but would be great if the formula could be triggered when reference value displayed in the column changes.
Describe the problem to be solved
an issue found by @mathieugimenez
Using a reference column to trigger a formula will only trigger if you change the referenced option (as the line/id will change) but won't trigger if you change the value displayed in the displayed column.
Ex: I have a trigger formula to generate an ID :
"PROJ" + $project.Name, with$projectbeing a reference column pointing to table "Projects". I set the formula to be triggered when$projectis modified or new line added.I choose a project on a line --> formula is triggered.
I now change the value of Name in the Projects table --> formula not triggered
Describe the solution you would like
Looks logical that it's triggered only when the referenced record changes, but would be great if the formula could be triggered when reference value displayed in the column changes.