I'm posting on behalf of a fellow who manages a 35 member woodworker group in Canada. He has a problem with managing access to the workshop and I thought there might be some useful feedback from the forum.
They have a woodworking shop that has a keycode entry. Currently due to Covid they are limiting access to one member at a time so he started a Google Sheets booking form. But some members are not using the sign up form and will go to the shop hoping no one is there (which is ok). But when a member who has booked goes and finds someone there then it is upsetting. He thinks that reasons for avoidance of the booking form might include lack of computer skills &/and too proud attitude to ask. He has offered training to members.
We met on StackExchange where I was providing volunteer/free support for Google Sheets. We've made some changes to the spreadsheet but I think the spreadsheet might be a red-herring in terms of a solution.
But, whichever way you look at it, he has a problem on his hands. Any feedback from forum members would be appreciated.