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?
-
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. ]
The topic ‘Populate multiple rows’ is closed to new replies.
