# How do i present calculations that were performed in a user specific column in sheets?

**URL:** <https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153>\
**Category:** Ask for Help\
**Created:** [January 26, 2023, 10:27pm UTC](https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153 "2023-01-26T22:27:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Assassin582](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/assassin582/32/53448_2.png) [@Assassin582](https://community.glideapps.com/u/Assassin582)\
**Post date:** [January 26, 2023, 10:27pm UTC](https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153/1 "2023-01-26T22:27:53Z")

</div>

hey there, im making an app for a while for my group to use for competitions to collect data on the other groups, basically i have a form and you are able to choose the name of the group and i want it to match automatically to a group number (in our teams we have a name and group number like Something#5555) any ideas on how to do it? and how do i make the data i collected show up on google sheets? Thanks.

---

<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:** [January 26, 2023, 10:41pm UTC](https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153/3 "2023-01-26T22:41:16Z")

</div>

I’m not sure I completely follow your questions. You may need to provide more information. I can only give general advice without knowing more about your app.

> [@Assassin582](#):
>
> i have a form and you are able to choose the name of the group and i want it to match automatically to a group number

If you have a table with group names and group numbers…and if you are using a choice component (sourced from that table) to select a group, you can configure the choice component to display names, but actually write the group number instead to the table.

> [@Assassin582](#):
>
> how do i make the data i collected show up on google sheets?

User specific columns are internal to glide. If you need that data in a google sheet, It might be better to not use user specific columns.

---

<div class="post-metadata">

**Author:** ![Assassin582](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/assassin582/32/53448_2.png) [@Assassin582](https://community.glideapps.com/u/Assassin582)\
**Post date:** [January 26, 2023, 10:46pm UTC](https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153/4 "2023-01-26T22:46:57Z")

</div>

hm. is there any way to shorten the time it will take to write the number? cuz the number can range from 4 to 8 digits and we are very limited in time. like maybe fill options like when u enter something in the google seach bar?

---

<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:** [January 26, 2023, 11:42pm UTC](https://community.glideapps.com/t/how-do-i-present-calculations-that-were-performed-in-a-user-specific-column-in-sheets/57153/5 "2023-01-26T23:42:58Z")

</div>

Still not following. Are you talking about choosing a group? With a choice component, you open up the list of choices, choose the group you want, and then you’re done.

Screenshots would help out a lot here to see what you are working with and what you are trying to achieve.