Once you fill out Add Professional or Write a Review form, that response goes to separate storage. I manually transfer and format them into the main list. I try to do this process at the end of the day everyday but sometimes it may take multiple days depending on how much time my life permits on that day :).
Value in that column shows total reviews that particular professional/business received in "Reviews" Google worksheet and Rating is an average of all ratings combined from all those reviews.
These are the professionals that has lower than "Satisfied (3)" ratings. It suggests you are likely to not have good experience based on what other residents went through. I am showing them in red color so that you don't miss that obvious risk.
Reviews are listed in the second worksheet named "Reviews" in the same Google workbook that has "Professionals" listing. You can also go to reviews by clicking on either "Reviews & Ratings (5 stars)" column or "Click To Open Reviews" cell next to it.
You can certainly add your own business and I encourage you to do so. After all, this platform is For Us By Us. But please don't add reviews for it. That won't be fair. If you want do promotions or something, you can write that in "Additional Details" section of the form or reach out to me via this form and we will work something out. But DO NOT try to game the system. If I notice fake reviews, I will unlist your entry.
Our toughest problem right now is to find trustworthy professionals like home contractors, cooks, cleaners, baby sitters, dog walkers, tutors, car mechanics etc. So, that is our primary focus but you can add anything that you feel can be helpful to multiple residents in day to day basis. Use your best judgement here. e.g. things like your favorite blog, books or travel destination etc. does not belong here :)
We want to keep this limited to HC residents so that we can control the quality of content. Also, I do not have a way to control access around adding professionals and reviews. So for now, if you want to help someone find professional, just find yourself in the list and share their details instead of the website.
Professionals and their reviews currently are listing in Google Sheets. Offers and Discounts are written in Google Docs. These two documents are best views in native Google Sheets and Google Docs mobile app. They offer mobile friendly zoomed out interface. Otherwise, you may have difficulty reading and zooming in other interfaces.