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 BLACKQuestion 2: Select the new location: Apartment 200Thanks for your help
Is it possible to show dynamic informations in a google form based on a previous response?
google spreadsheets;google apps script;google forms
Short answerNo, it's not possible.ExplanationAt this time Google Apps Script doesn't include a way to modify a form when a user open it to respond. An alternative is to use Google Apps Script to create a web app.Referenceshttps://developers.google.com/apps-script/reference/forms/https://developers.google.com/apps-script/guides/triggers/https://developers.google.com/apps-script/guides/web