Does anyone know if it is possible to manually override a formula / mathematical field? I have many instances of wanting the formula to be the "default" value, but would often like to override its value. Thanks.
Please check the example file. You can choose between 4 options:
1. Math formula static - you can not change the field value.
2. Math formula dynamic - you can change the field value, but if you do so, and then will change the source fields value - result will not be updated. In other words, once you change it manually - it will never be updated if you change Nr1 or Nr2 fields. Also, as per BDB manual, this option increases DB size as it stores separate formula for each record.
3. Simple Numeric field - calculation is redone every time you change filed Nr1 or Nr2 values. You can also change the filed value manually. Even if you change field's value manually - it will be updated once you change fields Nr1 and Nr2.
4. Same as above. Additionally, you can enter formula manually. Select the field and press "Enter" for pop-up window to show up.