2

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 that, once the unique code is 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
3
  • 1
    No, this is not possible. Once a Google Form has been opened, there is no way to provide dynamic user feedback. You would need to design your own input form with HTML, CSS and JavaScript in an Apps Script Web App.
    – Alan Wells
    Commented Jul 29, 2016 at 16:25
  • Hi Sandy, ok bad news... it seems to be a bit complicated for me. Is there any example of code of a such Apps script Web App that I can find ?
    – ClemT
    Commented Aug 1, 2016 at 10:51
  • 1
    Here is an example: Apps Script File of Web App Here is another: Contact Form - Web App
    – Alan Wells
    Commented Aug 1, 2016 at 15:01

1 Answer 1

1

Short answer

No, it's not possible.

Explanation

At 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.

References

2
  • Hi Ruben, Thanks for your answer. Do you think I can do something with getIndex() and setHelpText(text) ? First to get the ID wich is selected and second to show details ?
    – ClemT
    Commented Aug 1, 2016 at 10:59
  • @ClemT: Bear in mind that GAS could get the responses values after the form response be submitted. Please consider to post a new question. Commented Aug 1, 2016 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.