Documenting workflows and ERDs

Hi everyone. My app is growing in complexity and I’m pleased with what it is now capable of, but…. I’m finding it incredibly difficult to consider new workflows or changes to existing workflows when I introduce a new feature.

Are there any tried and tested ways of documenting the entity relationships and all the front end and back end workflows to make it easier to visualise?

I’ve tried using Visio to generate flow charts, I’ve used excel to list out each action and what it triggers next. I’ve also exported my data types to excel and imported into power bi to build an entity relationship diagram. Figma was another failed attempt (but that’s probably just my approach).

I find I’m having to trace workflows through from front end actions and travel back and forth between the backend and front end workflows navigating a sea of actions triggers and conditions.

I’m still struggling to find a good way of document what is controlling what.

I’m curious to know how the community addresses this challenge with large databases and complex workflows.

Any pointers, tips, tools, templates or apps would be greatly appreciated to share with the community.

Chris