# Add a row from separate data table

**URL:** <https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653>\
**Category:** Ask for Help\
**Created:** [March 2, 2023, 7:53am UTC](https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653 "2023-03-02T07:53:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jsg0813](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jsg0813](https://community.glideapps.com/u/jsg0813)\
**Post date:** [March 2, 2023, 7:53am UTC](https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653/1 "2023-03-02T07:53:57Z")

</div>

Hi all,

I am trying to configure a custom action that adds a row to a sheet. What I am trying to figure out is how I can write data to the sheet that is not sourced within the page data, but rather from a collection on that page. Sounds confusing but let me try to explain.

There is a page that allows the user to check (with a checkbox) a specific row within a collection. The page itself is a new page ontop of a seperate data sheet. When the user clicks the button, I need the data from the collection that was checked to be sent to a new sheet, but I don’t get the option to choose the collection data to write, instead only the source data.

I know that still sounds confusing so I attached pics.

The first is the page with the checkboxes.

The second is the custom action, but it’s wants me to write the incorrect data to the new sheet.

 ![Screenshot_13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/1/e1287440ae0054adad7f1ba64b00a348cd6c5ad1.png)  
 ![Screenshot_14](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/3947a9019a9c2ed71973f7cf596ed09bebb651b2.png)

---

<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:** [March 2, 2023, 12:56pm UTC](https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653/2 "2023-03-02T12:56:46Z")

</div>

In the table that is the source of the collection, create an IF column that returns the ID or Name only if the box is checked. Then in the table that your action has access to, create a joined list column that returns the IF column value from your collection table. Then your action will have access to that joined list.

Honestly, a choice component would do the exact same thing without the extra work. Source the choices from your participants table, and have it write the name or ID to a user specific column in the screen’s table. Then your action will see the choice value.

---

<div class="post-metadata">

**Author:** ![jsg0813](https://avatars.discourse-cdn.com/v4/letter/j/9dc877/32.png) [@jsg0813](https://community.glideapps.com/u/jsg0813)\
**Post date:** [March 2, 2023, 9:29pm UTC](https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653/3 "2023-03-02T21:29:36Z")

</div>

Thanks, Jeff!

I will give this a try today.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 3, 2023, 9:30pm UTC](https://community.glideapps.com/t/add-a-row-from-separate-data-table/58653/4 "2023-03-03T21:30:10Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.