Question:
How can I create new values in a Formula dynamically?
Solution:
Once your Formula has already been created and configured, you can create a button on screen and write the following script in its Click() event:
Application.GetObject(“Formula1”).CreateValue Recipe1
Application.GetObject(“Formula1”).SaveFormulaValues “Unidade1”, Recipe1
These rows will create a new value called Recipe1, in Formula1, and save the values from their corresponding units on Value columns generated by Formula1.
