Thank you for attaching the image. Regarding the formula, in this case, it’s only showing one product pricing. In order to show the total price of a group of products in one collection, please follow these steps:
- Add a collection in the database called (My_cart orders)
- Add a relationship (One to Many) between the (My_cart) and (My_cart orders).
- Add a property in the (My_cart orders) collection, and call it “Total price”.
- Go to your (Add to cart) button, and add an action to create a (My_cart order) record, then add the following formula into the new (Total price) property: (Current product price x Quantity).
- Finally, we’ll go to the initial label of your formula, and please add the following calculations: (Logged in user => My_cart => My_cart orders => Total price => Sum).
Please let me know if you have any questions.
Thank you!