Title: Populate multiple rows
Last modified: June 9, 2017

---

# Populate multiple rows

 *  Resolved [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/populate-multiple-rows/)
 * I’m trying to build a form that populates more than one row in a Google Sheet
   from a single submitted form.
 * ie In the Google Sheet there are columns for [user-name], [email], [date], and
   then [item-type], [item-size], [item-location] etc, and users should be able 
   to entre multiple items without having to submit multiple forms. (A bit like 
   a shopping list.)
 * Is there a way to do this with this plugin?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [WesternDeal](https://wordpress.org/support/users/westerndeal/)
 * (@westerndeal)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/populate-multiple-rows/#post-9212382)
 * Hi,
    Can you show me the form which you are talking about like shopping list (
   screenshot or URL) to have an idea of what you are talking about.
 *  Thread Starter [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/populate-multiple-rows/#post-9212470)
 * (Thanks for the very quick response!)
    ⌊Form Screen grab⌉
    -  This reply was modified 8 years, 11 months ago by [eyeghoti](https://wordpress.org/support/users/eyeghoti/).
 *  Plugin Author [WesternDeal](https://wordpress.org/support/users/westerndeal/)
 * (@westerndeal)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/populate-multiple-rows/#post-9212516)
 * Thanks for the screenshot,
    Can you send me the screenshot from backend form 
   too?
 *  Thread Starter [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/populate-multiple-rows/#post-9212552)
 * By backend form, I assume you mean the code for the form?
    (I’ve only included
   the code for 2 rows, rather than all 10, and cut out some of the drop-down options
   just to make it easier to read.)
 * At the moment I only one row is added to the Google Sheet, that being the last
   one entred (if 3 items are entred, the 3rd overwrites the others, because they
   have the same field name.)
    I could have columns called [location-1], [location-
   2] etc, but then colating the data into a readable spreadsheet becomes a PITA.
 *     ```
       <label> <strong>First name</strong> [text* first-name] </label> <label> <strong>Surname</strong> [text* surname] </label>
       <label> <strong>Date of catch</strong> [date* date-fished] </label>
   
       <table>
       <tr>
       <td></td>
       <td>Location</td>
       <td>Species</td>
       <td>Size</td>
       <td>Killed</td>
       <td>Fly<br>(optional)</td>
       <td>Hook size<br>(optional)</td>
       </tr>
       <tr>
       <td>1</td>
       <td>[select location include_blank "Archers" "Meadow" "Home Wood" "Lake"]</td>
       <td>[select species include_blank "Brown" "Grayling" "Rainbow"]</td>
       <td>[select size include_blank "<9" "9 to 15" "16 to 20"]</td>
       <td>[select killed include_blank "No" "Yes"]</td>
       <td>[select fly include_blank "GRHE" "PTN" "Klink" "other"]</td>
       <td>[select fly-size include_blank "16" "14" "12" "10" ]</td>
       </tr>
   
       <td>2</td>
       <td>[select location include_blank "Archers" "Meadow" "Lake"]</td>
       <td>[select species include_blank "Brown" "Grayling" "Rainbow"]</td>
       <td>[select size include_blank "<9" "9 to 15" "16 to 20"]</td>
       <td>[select killed include_blank "No" "Yes"]</td>
       <td>[select fly include_blank "GRHE" "PTN" "Klink" "other"]</td>
       <td>[select fly-size include_blank "16" "14" "12" "10" ]</td>
       </tr>
       </table>
   
       <label>Notes (optional) 
       [textarea notes 3x placeholder "(You can enter any details here about your day that you think might be useful to club members)"]</label>
   
       [submit "Send"]
       ```
   
 * _[ [No bumping please](http://codex.wordpress.org/Forum_Welcome#No_Bumping). ]_
    -  This reply was modified 8 years, 11 months ago by [eyeghoti](https://wordpress.org/support/users/eyeghoti/).
    -  This reply was modified 8 years, 10 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Populate multiple rows’ is closed to new replies.

 * ![](https://ps.w.org/cf7-google-sheets-connector/assets/icon-128x128.gif?rev=
   3232650)
 * [GSheetConnector for CF7 – Connect Contact Form 7 to Google Sheets and Send Form Submissions in Real Time](https://wordpress.org/plugins/cf7-google-sheets-connector/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/cf7-google-sheets-connector/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/cf7-google-sheets-connector/)
 * [Active Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/cf7-google-sheets-connector/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/cf7-google-sheets-connector/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/populate-multiple-rows/#post-9240455)
 * Status: resolved