CF7 Text Field data causes fail to send to Google sheets?
-
I set up a contact form 7 form about 2 months ago which includes amongst other field, a text field for users to enter an address.
This form is sent to Google Sheets via the Integration for Contact Forms and Google Sheets plugin
It has worked fine up until recently, 12 rows added to the sheet successfully, and no configuration changes to the form have occurred but now whenever a user enters an address in the text field, the google submission fails with a (Invalid values[16][12]: list_value { } ) error
If i edit the submitted data to remove the address data or reduce it to 1 line, it submits fine.
IE – this will fail:
1 High Street
Town
County
Postcode
but editing the data to just this and resubmitting will succeed:
1 High Street
There are no special characters being used in the data, but reducing the data to a single line results in a successful submission (ie remove everything except the 1st line of the addresss), not sure if the Enter to move to a new line in the text box is the issue?
I have had 10 records succesfully work previosuly with the same config with multi line addresses but now they fail if they have multi lines?- This topic was modified 10 months, 3 weeks ago by .
- This topic was modified 10 months, 3 weeks ago by .
- This topic was modified 10 months, 3 weeks ago by .
The page I need help with: [log in to see the link]
- The topic ‘CF7 Text Field data causes fail to send to Google sheets?’ is closed to new replies.