Add to total from check box selection

[Alderson]

Hi 

I am new to Caspio and am setting up a producing pricing app. I am struggling to add options to the total price by selecting a radio button and to add a quantity field that multiplies the total. I am using a data report .

Thanks for any help you can give me.

[Tubby]

I am not sure what you mean by "data report". If you are using tabular report and is editing using inline insert, there is no way to add radio buttons( as far as I know).

If you are using a Submission form or a Details page, you can change its Form Element to radio button and add your values there. For the Total, just make the Form Element as Calculated Value then multiple the fields:
Sample:




But if you are on tabular, the only way is to add a details page to the records and do the same, or you can use dropdowns instead of radio button and do the computation on the table. Change the field for total to a Formula type and use the same formula above.

[Alderson]

Thanks that’s really helpful I will try it out. 
The screen shots really help

[cheonsa]

Hello!

For more details about formula, here's the link to Caspio's function reference: https://howto.caspio.com/function-reference/

 

[Queso]

Hi,

Just to add on Tubby's suggestion, you can visit this link for more information about Calculated Values: https://howto.caspio.com/datapages/datapage-components/calculated-values/