Issue with Google Forms Integration

1

 

Hi there, hive mind!

I’ve been trying to set up Google Form Linking with Kintone as per this tutorial and am getting the following error in execution transcript:

[18-04-24 10:43:18:210 EDT] FormApp.getActiveForm() [0.218 seconds]
[18-04-24 10:43:18:307 EDT] Starting execution
[18-04-24 10:43:18:338 EDT] Logger.log([Form submitted, ]) [0.001 seconds]
[18-04-24 10:43:18:346 EDT] FormResponse.getItemResponses() [0.007 seconds]
[18-04-24 10:43:18:347 EDT] FormResponse.getRespondentEmail() [0 seconds]
[18-04-24 10:43:18:350 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:412 EDT] Item.getTitle() [0.061 seconds]
[18-04-24 10:43:18:413 EDT] ItemResponse.getResponse() [0 seconds]
[18-04-24 10:43:18:414 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:483 EDT] Item.getTitle() [0.068 seconds]
[18-04-24 10:43:18:484 EDT] ItemResponse.getResponse() [0 seconds]
[18-04-24 10:43:18:487 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:546 EDT] Item.getTitle() [0.059 seconds]
[18-04-24 10:43:18:576 EDT] ItemResponse.getResponse() [0 seconds]
[18-04-24 10:43:18:578 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:639 EDT] Item.getTitle() [0.06 seconds]
[18-04-24 10:43:18:641 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:705 EDT] Item.getTitle() [0.063 seconds]
[18-04-24 10:43:18:706 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:770 EDT] Item.getTitle() [0.064 seconds]
[18-04-24 10:43:18:772 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:836 EDT] Item.getTitle() [0.063 seconds]
[18-04-24 10:43:18:837 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:18:899 EDT] Item.getTitle() [0.061 seconds]
[18-04-24 10:43:18:901 EDT] ItemResponse.getItem() [0 seconds]
[18-04-24 10:43:19:011 EDT] Item.getTitle() [0.11 seconds]
[18-04-24 10:43:19:014 EDT] ItemResponse.getItem() [0.001 seconds]
[18-04-24 10:43:19:081 EDT] Item.getTitle() [0.066 seconds]
[18-04-24 10:43:19:082 EDT] Logger.log([Response JSON is “%s”, [[{“reporter_email”: { “value”: “meg.hillmann@unitedwayswpa.org” },“reporter” : { “value”: “Meg Hillmann” },“form” : { “value”: “Test 5” },“priority” : { “value”: "Form will be use]]…) [0 seconds]
[18-04-24 10:43:19:088 EDT] Execution failed: SyntaxError: Unexpected comma in object literal (line 41, file “sendToKintone”) [0.749 seconds total runtime]

I literally copied and pasted the script and adjusted field names… Any ideas what went wrong?

 

2

Hi Meg,

Sorry but I could not find how you got this error exactly from the error messages.

However, I see from the last line of the messages as below.
 
“Execution failed: SyntaxError: Unexpected comma in object literal (line 41, file “sendToKintone”) [0.749 seconds total runtime]”

There is SyntaxError and sendToKintone might have some issue on line 41 due to “Unexpected comma”.

 

If you just copy from the sample code from “step 3” on the tutorial, I wonder how you got the error with line 41, which include “var records = JSON.parse(str)”.

Actually, I have tried this tutorial by myself and I was able to accomplish this without any issue.

 

What I have revised is as below.

 

-On line 34, I changed “subdomain” to my subdomain address.

var subdomain = ‘{subdomain}.kintone.com’; // change URL to your kintone domain

 

-On line 36, I changed the information after “appid:”, “number:” and "token: ". 
YOUR_APPLICATION1: { appid: 1, name: ‘Kintone Connect’, token: ‘xxxxxxxxx’ }
    };

 

If I were you, I would double check line 41 on the coding.

 

Hope it helps.

Thanks.

Junko

3

It seems the error is originated from parsing JSON string.

Did you check the contents of variable “str”?

I suspect there is a double quote( " ) in the text value. 

Can you try the following code in line 40?

str = str.replace(//g, “\n”).replace(/\r/g, “\r”).replace(/\t/g, “\t”).replace(/"/g, “’”);//Add a method to replace a double quote to a single quote 

4

Hello Junko, 

I tried to follow this tutorial as well, but i could not successfully registered the data in Kintone.

  1. Does the value of the subdomain variable = {sampledomain}.kintone.com? 

Parenthesis is not removed?

Sorry to cut in here. Thank you.

5

Hi Kimmy,

No worries!

You are right that "{}"curly brackets should not be included in this case.

If your subdomain is “sampledomain”, here is how you can assign the value to the subdomain variable as below.

var subdomain = 'sampledomain.cybozu.com';

Thank you for asking!

Junko