Really bad! Skipping rows if another data in another column

Hi @shenalorlof,

Thank you for providing the screenshots for a better understanding of your requirement.

The current codebase doesn’t have the functionality to add the data to the row where at some columns the data already exist. It will always take a fresh new row and add data.

If you want to add a custom equation and have data for the column “Points”, you can create a hidden field and implement the CF7 hook “wpcf7_special_mail_tags” and return the values.

Hope this helps. Let us know.

Thanks
Abdullah

Hi, how can I do this process? Any examples which may help?

Hi @shenalorlof,

Here is how you can process.

Create a hidden field and name it as “points”.

Now add the below code and modify as per your requirement by creating any custom plugin or the functions.php file of the active theme used.

add_filter( "wpcf7_special_mail_tags", function( $output, $name, $html ) {
    $submission = WPCF7_Submission::get_instance();
    $posted_data = $submission->get_posted_data();
   if ( $name === "points" ) {            
      // Get all posted data here which you require for creating equation and return.
      $output = $posted_data[''];
      return $output;
   }
   return $output;
}, 10, 3 );

Hope this helps.

Thanks
Abdullah

I have the same problem, as all the information I have starts from column B, and in column A I have put a formula for incrementation, the result of the formula is empty as long as the row is empty, and increments numbers for the id, so even if it is empty beside the formula, it keeps skipping these rows

the solution I thought about:
it would have been amazing if the plugin didn’t check for empty cells in a row but blank cells, in this way I would have been able to use google sheet as it is supposed to be used with formulas
thank you

• This reply was modified 2 years, 7 months ago by imadbendimerad.