Programatically changing a field formula?

Panorama X Beta 10.2
#1

Is it possible programmatically to change a Field’s formula?

I have a procedure to add a field to a database, and I would like that new field to be added to the formula in an existing field. If the answer is yes, I will be utterly amazed and happy.

#2

You can do it using the setfieldproperties statement. Here is what I used to set the formula of a test field named A to '//OK"


setfieldproperties "A",initializedictionary(
    "FORMULA","//OK")
#3

Thanks. Just what I was hoping would be available.

#4

So now you are “utterly amazed and happy” right? :heart_eyes:

FYI, a good way to find out how to do things like this is to look at the blueprint. In fact, you could use Show Field Blueprint, copy out the entire blueprint, then delete all of the stuff you don’t need, in this case leaving you with just the code for setting the formula.

#5

Yes, I am. It happens frequently when I learn something new with PanX.

1 Like