[SOLVED] Add several fields value to another one

Hello
I am currently creating a register form for a non benefit meeting ; I would like to let people preorder meals. I created radio buttons fields like
cb_meal1 : yes (value = 15) no (value = 0)
cb_meal2 : yes (value = 15) no (value = 0)
and so on.

I created also a cb_total_amount field, which I try to fullfil with the summ of checked meals. I tried to do it in several ways :

1/ Using the AutoAction "FIELD" : but the cb_mealN fields values are considerated as text, not numbers, so the calculation [cb_meal1]+[cb_meal2] gives logically "15 + 0" as an output
2/ Using the AutoAction "CODE" / php : but I am not sure on how to do (php code + value settings and so on)

Any idea ? I am sure that someone already made that kind of things !

Thanx by advance !
Best regards,
Antoine

Do you need the values stored in the database so they can be searched? If not you could just use a Code field then add them together using PHP for display purposes. Example as follows.


If you need them stored then ensure cb_total_amount is an integer field and use the Field action in CB Auto Actions acting on the onAfterUserRegistration, onAfterNewUser, onAfterUpdateUser, and onAfterUserUpdate triggers. Next you'll need to toggle on Format Functions under Parameters. Then the following should work.

Field: cb_total_amount
Operator: Set
Value: [cb:parse function="math"][cb_meal1] + [cb_meal2][/cb:parse]

The math format function allows you to use math operators to add, subtract, multiply, and divide.

krileon wrote: If you need them stored then ensure cb_total_amount is an integer field and use the Field action in CB Auto Actions acting on the onAfterUserRegistration, onAfterNewUser, onAfterUpdateUser, and onAfterUserUpdate triggers. Next you'll need to toggle on Format Functions under Parameters. Then the following should work.
Field: cb_total_amount
Operator: Set
Value: [cb:parse function="math"][cb_meal1] + [cb_meal2][/cb:parse]
The math format function allows you to use math operators to add, subtract, multiply, and divide.

Dear Krileon,
Thanx a lot ! As usual, you got it directly.
I tried exactly as you said EXCEPT I toogled on Format under Conditions, NOT Parameters (I didn't get exactly the difference - yours extensions are that much powerfull that we can do everythin we can imagin but it is difficult sometimes to know what settings to consider because of documentation... BUT your support is always fast and efficient - briliant !)
Thanks againt
Best regards
Antoine