# Data access

**URL:** <https://community.glideapps.com/t/data-access/57783>\
**Category:** Ask for Help\
**Created:** [February 11, 2023, 12:52am UTC](https://community.glideapps.com/t/data-access/57783 "2023-02-11T00:52:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\
**Post date:** [February 11, 2023, 12:52am UTC](https://community.glideapps.com/t/data-access/57783/1 "2023-02-11T00:52:49Z")

</div>

I have a choice in my home screen to select the green number and would like to use the corresponding green times in a calculation in my home table. Is this possible? TIA!

 ![2023-02-10 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9e834c6f2a3ec40853753b740427f9f032bfe1a.jpeg)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 11, 2023, 1:20am UTC](https://community.glideapps.com/t/data-access/57783/2 "2023-02-11T01:20:35Z")

</div>

You can select a column for the value of your choice component and a different value for the “Display as” portion. Is this what you’re looking for?

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

---

<div class="post-metadata">

**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\
**Post date:** [February 11, 2023, 4:45am UTC](https://community.glideapps.com/t/data-access/57783/3 "2023-02-11T04:45:11Z")

</div>

![2023-02-10 (2)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/7/e736e14f720d0b372ee1a87f5019b96c74121461.jpeg)

Under my configuration for Ontime, I would like to add the selected t (T Time) and the corresponding green time based on the green selection. For example, if 7:20 was selected as the T time and green 2 selected, I’d like to add t + 30…hope this explains what I’m trying to do! 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:** [February 11, 2023, 5:04am UTC](https://community.glideapps.com/t/data-access/57783/4 "2023-02-11T05:04:23Z")

</div>

Well, you can do as @kyleheney suggested and set up your choice component so it displays the green number in the list of choices, but writes the green time to the table instead.

Or you can keep writing the green number, but create a single relation column that links the green number to the green number in your choice table, followed by a lookup column that retrieves the green time from the relation.

---

<div class="post-metadata">

**Author:** ![rloo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rloo/32/54195_2.png) [@rloo](https://community.glideapps.com/u/rloo)\
**Post date:** [February 11, 2023, 1:34pm UTC](https://community.glideapps.com/t/data-access/57783/5 "2023-02-11T13:34:38Z")

</div>

Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 12, 2023, 1:35pm UTC](https://community.glideapps.com/t/data-access/57783/6 "2023-02-12T13:35:25Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.