Hi, I'm working on a way to consolidate a base used for a diaper program. We're a nonprofit and need to track for many different reasons, but our current process is long and requires toggling from table to form to table. Here's what we're doing (all are in separate tables):
- Entering donation inventory via form (an individual count of diapers, wipes and formula)
- Receiving requests via form
- Reviewing the requests and inventorying out the items via form (linked to step 1)
Here's what I'd like to do:
- Inventory donations via form (needed because amount spent is required for tax purposes)
- Link the request and inventory out form to subtract from inventoried donations
- Is it possible to deduct (2) items at once or do we have to inventory out each item to properly subtract?
Essentially, all three tables would be linked together with the inventory out and request forms "combined" to avoid exiting the table when fulfilling the requests for delivery or pick-up.
Is this possible? I feel like it is, but I'm not sure how it would look.
Any help or general insight would be great!
