Pre-populate select fields in a Form (sheet B) from an existing sheet (Sheet A)
Is it possible to prepopulate select data elements of a form from an existing sheet that contains the data. Example we have two sheets. Test Execution sheet (Sheet A) to manage and track testing and Defect Log (Sheet B) used to capture defects identified the Defect Log would have form associated with it.
Within the Test Execution sheet we want to have column "Log Defect" that when selected either check box or URL to the form would open for user to submit pertinent defect details for them to enter the details. We would like the form to pull in basic information from the Test Execution sheet such as Test Case ID and Test Name. The user would then fill in the details.
On submission the Defect Log would have the basic test information and the end user details they are reporting as a defect.