How to - Review Input and Pull data Google Sheets? | Community
Skip to main content
Answered

How to - Review Input and Pull data Google Sheets?

  • January 13, 2022
  • 2 replies
  • 118 views
C

I have a logic flow in place, that is connected to a Google Sheet. The Google Sheet is collecting the data, but I want to add 2 things. See below.

These first 5 steps are done and working well:

  1. Welcome
  2. Legal Disclaimer
  3. Input 1 *optional
  4. Input 2 *Mandatory
  5. Input 3 * Manditory

Now for the hard parts:

  1. Review Inputs from above - multiple choice - Go Back / Submit  *Mandatory
  2. Feedback page - Here is your transaction ID - pulled from Google Sheets

Ending:
Thank you - this is good too.

Questions:

  1. Can I grab the input in steps #3-#5 and only submit in Step #6 after the user reviews? If so, how? If not, can I pull from the Google Spreadsheet to display, and if the user chooses Go Back, over write the existing data?
     
  2. How do I pull information from the Google Spreadsheet so I can show a transaction id?

Best answer by Liz

Hi @calshamus Welcome to the community! Happy to have you here. 

Once a response is submitted, it isn’t possible for the respondent to edit it. We have a workaround for this here, but at the end of the form (such as in a statement block), you could use our recall variables feature to show the respondent their answers and then allow them to move backwards to change them. 

As for pulling data from an outside source, I’m afraid this isn’t possible, as the form can’t connect to an outside database. I would suggest putting as much information into the form itself as you can. 

View original

    2 replies

    Liz
    Community Team
    Forum|alt.badge.img+5
    • Liz
    • Tech Community Advocate
    • 15018 replies
    • Answer
    • January 14, 2022

    Hi @calshamus Welcome to the community! Happy to have you here. 

    Once a response is submitted, it isn’t possible for the respondent to edit it. We have a workaround for this here, but at the end of the form (such as in a statement block), you could use our recall variables feature to show the respondent their answers and then allow them to move backwards to change them. 

    As for pulling data from an outside source, I’m afraid this isn’t possible, as the form can’t connect to an outside database. I would suggest putting as much information into the form itself as you can. 

    Life is a series of awkward moments separated by snacks.
    john.desborough
    Gabi Amaral
    2 people like this
    • john.desborough
      john.desborough
    • Gabi Amaral
      Gabi Amaral
    Gabi Amaral
    Ex–Typefomer
    Forum|alt.badge.img+5
    • Gabi Amaral
    • Ex–Typefomer
    • 1777 replies
    • January 25, 2022

    Hi @calshamus! Were you able to give a try to the workaround Liz suggested? Let us know if you did and if it helped you! Hoping it did! :heart_eyes:

    Everyone you meet is fighting a battle you know nothing about. Be kind. Always. =)

    Reply


    Still need help?

    Don't be shy and ask the community.

    Ask your question here!
    Community T&Cs