Set another field's value from calculation?
Is it possible to set another field's value (in the same table) from a calculation? I haven't been able to do it. The calculation would also set its own field's value.
If I have calculated field and I try to set another field with the calculation's result, nothing happens.
Can't find anything documented or examples.
What is your code?
Textfield := text(Formulafield)
Numberfield := number(Formulafield)
A trigger with a button is needed.
Yeah, formula fields can't modify other fields. They can only do functions to get data.
As Steven says, you either have to
- use a button
- put it in On Click for the formula field
- put it in Trigger after update at the Table level
All you need at this level is:
weight := calcwt
- 1 yr agoLast active