I have a “project” table, a “requirements” table and an “issue” table.
Projects - Requirements - Issues
A project is pretty simple with some simple attributes.
The requirements table consists of the name of the requirement and a look up to the project it belongs to. ( a project can have 0-many requirements, requirements can have 1 and only one project.
The issue table contains issues such as stories or tasks that I wish to possibly belong to a project and then to possibly a requirement of that project. I have a lookup field in the issue row that is connected to the projects table, and I would like to have a requirements lookup field but I would like it to filter down to what is selected in the project lookup field. Is this possible? I have been trying relationship filtering but can not figure it out.
Sounds like AppSheet with AppSheet Databases may be the solution for you.
User | Count |
---|---|
4 | |
2 | |
1 | |
1 | |
1 |