I refer to my earlier topic regarding creating three-way formulas in Panorama X.
I bought Panorama X a few days ago; it is excellent and a pleasure to use.
I am able to easily create two-way and three-way formulas without having to create dummy hidden fields in a financial forecasting app that I am developing in Panorama X and which I wish to eventually market.
Neither FileMaker, Access, Excel or Quantrix Modeler allow formula fields to be edited to over-write the formula in a field with a number to recalculate a independent field in the formula.
However, if I change the name of a field the respective formula which uses that field does not automatically update with the new field name. I have to manually change the name of the field in the formula. For example, if I change the name of field # 1in a database I then have to change the name of field # 1in the formula which is in another field. This is a duplication of the process. If I don’t change the name of field # 1 in the formula to match the new name of field # 1, the formula will not calculate.
Is there a way to automatically update the name of a field in a formula if the field name is changed in the database e.g. using code?