ADAPrep Softr App Restoration & Workflow Repair

The problem

Alaska Driving Academy needed help restoring its existing Softr-based educational application after its previous development company was acquired by another agency. The app had worked reliably for years, but several critical workflows stopped functioning correctly after the transition. New users could create accounts but were no longer automatically assigned to the DEFAULT user group, leaving them with access to a blank page. The in-app User Management feature also produced a “Column C title is empty” error, while Google Drive and Google Sheets resources remained connected to the previous developer’s setup. The Bulletin Board continued to allow administrators to post messages, but students could no longer respond as they had previously. The proposed engagement focused on diagnosing and repairing the existing Softr application rather than rebuilding it or migrating to another platform, while reconnecting the underlying Google resources to the client’s own accounts and preserving existing student content, enrollment workflows, PDFs, videos, and application functionality.

What we built

Alaska Driving Academy uses ADAPrep.app as an educational portal for prospective and enrolled students. Prospective clients use the application to learn about the school, submit enrollment information, and create accounts, while enrolled students use it to access educational tools, PDF training materials, videos, and school communications. After the company's original developer was acquired by another agency, several important workflows stopped functioning correctly. New accounts were no longer automatically assigned to the DEFAULT group, resulting in students seeing a blank page with no access to the application. The administrator-facing User Management feature also stopped working and displayed a “Column C title is empty” error. In addition, the school's Google Sheets and Google Drive resources needed to be disconnected from the previous developer's environment and linked to the school's own Google account. The Bulletin Board continued to allow administrators to publish messages, but student replies no longer worked. The project centered on auditing the existing Softr configuration and its Google integrations, identifying the broken connections and workflow logic, restoring automatic user-group assignment and management functionality, repairing the Bulletin Board interaction, and transitioning ownership of relevant Google resources to the client. The objective was to preserve the existing application and its long-standing functionality while giving Alaska Driving Academy greater control over its technology stack.

• Automatic DEFAULT user-group assignment restored, so new accounts land in the app instead of a blank page.
• User Management repaired, clearing the "Column C title is empty" error for administrators.
• Bulletin Board replies restored, so students can respond to school messages again.
• Google Sheets and Google Drive resources reconnected to the school's own account.
• Existing student content, enrollment workflows, PDFs and videos preserved through the repair.
• Audit of the Softr configuration and its integrations, documenting what the previous agency left behind.

How we built it

This was a diagnosis, not a rebuild. The application had run reliably for years, so the brief was to find the specific connections that broke when the original developer's agency was acquired, rather than migrate the school onto something new.

CustomJS covers the workflow logic behind user-group assignment and the Bulletin Board interaction. The Google Sheets and Google Drive connections were re-pointed from the previous developer's environment to accounts Alaska Driving Academy owns outright.