I run a couple service businesses in Iowa. One of which (Mr. ProActive) I’m planning to pivot into a software company since it’s been harder than ever to convince people to have me inside their home every month (something about a pandemic). I’m taking my home maintenance checklist I use at my clients’ homes and turning it into a game for people to tackle the maintenance themselves. The hope is to make proactive maintenance FUN and REWARDING so people actually do it as faithfully as they should. Originally I had the custom checklists built out in google sheets with formulas set up to calculate various scores and dock the user risk points for a variety of monthly missions. My test group liked the concept but hated using a spreadsheet as a game platform (obviously). My second attempt was to use a survey builder (survey legend) to house the mission (more user friendly) which exported the results to a spreadsheet so the scoring could be conducted. This was less than ideal since I had to use multiple platforms for various aspects of the game (the dashboard was on a spreadsheet, the missions were all linked out to the survey platform). This brings me to glide. I’m pretty accustomed to google sheets and have someone on my team who can work magic with formulas so it seems like a good fit.
I’m a few hours into my project and have a nice per user dashboard set up. Currently having trouble wrapping my mind around how set up custom missions for users. Seems I need glide to create new rows with the task results on the spreadsheet somewhere so I can program it to calculate a score and update the users dashboard. Tinkering with a special tab for missions but not sure if I should create multiple forms within each mission for bite sized tasks or to use checklists, buttons, etc.