# Show email automatically in table

**URL:** <https://community.glideapps.com/t/show-email-automatically-in-table/33140>\
**Category:** Ask for Help\
**Created:** [October 16, 2021, 12:00pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140 "2021-10-16T12:00:46Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 16, 2021, 12:00pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/1 "2021-10-16T12:00:46Z")

</div>

I could not find in the docs nor in the forum the answer to this easy question:

How to show email of a user in my table or google sheet when he/she sends a form without showing him/her the email field ?

---

<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:** [October 16, 2021, 12:08pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/2 "2021-10-16T12:08:40Z")

</div>

Hi @jabid 👋 👋

In your form add a component in the special values section the User’s email address

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

and create a column ( Column type - Email) to store that user email and set that column to that special value(user’s email address). Then when a user submit something through the form you can see that user email in that created column.

Thank you 😊

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 16, 2021, 1:58pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/3 "2021-10-16T13:58:08Z")

</div>

Thank you ~@Dilon 🙂

---

<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:** [October 16, 2021, 2:01pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/4 "2021-10-16T14:01:51Z")

</div>

Your welcome @jabid 😊

And If this solves your question you can mark it as the solution 😇 😇

Thank you 😍

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 16, 2021, 2:14pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/5 "2021-10-16T14:14:04Z")

</div>

Yes. It is the solution 😀  
I noticed it does not work with users who register with Google Login.  
I guess l need to warn or even to prevent the sending of the form if the user did not register with the app own process.  
Am I wrong or is there another solution for that ?

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 16, 2021, 2:17pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/6 "2021-10-16T14:17:38Z")

</div>

Also, I noticed the emails are displayed only in the **@Owner Column** but the new Email Column remains empty. Is it normal?

---

<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:** [October 16, 2021, 2:19pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/7 "2021-10-16T14:19:11Z")

</div>

Can you send a screenshot? For the user’s email address did you choose the owner column?

---

<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:** [October 16, 2021, 2:21pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/8 "2021-10-16T14:21:21Z")

</div>

Hmm I also test this and something that a wrong email is storing.

Can anyone tell how to solve ?

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [October 16, 2021, 2:22pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/9 "2021-10-16T14:22:30Z")

</div>

Finally I found it (for second post) it seems I do not need to create a new column since when add user’s email component it takes @owner par default.

---

<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:** [October 16, 2021, 2:23pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/10 "2021-10-16T14:23:40Z")

</div>

Oh I see. I’m happy you have solved it 😊

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/show-email-automatically-in-table/33140/11 "2024-01-17T16:50:03Z")

</div>


