Where can I find tutorials and examples on how to use Sql pack (use as field).
My question is:
I have a Content Type Form with
1) field select dynamic: to select value from a table 'Products' ( id, name, price)
2) field text: quantity to sell
3) field Sql Query (contains total) = product price * quantity. But first I must recover the price of the product (selected in field select dynamci), and then multiply it with the quantity: how can I do this?
thanks.