Connect a Google Form to Awesome Table

Follow

Comments

8 comments

  • Avatar
    Ckc Nitt

    Does not work. And if I copy the template and try to use it I constantly get 

    "You should to click on the Trigger menu to complete setup"

  • Avatar
    Awesome Table

    Hello,

    Please send me a mail at support@awesome-table.com with a screenshot of the error that you are getting and a link to your spreadsheet. I would be glad to help you find the source of your issue.

    Thank you,

    Nicolas

  • Avatar
    Andrea Ardovini

    Hello everybody,

    I'm using this method a lot and worked beautifully, but I have (or tell my collaborators) to refresh the website everytime there is a new entry to see the changes.

    Is there a way to refresh awesome table everytime someone post or edit the form?

     

    Thanks,

    Andrea

  • Avatar
    Awesome Table (Edited )

    Hello Andrea,

    Unfortunately this is not possible.

    It is technically not possible for us to get informations from your spreadsheet in real time.

     

    Thank you,

    Nicolas

  • Avatar
    Imre Szabo-Dobozy

    This works very well but the instructions could be clearer. The URL needed for the script to run properly should be in this format: 'https://docs.google.com/forms/d/...YOUR FORM ID HERE.../viewform'

    The form ID you should use is the one located in the URL when you are editing your form. Not the one generated when you get the shareable link. 

    It should have this format: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx_xxxxx

    You also need to turn on your forms 'Edit after submit' function which can be done by clicking the little 'cog' icon when editing your form at the top right hand corner to open the settings. Then check the box that says "Edit after submit" and then save. 

    After these steps your script should now work.

  • Avatar
    Awesome Table

    Hi Imre,

    Thank you for your feedback, this is indeed an old article that is filled with mistakes.

    We will make sure to update it!

    Thank you,

    Nicolas

  • Avatar
    E- Pédagogie (Edited )

    Hi,

     

    How have you created the button "ADD ROW" that goes to the form url?

     

     

    There's no HTML & CSS for this widget in your template, Am I right?

     

    How can I create this button in your gsheets template or on my Google Sites?

     

     

    Best regards,

    Paul

  • Avatar
    Awesome Table

    Hello Paul,

    Using templates you can easily add html to the top of your view. Please find this article that should help you achieve this: https://support.awesome-table.com/hc/en-us/articles/115001118689

     

    Nicolas

Please sign in to leave a comment.