Sep 29, 2023
I am stuck at automation and would highly appreciate help with the issue.
I have the tables:
Projects (linked to operations),
Operations (linked to projects, stakeholders, products, accounts),
What I am trying to do:
If you create a project, I want to create several rows in Operations table (with template) - one for revenue, several for fixed costs.
But I want to input the Stakeholder and preferably product, when adding a new project.
1. Add project (project name, stakeholder)
2. Template created one row for Revenue and several rows for fixed costs in Operations. What I want is to fill in the same stakeholder for Revenue entry in , which was chosen in Project entry.