[SOLVED] Mathematical Calculation Fields

krileon wrote:
[cb:if cb_query>="30"]You appear to be over weight![/cb:if]

Thank you so much for the help! Just one more question. What if there are more then 1 conditions? How do I include them? For example:

if cb_gender="mail" and if cb_query>="30"

Thank you so much for the help! Just one more question. What if there are more then 1 conditions? How do I include them? For example:

You can use "and" or "or" to add more conditions if needed. Examples as follows.

[cb:if cb_gender="male" and cb_query>="30"]You appear to be over weight![/cb:if]

[cb:if cb_query>="30" or cb_query>="50"]You appear to be over weight![/cb:if]

Thanks!

One question, how do i run the query and store the value of the result to a CB field? For example store to cb_permanentBMI

CB Query Fields don't store anywhere. They query the database and display the results of said query. If you want to store it to a field you can use CB Auto Actions with a field action or a query action.

krileon wrote: CB Query Fields don't store anywhere. They query the database and display the results of said query. If you want to store it to a field you can use CB Auto Actions with a field action or a query action.

I have tried using the Auto Action to get the BMI query field which has the following:

But somehow it is not populating the field. I am using auto action to copy the query field above and copy it to cb_bmi.