Is there a way for dynamic cascading lookup fields in Google Tables (Area120)

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.

Google_table.PNG

 

 

0 1 178
1 REPLY 1

Sounds like AppSheet with AppSheet Databases may be the solution for you.

Top Labels in this Space