Hi community,
I’m building a CRM where I have project data and financial data for projects in two separate tables. Reason for that is that I want only a subset of my users to have access to financial data.
The finances table has a project_id column, which refers to a project’s row ID.
What I’m trying to achieve is that whenever I add a new project, I want to automatically make a new entry in my finances table, containing the row ID of the newly created project.
Is there a way to do that automatically?