How To Place A Amount? one By one

AppSheet AppSheet Q&A
1

BHUVANESH_1-1657794207647.png

My Total Amount given To Buyer is 4000

1row-- Amount[we have given to 3682 $..so (given to 3682,balance 318$)

2row— Amount[we have given to 0 $..so (given to 0,balance 318$),

3row–Amount[we have given to 1057 $..so (given to 318 only(because Available balance is 318),

3roww Amount Column 318 Show…how To Show 318 In Amount Column?

how To Show 318 In Amount Column(3row amount column)?

2

You can study an App like this and adapt - https://www.appsheet.com/templates/Autocreated-from-Google-Sheets?appGuidString=de7161ae-4b66-49fc-a7ea-2a37c8234d7b

You can swap/re-read some items in the demo with your items such as

  • product = Buyer
  • initial stock = My Total Amount given To Buyer
  • Sell Quantity = Amount in your table

Basically

[current balance of a buyer] = [initial value of a buyer] - SUM(SELECT(all the quantities related to a particular buyer))

4 Likes
3
  1. Your table should allow for adds but not edits.
  2. Add a buyerBalance column, with the following App formula:
    4000 - [Amount] - SUM(
    SELECT(table[Amount], AND(
    [buyerID] = [_ThisRow].[buyerID],
    NOT([keyColumn] = [_ThisRow])
    ))
    )
  3. Put this expression in the Valid if field of the Amount column:
    [buyerBalance] >= 0
3 Likes