# The choice component and data table don't match

**URL:** <https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516>\
**Category:** Ask for Help\
**Created:** [August 8, 2024, 10:44am UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516 "2024-08-08T10:44:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\
**Post date:** [August 8, 2024, 10:44am UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/1 "2024-08-08T10:44:04Z")

</div>

For some reason, what I select in the choice component does not match the input in the data table.  
These are the options to choose from. A number from 1 to 5

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

Based on the Week number selection table

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1d01f3556164e968fa83093dd5f979771d3740c3.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/d/bd04679568890bbfc1dda6d92cbd74d6c430b626.png)

Does anyone have an idea how I end up with these numbers in the table?

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

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 8, 2024, 10:59am UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/2 "2024-08-08T10:59:19Z")

</div>

You are writing the RowID value into a number column:

 ![CleanShot 2024-08-08 at 18.58.16@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/b/8bb28d16d7f5a5f568ea274756dcdcb92cb28bdb.png)

Change that to use the Week Number instead.

---

<div class="post-metadata">

**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\
**Post date:** [August 8, 2024, 11:05am UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/3 "2024-08-08T11:05:12Z")

</div>

That works!

Thank you! I understood it to be better practice to use the rowID in a selection table so that should I need to change the options, the rowID remains constant.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 8, 2024, 11:32am UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/4 "2024-08-08T11:32:15Z")

</div>

Well, yes. That is a good general rule of thumb.

But if you did that you would then need to add two extra columns.  
First, a single relation column that matches the RowID value with the same value in the Week Number table, and then a lookup column to fetch the Week Number value.

But in this case where you are dealing with a short list of numbers that will probably never change, I’d argue that’s a bit of overkill.

---

<div class="post-metadata">

**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\
**Post date:** [August 8, 2024, 3:50pm UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/5 "2024-08-08T15:50:34Z")

</div>

Great point! Much appreciated.

---

<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:** [August 15, 2024, 3:51pm UTC](https://community.glideapps.com/t/the-choice-component-and-data-table-dont-match/75516/6 "2024-08-15T15:51:19Z")

</div>

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