# Form submission creates multiple rows

**URL:** <https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554>\
**Category:** Ask for Help\
**Created:** [July 1, 2021, 6:13am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554 "2021-07-01T06:13:16Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Indi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/indi/32/28533_2.png) [@Indi](https://community.glideapps.com/u/Indi)\
**Post date:** [July 1, 2021, 6:13am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/1 "2021-07-01T06:13:16Z")

</div>

Hi,

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)  
 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/eae10b06665bdcb97d7bb1de7aa459ad6ea2ff71.png)

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

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [July 1, 2021, 6:17am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/2 "2021-07-01T06:17:28Z")

</div>

Welcome to the community

This post will help you have a read - [Double Rows generated by Add form](https://community.glideapps.com/t/double-rows-generated-by-add-form/23679)

Basically you don’t need set columns as the form already does that for you.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5bd5b60650e3829d2125e96e5dfe2edc8bb16fd1.jpeg)

---

<div class="post-metadata">

**Author:** ![Indi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/indi/32/28533_2.png) [@Indi](https://community.glideapps.com/u/Indi)\
**Post date:** [July 1, 2021, 7:30am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/3 "2021-07-01T07:30:11Z")

</div>

I have seen many posts about this topic, but all the instructions are vague or unclear.

I have set the action after submit to “none”, yet the form still only transfers the users name and not the 2x other pieces of data. Picture below for ref

 ![eg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf75538c9e6ca5ef9c4ced8e6bfb2e8eea6cefdd.png)

Also for ref, the 3x pieces of data i want in each column is: name, total contract value (number), contract summary (template list)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2021, 7:39am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/4 "2021-07-01T07:39:55Z")

</div>

It seems like you only set the name as an entry, the other two are only for displaying purposes on that screen, right?

To get the other two as well, I believe you can use them as a “screen column value” and point them to the other 2 columns in the destination sheet.

---

<div class="post-metadata">

**Author:** ![Indi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/indi/32/28533_2.png) [@Indi](https://community.glideapps.com/u/Indi)\
**Post date:** [July 1, 2021, 8:03am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/5 "2021-07-01T08:03:55Z")

</div>

Hmmm, thanks for the suggestion. I looked into that but i struggle to follow [many of the glides guides](https://docs.glideapps.com/all/reference/values/column-values) because the interface in the guides looks different to my interface and i dont understand why?

Anyway, I ended up creating a new glide table to catch all the form submissions (with only the users name), AND create an action on submit to send the relevant information for that user into my desired G-sheet. probably not the most ideal solution, but it seems to get the job done

![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/00d2a63bc70ab26c4b1195d7b25b1bce19399fc7.png)

thanks for your help along the way anyway

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2021, 8:07am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/6 "2021-07-01T08:07:41Z")

</div>

> [@Indi](#):
>
> I looked into that but i struggle to follow [many of the glides guides](https://docs.glideapps.com/all/reference/values/column-values) because the interface in the guides looks different to my interface and i dont understand why?

Sorry for that, Glide has evolved a lot in the past months, especially with the new interface and I’m sure their team will update the instructions video soon.

Regarding the form, you can still try my suggestion not to have to create a new table on top of the row you’re already writing with that form.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2021, 8:17am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/7 "2021-07-01T08:17:26Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39469e2eaac404ffe81cf909c5f3983b89547f6c.png)

The “screen columns” would appear on the left when you click the “plus” button in the screen-data row while viewing screen components, and do a search. You can search for your “BB Contract Value” and “BB Order Summary” fields there.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 1, 2021, 11:57am UTC](https://community.glideapps.com/t/form-submission-creates-multiple-rows/28554/8 "2021-07-01T11:57:33Z")

</div>

Actually it looks like values are coming from the user profile sheet, so user profile column components can be added instead.
