How do i make a form create a new row, setting each column to each input field on the form?
When I set the action on submit to “Add row”, when a user clicks submit it creates a row with the user’s name, then a row with the input fields (2x rows in total for each submit)
When I set the action on submit to “Set columns”, when a user clicks submit it creates a new row with the user’s name and that is all (1x in total, missing the other input fields)
What is going on here? Why can’t I just take the fields and plonk the outputs in a separate sheet?
Thanks in advance