Good Evening Bubblers,
I’ve got an idea I’m hoping you can help with. I’d like to take a snapshot of progress, for a certain time period to compare with another time period.
- Committee Members (a thing) are assigned to Donors (a list of things)
- Individual Donors donate Items (a list of things)
- Individual Items have a monetary value (a field on the donate item)
I’d like to create a Progress Snapshot (a thing?) that shows, at time the snapshot was taken, the Committee Member had a count of x Donors assigned to them, who had donated a count of y number of things, that have a sum total of z amount of money donated.
Each Progress snapshot would look something like this, rolled up by Committee Members (shows in column F, as “Item Assignments”)
What workflow would you put behind a button to generate a progress snapshot like that?