• Resolved cambriawebmaster

    (@cambriawebmaster)


    Hi There

    I have setup a Contact Form 7 Form and installed and verified this plugin with my Google Sheets.

    It currently sits on our staff intranet which is internal only.

    Basically here is the form I have below:

    <fieldset><legend>1. College site</legend>[select site include_blank “Bersham” “Deeside” “Llysfasi” “Northop” “Yale” “Hawarden Composites Centre”]</fieldset>

    <fieldset><legend>2. Details of injured person</legend>
    [text your-name placeholder "Name"][text age placeholder "Age"]Gender [select gender include_blank “Male” “Female”]Status[select status include_blank “Employee” “Student” “Contractor” “Visitor” “Client”]Next of kin informed?<br />[radio kin “Yes” “No”]<br />Parents informed? (Nursery / Holiday Club Only)<br />[radio parents “Yes” “No”]
    </fieldset>

    <fieldset><legend>3. Details of accident</legend>
    [text date placeholder "Date (dd/mm/yy)"][text time placeholder "Time"][text location placeholder "Location of accident"]Risk assessment in place?<br />[radio risk “Yes” “No”][textarea details placeholder “Details of Occurrence/Injury”]
    </fieldset>

    <fieldset><legend>4. Witnesses</legend>
    [textarea detailswit placeholder “Details of witnesses (if any)”][text whom placeholder "By whom?"]
    </fieldset>

    <fieldset><legend>5. Treatment</legend>
    Was first aid given?<br />[radio firstaid “Yes” “No”]<br />Was the individual:<br />[select individual include_blank “Retained in college” “Sent home” “Taken to hospital” “Referred to GP”]
    </fieldset>

    <fieldset><legend>6. Reporting</legend>
    [text reportedby placeholder "Accident reported by:"][text datereportedby placeholder "Date (dd/mm/yy)"][text timereportedby placeholder "Time"]<br /><br />[text reportedto placeholder "Accident reported to:"][text datereportedto placeholder "Date (dd/mm/yy)"][text timereportedto placeholder "Time"]
    </fieldset>
    [submit “Submit”]

    I have also setup the Google Sheet where I want all submissions to go to and the CF7 Google Sheets I have setup looks like this:

    Google Sheet Name
    AccidentReport

    Google Sheet Tab Name
    submissions

    I have added in my Google Sheet the name called ‘AccidentReport’ and the tab is ‘submissions’. I have then added the column names in to each column on the spreadsheet (please see below:

    date [site][your-name][your-age][your-gender][your-status][your-kin] [your-parents] [your-date] [your-time] [location][risk] [details] [detailswit] [whom] [firstaid] [individual] [reportedby] [datereportedby] [timereportedby] [datereportedto] [timereportedto]

    I am getting an email with the successful submission but its not getting added to the Google Sheet. I also checked the CF7 log and getting this message:

    PHP 5.5.38 Error fetching OAuth2 access token, message: ‘invalid_grant’ :: 400

    Please help?

    Thanks

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘No Submissions going to Google Sheet’ is closed to new replies.