I am kind of new to Honeycode and still finding my way through.
What I am trying to achieve is an order form. Everything seems to be working as expected, except that I'd like a calculation of the total price in the form, before submitting it.
There's the data:
The products are displayed on the page and each one has an "Order" button.
Pressing the "Order" button opens a form.
Date -> current date =TODAY()
IGN -> user filled field
ProductName -> inherited from the previous page =THISROW()[ProdName]
Qty -> user filled field where user inputs the quantity of the products ordered
TotalPrice -> I'd like this to calculate the above Qty * THISROW()[Price]
So far, I wasn't able to find a way to reference the Qty field and use it in the form. Any help would be much appreciated.