danrashba

[danrashba]

I am trying to create a submission form for customers to add products to an order and show them the total cost before they submit to my transactions table. I created a view to join the transaction table (where product is being selected) and the product table (where product price is held).  How do I give the customer an updated price within the submission form as they toggle between products BEFORE they hit submit on their order? I have been messing around with virtual fields but cant seem to get it. Do any Caspio video's cover this topic?

[Mathilda]

Hi Danrashba,

Do you need to store total value in the table? If yes, you may use the following solution: 

 

[NailDyanC]

Hi,

Just to add to the previous comment above, I think you can use calculated value in your submission form if you only want to display a calculation in your submission form. You can refer to this link: https://howto.caspio.com/datapages/datapage-components/calculated-values/

I hope it will help.

[ParkLoey]

Hi! Also wanted to add in @NailDyanC recommendation, this calculates real-time so if you want them to see the price of all the options they choose, this would be the best approach