tierramitica1

Thanks for your answer Nasir, I sent you an email!

Hello Nasir Ahmed and thank you for your answer. I did what you said and now it is connected again and everything works fine again. However, I would not like this to happen in the future.. Could this keep happening and could I risk new data not appearing in Google sheets?

Aside from this, your app is working perfectly so thank you for your effort and support!

Hello again, never mind my previous question, I installed and set up the plugin and I was able to figure it out easily and I got it to work perfectly. However, now that I am testing, twice already the map fields spreadsheet field of my integration has disappeared, which makes me no longer able to do any changes to the fields. When I look under settings, it says I am “Not Connected”, even though the correct ID and secret are filled in. When I press “save and authorize again, it just sends me to google again. It happened before, a few hours ago, and then it just started working again shortly after so I thought it was a temporary glitch, but now it happened again and the test order that I did just now did not appear in my google sheet.

Could you please help me figure this one out? Thank you!

I did it!!! I spent a few hours delving into PHP and got my code to work! The email looks perfect now with a nice organized table. I committed to a five day PHP crash course thanks to you and looking forward to learn more. Thanks again.

Sharing it here in case other people are interested:

add_filter( 'cf7sg_mailtag_cf7sg-form-registration-form-2', 'filter_cf7_mailtag_cf7sg_form_registration_form_2', 10, 3);
function filter_cf7_mailtag_cf7sg_form_registration_form_2($tag_replace, $submitted, $cf7_key){
  /*the $tag_replace string to change*/
  /*the $submitted an array containing all submitted fields*/
  /*the $cf7_key is a unique string key to identify your form, which you can find in your form table in the dashboard.*/
  if('registration-form-2'==$cf7_key ){
    $style = 'style="padding:0 3px;border-collapse:collapse;border-bottom:1px solid black[qtm]';
    $tag_replace ='
    <table>
      <thead><tr><th>Guest Name</th><th>Passport number</th><th>Age</th><th>Sex</th></tr></thead>
      <tbody>';
    if(!empty($submitted['full-guest-name'])){
      $style = 'style=[qtm]background-color:#e3e3e3[qtm]';
      $row=1;
      foreach($submitted['full-guest-name'] as $idx=>$guest){
        $tag_replace .='  <tr><td '.($row%2==0?$style:'').'>'.$guest.'</td><td '.($row%2==0?$style:'').'>'.$submitted['passport-number'][$idx]. '</td><td '.($row%2==0?$style:'').'>'.$submitted['age'][$idx]. '</td><td '.($row%2==0?$style:'').'>'.$submitted['sex'][$idx]. '</td></tr>'.PHP_EOL;
        $row++;
      }
    }
    $tag_replace .='
      </tbody>
    </table>
    ';
  }
  return $tag_replace;
}

I understand, thanks though!