This leads to mistakes in teams selecting the wrong project and submitting hours to the wrong records. At the moment, the teams can select their name / team from the list to submit hours for, but when they choose a project to submit against, they see all the projects that are active instead of just theirs. How was this validated? We send a form weekly to our contractor teams that do work for our agency to submit their hours worked per project so we can calculate project costs, margin.etc. Solves our problem of not being able to have a curated and limited selection list of projects for each team. How does is solve the user problems? Opens up additional use cases for form flexibility. Then Q2 is to select a project to submit the form against, but ONLY show linked project records that are assigned to the contractor team in Q1 so that the team selected can only see and select their projects, not other teams projects as to only serve a limited list and ensure our teams don't make a mistake in project selection. For example, Q1 is to select a contractor or team from our list of contractors (linked record from a resources base). What is the proposed idea/solution? When creating a form view, it would be great to set a question's available linked records to be filtered based on a previous questions answer.
