Price Calculation

[il_han]

Hello everyone, I have a Google spreadsheet as in the picture. I want to make a calculation table using Appsheet. When the user enters the "Order Quantity" amount, I want the entered amount to be multiplied by the "Unit Price" and the totals of the multiplications to be displayed at the bottom. I think the "Order Quantity" entry should be made with a virtual column. I tried using a table or form, but I could not add the "Order Quantity" entry section to the screen. How should I do this?

[WillowMobileSys]

---

@il_han wrote:

I think the "Order Quantity" entry should be made with a virtual column.

---

You mentioned "Invoice" in the title,...

Are you trying to make an Order Entry app or do you want users to simply be able to "check" total price of an item based on quantity entry?

[il_han]

Thank you for your response.

I want them to simply "check" the total price of an item or how many items they want to calculate based on the quantity input.

The screen will have product names below each other and a value input area next to them. After entering the quantities here, they need to click the calculate button and see the total price.

[il_han]

I want to achieve a result like in the picture.

[yasarcan]

Merhaba;

tabloya Amount ve Total sütunlarını ekle. (sanal değil) totalin hesaplama yapması için formülü gir. eğer etablo üzerinde veri olmadan anlık sorgu olarak görüp bunu pdf e çekmek istersen sadece totali sanal sütun olarak hazırla. kolay gelsin.