Support » Plugin: Google Sheets Integration for Caldera Forms » Cannot populate sheet if columns are less than fields.

  • Resolved David Cramer

    (@desertsnowman)



    Hi There.

    A default new sheet has 26 columns (A-Z)
    My form had 30 fields, which caused the sheet to not populate since it cant update a nonexistent cell.

    To fix this, on line 85 of ./lib/google-sheets.php I added a check for the column count and the number of field, then updated the columns in the sheet to match.

    if( count( $data ) > $worksheet->getColCount() ){
    	$worksheet->update( null, count( $data ) );
    }

    All the best,
    ~ David

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cannot populate sheet if columns are less than fields.’ is closed to new replies.