Allow users to update your app’s data with Google Forms

Follow

Comments

53 comments

  • Avatar
    Thomas Morin

    Hello @Sreekesh S K,

    I create a ticket because it will be easier to discuss with you.

    Kind regards.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Jesse Brewer

    Hello,

    I've gone through all the steps and have successfully been able to fill out my form and have my responses added to my google sheet. The only thing I don't quite understand is why an EDIT button is not created in my UPDATE column when a new response is added to my google sheet. I have to go in after the fact and type EDIT for the button to appear. 

    Is this related to the Trigger step? I've gone over that 3 times to make sure I didn't miss anything and I don't think I have. It's one of the easier steps to follow. 

    1
    Comment actions Permalink
  • Avatar
    Joseph Vaughan

    @Jesse Brewer


    I had the same question some time ago.   You could go in and add a line like this to the script (after the last line that sets the URL):

    sheet.getRange(i+1, columnIndex+1).setValue('Edit');

    That would add the word 'Edit' in the cell after the URL.  Of course, you'd need to change the word 'Edit' in the script if you wanted something else to show up.

     

     

    3
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Thanks for the assistance, @Joseph ! :) 

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Jesse Brewer

    @Joseph Vaughan


    Thank you Sooooooo much! Worked like a charm.

    0
    Comment actions Permalink
  • Avatar
    Angel Christian

    @Sreekesh S K did you manage to resolve this issue? I am facing a similar problem right now and would be interested to know how did you manage to sort this out please?

    0
    Comment actions Permalink
  • Avatar
    Campus Safety

    Having no luck after following all steps exactly. The script throws no errors but does not manipulate the sheet at all. Any idea were I should start debugging?

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hello @Campus Safety.

    Please share your:

    AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.

    Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.

    You can opt to anonymize your content by using dummy data (fake, but realistic) if your Sheets contain confidential info.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Drorlazar (Edited )

    I've done this before with previous tables and it worked great, now for some reason when I try to run the script on a new table i'm asked for permissions and when I choose my google account i'm getting:

    Sign in with Google temporarily disabled for this app

    This app has not been verified yet by Google in order to use Google Sign In.

    and there's not a button for further permit it to run, any ideas how to allow the script to run? 

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Thanks for reporting this issue, Drorlazar.
    I will endorse this case to our Support Team.
    Please check your email for updates regarding this case with Ticket #104598.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Nurarif Nurhashim

    Hi, I followed the steps correctly until the Run function step, it didn't auto generate the links. How do I fix this?

    Thank you ,
    Nurarif

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi Nurarif Nurhashim.

    I recommend following the cool solution shared by Joseph Vaughan to achieve your goal.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Pierre FERRERE

    Hi, I've managed to use this script correctly but I have an issue :

    If I manually update data in the spreadsheet, the new data won't be updated on the pre-filled form loaded via the link produced by this script. In fact it only loads the originals answers to the form.

     

    So I found a workaround using this link combined with "&entry.458496192=data" parameters to pre-fill the form with data from the spreadsheet. 

    My goal is to let advanced users make mass-updates of the database using the spreadsheet and let less advanced users use the form to modify the database "line by line".

    The workaround works correctly but is really long to set-up because my database has more than 50 collumns. That means 50+ questions in the form and more importantly 50+ "&entry.458496192=data" parameters to add to the link.

     

    So I was wondering if it was possible to get rid of the form and allow modification of datas directly in Awesome Table display.

    Or maybe set-up the script to automatically update the stored pre-filled forms with data contained in the spreadsheet.

     

    0
    Comment actions Permalink
  • Avatar
    Lila Lee

    I am successfully running the script to populate the sheet with the edit URL.  In the column next to the URL column, I created the Button type column and am using this formula to automatically insert "EDIT" text into the Button type column: 

     =IF(AW3="","","EDIT")

    I then copied the formula down the column into the blank rows, .  The problem is Google Forms inserts a new row whenever a new form submission is made and the cell to the right of the URL is blank without the formula to automatically insert the text to appear on the button.

    Is here another way to automatically have 'EDIT' in the column next to the URL column?  Even if I just type in the word 'EDIT' in the blank rows, Google Forms submission will insert a new row underneath the last entry and the new row does not contain the test 'EDIT' in the next column.

    0
    Comment actions Permalink
  • Avatar
    dinz salamanca

    Hi! I am practicing this edit Url because I will use this soon in my students enrollment data...the link url generate automatically but the edit Url did not appear.

    var formURL = 'https://docs.google.com/forms/d/1dWtnlP4jQAlnCPvcPgjauOCj3Evxi_eWNLcaNfJjw94/viewform';
    var sheetName = 'Form responses 1';
    var columnIndex = 7;

    function getEditResponseUrls() {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
    var data = sheet.getDataRange().getValues();
    var form = FormApp.openByUrl(formURL);
    for(var i = 2; i < data.length; i++) {
    if (data[i][0] != '' && data[i][columnIndex-1] == '') {
    var timestamp = data[i][0];
    var formSubmitted = form.getResponses(timestamp);
    if (formSubmitted.length < 1) continue;
    var editResponseUrl = formSubmitted[0].getEditResponseUrl();
    sheet.getRange(i+1, columnIndex).setValue(editResponseUrl);
    }
    }
    }

    please help me fix this problem sir...

    Thank you very much!

    0
    Comment actions Permalink
  • Avatar
    Remi

    Hi Pierre!

    Thanks for your comment!

    I've created a ticket in order to fully understand your request here

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Avik Samanta

    Hello,

    I followed all the steps for the javascript code. It runs without any errors, but it doesn't add the links to the google sheet. How can I fix this?

    0
    Comment actions Permalink
  • Avatar
    Avik Samanta

    The code is running without any errors but fails to actually put the links in the spreadsheet. Please Help!

    0
    Comment actions Permalink
  • Avatar
    Alan Kho

    Hi, I followed the steps correctly until the Run function step, it didn't auto generate the links. How do I fix this?

    please help.  

    Thank you

    0
    Comment actions Permalink
  • Avatar
    Remi

    Hi Avik and Alan,

    If the issue is still there, could you please create a ticket on our support contact form:

    https://support.awesome-table.com/hc/en-us/requests/new

    Thanks

    0
    Comment actions Permalink
  • Avatar
    barak raz (Edited )

    hi there
    im having the same issue like: Drorlazar. (Ticket #104598).

    im getting:

    Sign in with Google temporarily disabled for this app

    This app has not been verified yet by Google in order to use Google Sign In.

    and i cant do nathing from my side.

    what i need to do?

    thank you

    0
    Comment actions Permalink
  • Avatar
    Vernon R. Totanes

    "An error occurred, please try again in a moment."

    That's the message I've gotten after several tries to copy the buttontype template on this page, as well as the one on the "ButtonType keyword" page.

    And when I try to read "Create an Update Button when using a Google Form," I get this: "The page you were looking for doesn't exist."

    Would anyone know how I can proceed?

    0
    Comment actions Permalink
  • Avatar
    Remi

    Hi Vernon R. Totanes,

    Could you please share more information within a ticket to our support team here: https://support.awesome-table.com/hc/en-us/requests/new

    Thanks

    0
    Comment actions Permalink

Please sign in to leave a comment.