Connect a Google Form to Awesome Table

Follow

Comments

25 comments

  • Avatar
    Renold Lim

    Hello, i just tried this code and this wont work.

    i just wonder if its caused by the link provided from google is a bit different

     

    var formURL = 'https://docs.google.com/forms/d/yourId/viewform';

    which on google form
    var formURL = 'https://docs.google.com/forms/d/e/yourId/viewform';
  • Avatar
    Awesome Table

    Hello Renold,

    Your links must be the same. You have to use the same link as your Google form.

    Thank you.
    Thomas

  • Avatar
    Jorge Andrés Vélez Jaramillo

    Gracias por el artículo, fué de mucha ayuda

  • Avatar
    Tassia (Edited )

     

    Renold Lim, I had the same problem. Fixed by just copying the formID and not the entire URL.

  • Avatar
    Eallen (Edited )

    Having trouble getting the "edit entry" buttons, I have the links and I believe everything in the script is correct.  But when I open the spreadsheet in awesome tables, it does not appear as buttons, it shows the links

  • Avatar
    Awesome Table

    Hi Eallen,

    Would it be possible for you to share us your Awesome Table view and your spreadsheet at "[email protected]"? You can make a copy with similar data if it's necessary.

    Thank you.

    Thomas

  • Avatar
    Memon Samachar

    I am having trouble with the script as well. Since most of my data already exists in the sheet (I copied it in rather than fill in through forms, there are about 400 rows) when I run the script it either doesn't produce the URL for editing or produces the same as the one original data entry I did through the form. Is there a way to fix this?

  • Avatar
    Awesome Table

    Hi Memon Samachar,

    Could you send us your Awesome Table view, your spreadsheet and your Google Form, please? Make sure you give us access to your data. If you have sensitive data, you can make a copy with similar data.

    Thank you in advance.

    Thomas 

  • Avatar
    Wcpang

    Thank you for this awesome add-on

    I do have two questions.
    1. When I tried to run the script, I received this warning: Cannot find method getResponses(string). (line 12, file "Code")

    2. I wonder if it is possible to update a few columns at a time through the same GoogleForm

    Thank you.:)

  • Avatar
    Will (Edited )

    This looks fantastic but I haven't been able to get it to work. I'm using the example files and when I go to run my script I get an error:

    TypeError: Cannot call method "getDataRange" of null. (line 7, file "Code")

    How can I fix this please?

     

    Edit** 

    Never mind, I figured out that the sheetName needs to equal the name of the tab in the Google Sheet, not the name of the Google Sheet itself. Probably obvious to most, I'm learning.

  • Avatar
    Will

    I've got the script working so that it will generate a URL when I submit a new form. But I want to be able to populate the form manually from Google Sheets (by pasting data in from Excel) and generate URLs for potentially hundreds of rows at a time.

    How can I do this please?

  • Avatar
    Awesome Table

    Hi Wcpang,

    Would it be possible for you to share your view and your google form at "[email protected]"?
    If you have sensitive data, you can make a copy with similar data.

    Concerning your second question, it is possible to update several columns at the same time.

    Regards,
    Thomas

  • Avatar
    Awesome Table

    Hi Will,

    Could you share your view and your google form at "[email protected]"?
    Make sure you give us access to your view. You can make a copy with similar data if you want.

    However it is not yet possible to fill the form manually from Google Sheets.

    Regards,
    Thomas

  • Avatar
    Brian Mead

    Hi.  I am getting the error: cannot find method getResponse(string) in the Script editor. Is this method defined in another file I should have?

  • Avatar
    José Poejo

    Having trouble getting the "edit entry" buttons, I have the links and I believe everything in the script is correct.  But when I open the spreadsheet in awesome tables, it does not appear as buttons, it shows the links

    BR
     

  • Avatar
    Awesome Table

    Hi Brian,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "[email protected]"?
    If you have sensitive data, you can make a copy with similar data. Just make sure to give us access to your data.

    Thanks in advance.

    Thomas

  • Avatar
    Awesome Table

    Hi José,

    If you want to turn your link into a button, you can use the keyword ButtonType. The button edit doesn't set up automatically. You need to use ButtonType

    Kind regards,
    Thomas

  • Avatar
    Sfaulkner

    Hey,

    This is great.  However, I have one form, whereby someone scans a QR code with a pre-filled URL.  There are different pre-filled URLS for different data attached to the QR code.  How would I be able to update a particular record, if each pre-filled URL leads to a different form with some data already added? Also, is it possible to make it so that only certain pieces of information can be edited.  It would be really frustrating after creating pre-filled forms, that someone can go back and update the wrong field, thus causing an error elsewhere.

    Regards,

    Simon

  • Avatar
    Awesome Table

    Hi Sfaulkner,

    Unfortunately, it's a native behavior of Google Form and this issue is independent and not relative to Awesome Table.

    Kind regards,
    Thomas

  • Avatar
    Luca Riazzi

    Let me say it's really a awesome piece of software!

    I just find a problem in the script. I have more or less 3000 rows, and when I run the script it just stop after compiling some hundreds rows, saying the script took too much time and stops working. how can i deal with it?

  • Avatar
    Awesome Table

    Hi Luca Riazzi,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "[email protected]"?
    If you have sensitive data, you can make a copy with similar data. Just make sure to give us access to your data.

    Thanks in advance.

    Thomas

  • Avatar
    Peter Little

    Hi 

    I am having a problem getting the script to run - I have tried building the form a couple of times and keep getting this error.

    No item with the given ID could be found, or you do not have permission to access it. (line 8, file "Code")
    I am probably missing something obvious!
     
    Any help welcome 
     
    Peter
     
     
     
     
     
     
     
     
     
     
  • Avatar
    Awesome Table

    Hi Peter Little,

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "[email protected]"?
    If you have sensitive data, you can make a copy with similar data. Just make sure to give us access to your data.

    Thanks in advance.

    Thomas

  • Avatar
    Admin Support

    Bonjour Thomas

    Super produit.

    Même petit souci que plusieurs utilisateurs : le bouton d'édition n'apparaît pas dans les cellules du tableur (les liens URL vers le formulaire sont corrects)

    Souhaitez-vous l'URL à [email protected] également ? Ou le script à modifier ?

    Merci d'avance pour votre retour

    Cordialement

    FL

     

     

  • Avatar
    Awesome Table

    Bonjour Admin Support,

    Effectivement, nous aurions besoin d'avoir votre vue Awesome Table et la spreadsheet correspondante ainsi que le GForm. Assurez vous juste de nous donner accès à la spreadsheet. 

    Si vous avez des donnée sensibles, vous pouvez faire une copie avec des données similaires.

    Merci d'avance.

    Thomas