# Collect data automatically

**URL:** <https://community.glideapps.com/t/collect-data-automatically/41444>\
**Category:** Ask for Help\
**Created:** [April 30, 2022, 6:53am UTC](https://community.glideapps.com/t/collect-data-automatically/41444 "2022-04-30T06:53:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![GK123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gk123/32/40613_2.png) [@GK123](https://community.glideapps.com/u/GK123)\
**Post date:** [April 30, 2022, 6:53am UTC](https://community.glideapps.com/t/collect-data-automatically/41444/1 "2022-04-30T06:53:11Z")

</div>

Hi.  
I have 2 tables (based on Google sheets).

1)is users sheet. With name and email for each user.  
2) tasks sheet. With data and information about each task.

I want to create this flow:  
1)User create new task (easy, I know how to do it).  
2) while creating the task, the user chooses relevant owner from the users table (based on the user name). (Easy, I know how to do it).  
3) the name of the relevant user (the owner) _and the email_ save in the tasks sheet, in two different columns.( I don’t know how to do it).

For example, Jim create new task for Jack.  
Jom will choose the name of Jack while creating a new task.  
On the tasks sheet, the name would be saved on the “owner” column, and Jack’s email would be saved on the “owners email” (without anyone will choose the email manually).

Any ideas?

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [April 30, 2022, 8:47am UTC](https://community.glideapps.com/t/collect-data-automatically/41444/2 "2022-04-30T08:47:31Z")

</div>

Hi Gilad,

You can have a Choice component on the form screen and select the Users Table and connect the **owners email column** in the Tasks table to the Write to column section.

And for the value in the choice component you can select the **Email column** in the Users table and for the Display section you can select the **Name column** in the Users table.

And in the form screen you can add the **User’s email special value** and add the **owner column** in the Tasks table to add the task creater!

Thank you

---

<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:** [April 30, 2022, 3:18pm UTC](https://community.glideapps.com/t/collect-data-automatically/41444/3 "2022-04-30T15:18:41Z")

</div>

Also, if you follow @Dilon_Perera’s advice and only save the email to the table, then you can use a relation column and lookup column to retrieve the user’s name from the saved email.