# Displaying user email in data sheet after he/she submitted a form

**URL:** <https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486>\
**Category:** Ask for Help\
**Created:** [September 7, 2021, 10:55am UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486 "2021-09-07T10:55:06Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Titou\_Friendly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/titou_friendly/32/19682_2.png) [@Titou\_Friendly](https://community.glideapps.com/u/Titou_Friendly)\
**Post date:** [September 7, 2021, 10:55am UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/1 "2021-09-07T10:55:06Z")

</div>

Hello everyone ! I was wondering if someone knows how to display the user email that submitted a form in the app in my principle data sheet.

For example in the case of a restaurant inscription form. I would like to display in my data sheet in a column the user-email who completed the form.

Sheet 1 (restaurant inscription form)

 ![Capture d’écran 2021-09-07 à 15.03.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad83ab6de1cd2f480c626808adeedf2108f48350.png)

Sheet 2 (users sheet)  
 ![Capture d’écran 2021-09-07 à 15.03.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e52906f06c58403334fa85d8e6fe3558bf254677.png)

Anyone have any ideas how to go by this ?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 7, 2021, 11:43am UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/2 "2021-09-07T11:43:55Z")

</div>

You mean when user A submits a form, then the email of user A should be submitted alongside the form?

You can use the special value “user’s email address” to pass to an “email” column in the destination sheet.

---

<div class="post-metadata">

**Author:** ![Titou\_Friendly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/titou_friendly/32/19682_2.png) [@Titou\_Friendly](https://community.glideapps.com/u/Titou_Friendly)\
**Post date:** [September 7, 2021, 1:06pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/3 "2021-09-07T13:06:23Z")

</div>

Sheet 1 (restaurant inscription form)

 ![Capture d’écran 2021-09-07 à 15.03.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad83ab6de1cd2f480c626808adeedf2108f48350.png)

Sheet2 (user data form)  
 ![Capture d’écran 2021-09-07 à 15.03.25](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e52906f06c58403334fa85d8e6fe3558bf254677.png)

So, the idea is to be able to display in the backend the users who completed the restaurant inscription form. How can I do so?

---

<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:** [September 7, 2021, 1:16pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/4 "2021-09-07T13:16:45Z")

</div>

Maybe I’m misunderstanding the question. Your screenshot shows that you already have an email in your sheet. Like @ThinhDinh mentioned, you can add the email special value into the form so it’s automatically included in the sheet when the user submits the form.

---

<div class="post-metadata">

**Author:** ![Titou\_Friendly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/titou_friendly/32/19682_2.png) [@Titou\_Friendly](https://community.glideapps.com/u/Titou_Friendly)\
**Post date:** [September 7, 2021, 1:17pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/5 "2021-09-07T13:17:48Z")

</div>

Sorry…What is highlighted in yellow is what I would like to achieve…At the moment I don’t know how to have the email appear…

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 7, 2021, 1:20pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/6 "2021-09-07T13:20:07Z")

</div>

What @ThinhDinh and @Jeff_Hager said previously…add the “Special Column” \> “Users Email Address” to the list of form components

---

<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:** [September 7, 2021, 1:20pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/7 "2021-09-07T13:20:14Z")

</div>

Have you tried adding the email special value component to the form?

The documentation is showing the old version of glide, but the concept is the same. Just add the component like you would add any other component to the form.

> **[Special Values](https://docs.glideapps.com/all/reference/values/special-values)**

---

<div class="post-metadata">

**Author:** ![Titou\_Friendly](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/titou_friendly/32/19682_2.png) [@Titou\_Friendly](https://community.glideapps.com/u/Titou_Friendly)\
**Post date:** [September 7, 2021, 1:26pm UTC](https://community.glideapps.com/t/displaying-user-email-in-data-sheet-after-he-she-submitted-a-form/31486/8 "2021-09-07T13:26:53Z")

</div>

Thank you @Jeff_Hager and @Robert_Petitto it works ! God bless !
