I have content with computation in an Admin form that has a field which
is variable changeable in an another admin form, when a user updates the variable
value it should change the results of the computation automatically to then
render the correct value without having to go into each record to run it to
then save the new calculated value.
So in a sense every time the Gold price field is updated it
needs to re-run the computation or formula below on each record that has the id
of the Gold rate to then update to give a new price.
1.Have a content type called products
2.Have a content type Gold Rates
Products Content Type has the following fields:
-Gold Rate Type (Select Dynamic Gold Rate CCK using Gold Price as Value in calculation but ID in Store Value)
-Value 1 (computation: Gold Rate * Weight)
-Value 2 (computation: Item markup * Value 1 /
I am not sure which way round or the best way to get the
result I need, should I be using a script that when the page loads on the
front-end it runs the above formula to always give a live price, or should it
be mass updated to then give a fixed static price in the DB column price?
The user will be able to update the Gold price in gold rates
for it to then render a new correct calculated price in the content view on the
front-end through products content type.
So if the user updated the Gold Rate Type 1, Gold Price field to 20, the new Price in Product content should be: £1,560 on the front-end without having to go into every product that has that gold rate to re-run the computation and save.
I was thinking about that but then went on to think it would be too much in the front-end wihtin all views etc be a lot of overload, so went on to see if I can generate a list of products based on the ID of the Gold Rate Type and then mass update in 1 go so the price is not dynamic in the front end, but i dont think you can do this with seblod.
How to update more than one record within a form of another content type admin form not by using the import and export tool tho!