Showing negative transfer ammount in sender transfer table

Hi there!
Trying to solve this for some time with no luck:(
Any advice?

There are two tables:

accounts_table:
acc_key

transfers_table:
transfer_key
sender ref_accounts_table
receiver ref_accounts_table
ammount

Also there is UX View account_detail which contains inline table with account transfers.

How to make it show negative ammounts of transfers where account currently viewing is sender?

Currently I’m creating a mirror transfer in database swaping sender/receiver and multiplying ammount by -1. Is there a way to make it inside of AppSheet?

I believe if you share more details and if possible screenshots of your requirement, the community could help you better.

1 Like