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
  • 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 Jul 29 '16 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 Aug 1 '16 at 10:51
  • 1
    Here is an example: Apps Script File of Web App Here is another: Contact Form - Web App – Alan Wells Aug 1 '16 at 15:01
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

  • 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 Aug 1 '16 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. – Rubén Aug 1 '16 at 12:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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