Displaying and computing row values differently from underlying sheet

[thromer]

I have a simple AppSheet app that allows adding manual transactions to a personal finance spreadsheet populated by Tiller.

Most of the transactions have negative values in the Amount column, representing purchases.

Since the common case for new entries is that they are purchases, I’d like to be able to enter the amount as a positive value, with a checkbox “deposit”.

Any suggestions for how to go about this? I played around with virtual columns and with setting the formula for the real Amount column but didn’t get anywhere. A complicating factor is that both Tiller and the App Sheet app will be adding rows to the underlying sheet.

[Marc_Dillon]

Adding and removing inventory based on form input Questions

Hello, TDLR; I need help with forms and user input to help me add and remove inventory depending on there input I’m working on a inventory management app for the company i work for and I’ve hit a snag. How the app works currently is that there us a form that people fill out to add or remove inventory. Then after it logs the entry. In said form they had to select the item, date, and how much they are adding or removing. However, that last part is a bit weird, in order for a person to remove inv…