cotrones

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets
    Thread Starter cotrones

    (@cotrones)

    9 years, 9 months ago

    Do you happen to have an example of a Google Form submission url? Or could you point me in the right direction in the page source?

    Thanks in advance!

    Forum: Plugins
    In reply to: [Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets
    Thread Starter cotrones

    (@cotrones)

    9 years, 9 months ago

    Hey Zaus, I was wondering what should be in my Google Form in order for it to integrate properly?

    Forum: Plugins
    In reply to: [Forms: 3rd-Party Integration] Gravity Forms to Goole Sheets
    Thread Starter cotrones

    (@cotrones)

    9 years, 9 months ago

    Thanks for the reply. I’m new to this if you couldn’t already tell. I am still receiving a failure notice, I’m not sure where I’m going wrong. I will paste the email below. A few other questions:

    Do you think I am messing up the mapping?
    I already have the field names on my Google Sheet, should I delete these?
    Does this form seem correct to you or do I not even need this code?:

    function doPost(e) {

  if (!e) return;

  var sheetID = "1_pextohBKnlOyWvuD3bwypdXSX7ZqHBnf7zvFjB7jkw";  // Replace this with the Google Spreadsheet ID
  var sheetName = "Gravity Forms Test Sheet";       // Replace this with the sheet name inside the Spreadsheet

  var status = {};

  // Code based on Martin Hawksey (@mhawksey)'s snippet

  var lock = LockService.getScriptLock();
  lock.waitLock(30000);

  try {

    var sheet = SpreadsheetApp.openById(sheetID).getSheetByName(sheetName);
    var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];

    // Add the data and time when the Gravity Form was submitted
    var column, row = [],
      input = {
        "timestamp": new Date()
      };

    for (var keys in e.parameter) {
      input[normalize_(keys)] = e.parameter[keys];
    }

    for (i in headers) {
      column = normalize_(headers[i])
      row.push(input[column] || "");
    }

    if (row.length) {

      sheet.appendRow(row);
      status = {
        result: "success",
        message: "Row added at position " + sheet.getLastRow()
      };

    } else {
      status = {
        result: "error",
        message: "No data was entered"
      };
    }

  } catch (e) {

    status = {
      result: "error",
      message: e.toString()
    };

  } finally {

    lock.releaseLock();

  }

  return ContentService
    .createTextOutput(JSON.stringify(status))
    .setMimeType(ContentService.MimeType.JSON);

}

function normalize_(str) {
  return str.replace(/[^\w]/g, "").toLowerCase();
}

    Really sorry for the long post I just want to figure this out. I appreciate your help. Here is the failure email I received:

    There was an error when trying to integrate with the 3rd party service {Service 1} (https://script.google.com/macros/s/AKfycbyWce3ApBXG2CwobvA4e4hAYoTDhzwDdgsRqc_SIbP89klDCDox/exec).

    **FORM**
    Title: SIGNUP NOW
    Intended Recipient: –na–
    Source: http://hotjobing.com/browse-jobs/?search_keywords&search_location&search_category=22

    **SUBMISSION**
    Array
    (
    [timeout] => 10
    [body] => Array
    (
    [First Name] => Tom
    [Last Name] => Cotroneo
    [Email Address] => tomcotroneo@gmail.com
    [Phone Number] => (973) 303-0477
    [Job Category] => E-Commerce
    [Edu. Level] => Completed HS or Ged
    [Interested In] => Yes
    )

    )

    **RAW RESPONSE**
    Array
    (
    [headers] => Array
    (
    [content-type] => text/html; charset=UTF-8
    [content-length] => 1555
    [date] => Wed, 27 Jul 2016 18:52:16 GMT
    )

    [body] => <!DOCTYPE html>
    <html lang=en>
    <meta charset=utf-8>
    <meta name=viewport content=”initial-scale=1, minimum-scale=1, width=device-width”>
    <title>Error 400 (Bad Request)!!1</title>
    <style>
    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}
    </style>
    <span id=logo aria-label=Google></span>
    <p><b>400.</b> <ins>That’s an error.</ins>
    <p>Your client has issued a malformed or illegal request. <ins>That’s all we know.</ins>

    [response] => Array
    (
    [code] => 400
    [message] => Bad Request
    )

    [cookies] => Array
    (
    )

    [filename] =>
    [safe_message] => physical request failure
    )

Viewing 3 replies - 1 through 3 (of 3 total)