New to PanaromaX. Plan to use it analyze the deluge of data generated by my home energy management system. I want to import CVS files and append to a database(s) on a regular basis.
I have been watching, reading and learning to understand how I can accomplish what I want. As always there are many ways - just trying to figure out the most flexible approaches.
My problem is understanding how to use the field formula and field code.
I have an imported field that I want to evaluate to create the value in another field, i.e. if fielda >2 fieldb=“true” else fieldb=“false” etc. Since this requires code and not a formula I can’t do upon import (right?). So in field definition do I put the code in fielda or fieldb? Does it matter? If I put it in fielda then it execute when I edit fielda. If I put it in fieldb then I need a runfieldcode"fieldb" in the fielda field code. Is one way better than the other?
Seems like either way, fieldb is not populated upon import. How do I get the fieldb to be populated? The morph/recalcuate field works on field formulas but not on field code (right?).
I will have several new fields (not imported) that will have field formulas. Is there a way to morph/recalculate multiple fields at once. I think I understand procedures can do this but just want to make sure there isn’t another option. Haven’t tackled procedures yet.
Also I found this
"As an alternate to setting up code for specific fields, you can also set up a special procedure named .ModifyRecord that will be run whenever any field is modified. See Tracking Database Changes for more information."
But the link “Tracking Database Changes” take you to a embarrassing page referencing plans from 1996 Haven’t dug into .ModifyRecord yet. Thought maybe there was something simply I wasn’t yet understanding.
Thanks in advance for any assistance.