ResolveSG

What is ResolveSG?

Track and resolve cases in a few days.

What motivated you to build this product?

Currently, many workflows are still based on email. For instance, a citizen might submit an application form for a grant and this grant is processed by various public officers over email and approvals are also given over email.

This is highly inefficient as application progress cannot be easily tracked, resulting in agencies struggling to meet SLAs and citizens getting delayed application results.

What tech stack did you use?

For the frontend, we used React and NextJs. While for the backend, we used NestJs and Prisma.

What were the key challenges you faced in building ResolveSG?

One key decision was to codify a simplified version of the approvals structure instead of replicating it in its entirety. For instance, currently for the vast majority of workflows, a staff officer would approve the case followed by a director or equivalent. However, ResolveSG does not recognise the different roles that are required to approve a case, but instead just ensures that X number of officers have approved the case. This simplification gives greater flexibility and allows ResolveSG to cater to varying workflows and their approval structures. On the engineering side, we also have no need to deal with user roles and how they might differ across workflows.

What is the product vision for ResolveSG?

The product is a ticket resolution system much like Zendesk, mixed in with simplified approval workflows much like Github. Most email workflows can benefit from ResolveSG, and possibly several chunky case management tools as well, which are expensive to maintain, slow to load and with poor user experience.

For now we’re working with ESG for StartupSG grant applications, who are asking their MD for headcount to continue supporting our project. HDB Noise complaints team is keen too. NeMSW, a case management system for medical social workers can potentially use ResolveSG as well.

Fun facts!

One interesting finding:
Our hypothesis is while work is diverse, workflow is generic across use cases, and includes a) verified user identity, b) background of user, c), concern, d) internal communication, e) external communication and f) approvals.

One thing you'd have done differently:
Test against another agency early on apart from just ESG to substantiate our hypothesis.

Takeaway/learnings:
Most of us on the team were familiar with using sequelize or typeform as an ORM for interaction with our database. For this hackathon project, we gave Prisma a try and though Prisma did have lackings such as not supporting typing of json columns, overall we found the typing in prisma to be far superior to previous ORMs that we used. You can read more here.

We also opted to compute and store the status of a case instead of computing it on the fly, as previous experiences on projects such as Vault have shown that pre-computing, though it presents the risk of denormalized data going out of sync, helps ensure that fetching case information is quick and straightforward process. We used a handy library called XState to manage this.