Apologies for cross-posting on two forums and for the vague subject title but curious if any of you know of a relatively simple way to do the following:
I help organize a group where we try and get local people to donate to a pool of money and that pool of money gets donated as a lump sum to a charity. We hold these meetings quarterly throughout the year. Some people pay each meeting, some pay for all 4 meetings at once, some come and go as their finances allow.
We’ve had requests to post a list of who has paid for that quarter and who hasn’t but we can’t do that for reasons of privacy/comfort. What I’d like to do is have a search box where someone could type their name in and see if they’re paid up for that quarter or not.
Some extra detail if it helps: we currently accept payments by e-transfer or by Stripe payments on our website. We manage a google spreadsheet of the people who are registered and who are paid.
(Edit: as an example, something like this site where you can input your name and see if you’ve won. Mine would be to input your name and see if you’ve paid.