I have two external CSVs - one is a list of projects, another is a list of project stages that are linked against these projects, i.e. manufacture, installation, etc. I've created a grid in AppSheet with these projects on, and want to be able to click on one of the projects and bring up a view that has all of the project stages against that project. I then need to be able to edit, add or remove these stages.
To do this, I need to be able to pull through all the stages that match the project ID that I'm on, but I have no idea how to do that - I know I can slice a database, and only show stages that match a project ID, but how do I do that dynamically every time I load a new project? Is it possible to set this up with a bot, for example?
I've had a hunt through all the relevant documentation I can find, but I can't seem to find anything that addresses this point - any pointers would be much appreciated!
LinkedIn
Twitter
