I set up a form to specify the location of household appliances in a residence. The form is based on a unique code assigned to each household. (it's working properly)
To avoid entry errors, I would like once the unique code entered, the user can see the detail of the device before confirming the new location. The information is present in the associated google spreadsheet, is it possible via a google script to show it directly in the form page?
Example: Question 1: Select ID: E000025 -> Display: You're moving the SAMSUNG 32 "TV BLACK Question 2: Select the new location: Apartment 200
Thanks for your help