• Resolved siddheshwar99

    (@siddheshwar99)


    Hello,
    We are facing the issue with the plugin on our website, it submits only the required fields data in google sheet, when we mark the input field as non-required it not saving the same in the google sheet. Below attaching the debug log for the reference if it helps – Score CET and Scrore JEE fields not submitting the data –

    
    14 September 2020 23:26:47 	 PHP 7.3.5Array
    (
        [date] => September 14, 2020
        [time] => 11:26 pm
        [serial-number] => 
        [remote-ip] => 10.5.1.20
        [user-agent] => Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36
        [url] => https://www.isquareit.edu.in/application-form-2020/
        [post-id] => 18548
        [post-name] => application-form-2020
        [post-title] => Application Form 2020
        [post-url] => https://www.isquareit.edu.in/application-form-2020/
        [post-author] => i2it_admin
        [post-author-email] => siddheshwar@onlinebusiness.org
        [site-title] => Engineering College in Pune | I²IT International Institute of Information Technology
        [site-description] => Engineering College in Pune | I²IT International Institute of Information Technology
        [site-url] => https://www.isquareit.edu.in
        [site-admin-email] => sachinb@isquareit.edu.in
        [user-login] => 
        [user-email] => 
        [user-url] => 
        [user-first-name] => 
        [user-last-name] => 
        [user-nickname] => 
        [user-display-name] => 
        [DTENO] => 
        [admissionto] => First Year Engineering
        [preference1] => Computer Engineering
        [preference2] => Information Technology
        [preference3] => Electronics & Telecommunication
        [namecand] => Sagar Ghosh
        [dateobirth] => 2002-01-12
        [gender] => male
        [email] => sagarghosh0102@gmail.com
        [fathername] => Sibanta Kumar Ghosh
        [emplf] => Yes
        [jobf] => Govt.
        [organizationf] => Primary Teachers Training Collage Chakulia
        [locationf] => Post Chakulia, Dist east Singhbhum ,Jharkhand , 832301
        [incomef] => 948120
        [namem] => Sunita Ghosh
        [emplm] => No
        [jobm] => Private
        [organizationm] => 
        [locationm] => 
        [incomem] => 
        [address] => C-534, koel nagar , rourkela, odisha
        [landline] => 
        [mobile] => +918658636070
        [board10] => CBSE
        [school10] => Deepika English Medium School, Rourkela
        [passingyear10] => may 2018
        [marks10] => 551
        [outof10] => 600
        [board12] => CBSE
        [college12] => Deepika English Medium School , Rourkela
        [passingyear12] => may 2020
        [marks12] => 457
        [outof12] => 500
        [recently-appeared] => 12th Examination
        [physics] => 95
        [physics-outof] => 100
        [chemistry] => 84
        [chemistry-outof] => 100
        [math] => 95
        [maths-outof] => 100
        [vocational] => none
        [vocational-outof] => N/A
        [diploma-final-year] => 
        [scoreCET] => N/A
        [scoreJEE] => 81.9028973
        [acceptanceform] => 1
        [mc4wp_checkbox] => No
        [ERROR_MSG] => Access token is invalid
        [TRACE_STK] => #0 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/DefaultServiceRequest.php(130): Google\Spreadsheet\DefaultServiceRequest->execute(Resource id #2668)
    #1 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/cf7-google-sheets-connector/lib/asimlqt/php-google-spreadsheet-client/src/Google/Spreadsheet/SpreadsheetService.php(37): Google\Spreadsheet\DefaultServiceRequest->get('feeds/spreadshe...')
    #2 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/cf7-google-sheets-connector/lib/google-sheets.php(73): Google\Spreadsheet\SpreadsheetService->getSpreadsheets()
    #3 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/cf7-google-sheets-connector/includes/class-gs-service.php(175): CF7GSC_googlesheet->add_row(Array)
    #4 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp-hook.php(288): Gs_Connector_Service->cf7_save_to_google_sheets(Object(WPCF7_ContactForm))
    #5 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters(false, Array)
    #6 /usr/share/nginx/www.isquareit.edu.in/wp-includes/plugin.php(478): WP_Hook->do_action(Array)
    #7 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/contact-form-7/includes/submission.php(214): do_action('wpcf7_mail_sent', Object(WPCF7_ContactForm))
    #8 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/contact-form-7/includes/submission.php(34): WPCF7_Submission->submit()
    #9 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/contact-form-7/includes/contact-form.php(740): WPCF7_Submission::get_instance(Object(WPCF7_ContactForm), Array)
    #10 /usr/share/nginx/www.isquareit.edu.in/wp-content/plugins/contact-form-7/includes/rest-api.php(280): WPCF7_ContactForm->submit()
    #11 /usr/share/nginx/www.isquareit.edu.in/wp-includes/rest-api/class-wp-rest-server.php(946): wpcf7_rest_create_feedback(Object(WP_REST_Request))
    #12 /usr/share/nginx/www.isquareit.edu.in/wp-includes/rest-api/class-wp-rest-server.php(329): WP_REST_Server->dispatch(Object(WP_REST_Request))
    #13 /usr/share/nginx/www.isquareit.edu.in/wp-includes/rest-api.php(305): WP_REST_Server->serve_request('/contact-form-7...')
    #14 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp-hook.php(288): rest_api_loaded(Object(WP))
    #15 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)
    #16 /usr/share/nginx/www.isquareit.edu.in/wp-includes/plugin.php(544): WP_Hook->do_action(Array)
    #17 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp.php(387): do_action_ref_array('parse_request', Array)
    #18 /usr/share/nginx/www.isquareit.edu.in/wp-includes/class-wp.php(733): WP->parse_request('')
    #19 /usr/share/nginx/www.isquareit.edu.in/wp-includes/functions.php(1255): WP->main('')
    #20 /usr/share/nginx/www.isquareit.edu.in/wp-blog-header.php(16): wp()
    #21 /usr/share/nginx/www.isquareit.edu.in/index.php(17): require('/usr/share/ngin...')
    #22 {main}
    )
Viewing 1 replies (of 1 total)
  • Plugin Author westerndeal

    (@westerndeal)

    Hello @siddheshwar99
    Sorry for the delay in responding.

    There is nothing like that the mandatory fields may show in sheet others not,
    There might be some glitch, I can see there are others errors of CF7 and core WP errors, can you make sure, that you are using the latest version of WP and CF7 and CF7GSheet too?

    As due to custom mail tag issues we have released the new version.
    Can you update to latest and let me know with the current status to help you out?

    Many Thanks
    Abdullah

Viewing 1 replies (of 1 total)
  • The topic ‘Only required data submitted to the google sheet’ is closed to new replies.