Just a couple of Questions not sure if what i'm trying to do can be done.
I have a Dataobject and a list of fields for the CMS a number of the fields contain a number for weight i need to have each of these fields query another table for a price and then calculate the weight*price and hold the answer for further calculations.
This is a small part of a rather long and complex formula that needs to return several parts.
my main question at the moment is can i add a query to the addfieldtotab in the getCMSFields function or will i have to write a seperate function for each field and then call it, or am i better making this portion of the dataobject a seperate data object and writing a single function to do this?
Although the last option may add complications to the rest of the formula.