# How to add a row in a table with one property coming from the parent/screen page

**URL:** <https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530>\
**Category:** Ask for Help\
**Created:** [October 12, 2022, 7:30am UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530 "2022-10-12T07:30:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![loicbm](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@loicbm](https://community.glideapps.com/u/loicbm)\
**Post date:** [October 12, 2022, 7:30am UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/1 "2022-10-12T07:30:17Z")

</div>

Hi there !

We are using Glide for the first time and are loving it. Still, we are facing an issue that is blocking us.

Imagine you have a projects database. In these projects, we have always tasks that are similar; thus we have a tasks database.

For each project, we’d like to chose which tasks to add : we created a correspondence table ProjectsxTasks (projet\_id, task\_id).

Here’s our issue : inside a specific project page, we have our list of tasks with action buttons to add a row in the ProjectsxTasks table. When we configure the action, we are not able to select the challenge\_id of the page :  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a33d1e574771be92a2c07fdd720c6d87fa3b9dbf.png)

Do you have any workaround ? Should we do it differently ?

Thank you in advance 🙂

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2022, 8:29am UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/2 "2022-10-12T08:29:33Z")

</div>

> [@loicbm](#):
>
> Here’s our issue : inside a specific project page, we have our list of tasks with action buttons to add a row in the ProjectsxTasks table. When we configure the action, we are not able to select the challenge\_id of the page :

You’re probably approaching this the wrong way. Rather than showing a list of tasks on your Project Details page, here is what I would suggest:

- Add a button, and label it as “Add Task”
- Set the action on the button as Show Form Screen
- Configure the Form to add a row to your ProjectsxTasks table
- Add a choice component, set the source as your Tasks table
- Add a [Screen Values](https://www.glideapps.com/docs/reference/values/screen-values) component, select the ProjectID and target it at your task\_id column

---

<div class="post-metadata">

**Author:** ![loicbm](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@loicbm](https://community.glideapps.com/u/loicbm)\
**Post date:** [October 12, 2022, 11:27am UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/3 "2022-10-12T11:27:17Z")

</div>

Thanks Darren for your answer 🙂

I can do that, but it means that I can only add tasks one by one, right ? It seems there is no multiple choices in form screen ? For each project, we can have like 20-30 tasks; what do you think ? Thanks.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2022, 11:48am UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/4 "2022-10-12T11:48:12Z")

</div>

Depends how you want to store them.  
Instead of having a separate ProjectsxTasks table, what you could do is add a RelatedTasks column to your Projects table. And store a comma separated list of TaskID’s in that column. If you enable multi-select on your Tasks Choice component, Glide will generate that list for you. And then you can get a list of related tasks for any Project by first using a Split Text column to turn the joined list into an array, and then use that to create a multiple relation to your Tasks table.

---

<div class="post-metadata">

**Author:** ![loicbm](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@loicbm](https://community.glideapps.com/u/loicbm)\
**Post date:** [October 12, 2022, 1:19pm UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/5 "2022-10-12T13:19:35Z")

</div>

Understood and implemented, thank you very much 🙂

The issue we see with this solution is that our tasks table is quite long and when we choose which tasks to add to a project, it’s pretty annoying to add actions in the form screen. We liked the fact to have it outside a form screen because we can have filters and groups on our tasks table. For exemple :

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

Is there a way to reproduce this behavior ?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2022, 1:27pm UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/6 "2022-10-12T13:27:11Z")

</div>

Well, yes. You could use the Trebuchet method. More work to set up, but probably closer to the behaviour that you’re looking for.

> [@dizzy The Trebuchet Method](https://community.glideapps.com/t/the-trebuchet-method/48325):
>
> In certain situations, a single column has the potential to replace an entire table of data. The Trebuchet Method allows you to create an inline array that allows you to create a SIMPLE one-to-many relationship between two sets of data without the need of a log or submissions table. Examples: Who owns which item Who has registered for an event Who has completed which task Pros: no app bloat no additional rows of data fairly easy to set up Cons: Can only track one data point (eg. who has w…

---

<div class="post-metadata">

**Author:** ![loicbm](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@loicbm](https://community.glideapps.com/u/loicbm)\
**Post date:** [October 12, 2022, 1:40pm UTC](https://community.glideapps.com/t/how-to-add-a-row-in-a-table-with-one-property-coming-from-the-parent-screen-page/51530/7 "2022-10-12T13:40:27Z")

</div>

Thanks Darren, I’ll check and try that tonight 🙂
