# Using forms to add multiple rows to a table from a single form response **URL:** \ **Category:** Showcase & Tips\ **Created:** [February 26, 2021, 12:50am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737 "2021-02-26T00:50:36Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JonO](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jono/32/19646_2.png) [@JonO](https://connect.superhuman.com/u/JonO)\ **Post date:** [February 26, 2021, 12:50am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/1 "2021-02-26T00:50:36Z")
I am trying to create a form that creates multiple table records from a single form entry. Essentially I have a lookup/reference table CATEGORY A CATEGORY B CATEGORY C and then I want a form that will collect a response for each lookup item NAME: Jon CATEGORY A | SCORE CATEGORY B | SCORE CATEGORY C | SCORE Which I want to write to a table that creates a row for each entry Jon | CATEGORY A | SCORE Jon | CATEGORY B | SCORE Jon | CATEGORY C | SCORE I’ve tried multiple forms per page, but that doesn’t quite seem to work as the response to 1 form seems to overwrite the other form instead of adding another record. Jon | CATEGORY A | SCORE Jon | CATEGORY B | SCORE Jon | CATEGORY C | SCORE Someone Else | CATEGORY A | SCORE Someone Else | CATEGORY B | SCORE Someone Else | CATEGORY C | SCORE Some Other Someone Else | CATEGORY A | SCORE Some Other Someone Else | CATEGORY B | SCORE Some Other Someone Else | CATEGORY C | SCORE My goal is to get a name (the person submitting the form) and collect scores on 5-10 items from that person, then be able to analyze scores from other people on the same categories. The final result would be a scorecard for that person with their ranking compared with the average ranking for other respondents. CATEGORY A | Jon’s Score | Average Score CATEGORY B | Jon’s Score | Average Score CATEGORY C | Jon’s Score | Average Score I think this would be reasonable easy tables, but can I do something like this with forms to allow for a broader pool of respondents? ---
**Author:** ![Christiaan\_Huizer](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christiaan_huizer/32/28269_2.png) [@Christiaan\_Huizer](https://connect.superhuman.com/u/Christiaan_Huizer)\ **Post date:** [February 26, 2021, 11:50am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/2 "2021-02-26T11:50:54Z")
hi @JonO , welcome If you create a doc and share it here so we can look in to it with sample data in it, we can have a look. Each submission is a new row in the table and each row has multiple columns (one per response). As such you create a table filled with results and that is the starting point for any review. Maybe you want to transpose the data. Cheers, Christiaan ---
**Author:** ![James\_Drew](https://avatars.discourse-cdn.com/v4/letter/j/a3d4f5/32.png) [@James\_Drew](https://connect.superhuman.com/u/James_Drew)\ **Post date:** [June 12, 2022, 2:38pm UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/3 "2022-06-12T14:38:03Z")
Hi, I have a very similar question as JonO above. Does anyone know the answer? Essentially I want to create a form that allows a user to create multiple table records from a single form entry. Very similar to JonO, I have a lookup/reference table that will allow the user to make a selection, and for that selection I want the user to input a score. But I want the user to be able to see each of their selections/scores in the form together prior to submitting, rather than having to submit the form multiple times, once for each selection/score. Even further, I want to perform a validation test on the various selections/scores so that they have to satisfy certain rules to be accepted (for example, no duplicates within the form’s selections and scores). Does anyone know if this is possible in Coda? Or are there third party service integrations that will allow this? ---
**Author:** ![Dale\_Cowling](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@Dale\_Cowling](https://connect.superhuman.com/u/Dale_Cowling)\ **Post date:** [July 2, 2022, 6:16pm UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/4 "2022-07-02T18:16:10Z")
Hi @James_Drew, If you are still looking for a solution please check out the doc below. https://coda.io/embed/8kV47W9z14/_suVYO?viewMode=embedplay If you need further support I will need more specifics and ideally a dummy document to work on. All the best Dale ---
**Author:** ![anon55094081](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@anon55094081](https://connect.superhuman.com/u/anon55094081)\ **Post date:** [June 22, 2023, 1:45am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/5 "2023-06-22T01:45:14Z")
Thanks for this. Would this work for a non signed in viewer? ---
**Author:** ![Dale\_Cowling](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@Dale\_Cowling](https://connect.superhuman.com/u/Dale_Cowling)\ **Post date:** [June 23, 2023, 11:57am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/6 "2023-06-23T11:57:17Z")
Hi @anon55094081, Not directly. Forms cannot use table lookups or buttons that I know of. Your best bet would be to have automations on form submit. A column could be added that is a button and on each new form submission have it press the button. This button could run the validation check and add to the results table. In the event of a duplication you would email back the user to let them know, as long as the form holds a way to identify the user submitting and the email to notify. As I was about to submit I did have another thought. I previously helped with another forum post where they wanted to allow Form users to add new options to a drop down list that would become available to all other form users. Essentially it would build over time. While you cannot use filtering on this it could perhaps be modified so that the list contains existing results and the user submitting has to check to see if their new submission isn’t already listed. You can find it here. > [@Forms - How to use the Select List column type but allow for new options to be added from the form?](https://connect.superhuman.com/t/forms-how-to-use-the-select-list-column-type-but-allow-for-new-options-to-be-added-from-the-form/22387/3): > > Hi @CJ_Brunke, There have been a number of requests of this kind. It is not natively possible to have the ability to add options currently. The only solution I can offer is using table lookup select list and automation. The form table contains a lookup list column and an ‘other’ column. The automation triggers when a new submission comes through. It checks if the lookup table contains that “other” entry and if it doesn’t then it creates it. Once the form link is used again it will have the … If you want help with setting up something like this I would recommend creating a new post and we can go from there. I hope that this info is useful. All the best Dale ---
**Author:** ![anon55094081](https://avatars.discourse-cdn.com/v4/letter/a/a6a055/32.png) [@anon55094081](https://connect.superhuman.com/u/anon55094081)\ **Post date:** [June 28, 2023, 5:17am UTC](https://connect.superhuman.com/t/using-forms-to-add-multiple-rows-to-a-table-from-a-single-form-response/21737/7 "2023-06-28T05:17:08Z")
Thanks Dale. Useful thoughts!