# BUG: Choice Value doesn't write to data table nor sheet if screen is no longer filtered by signed in user

**URL:** <https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937>\
**Category:** Report a Bug\
**Created:** [July 3, 2020, 11:46pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937 "2020-07-03T23:46:06Z")\
**Posts on this page:** 7\
**Page:** 1

<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:** [July 3, 2020, 11:46pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/1 "2020-07-03T23:46:06Z")

</div>

My app’s URL: [https://go.glideapps.com/app/LKaQTUG3pXNscBtcRE8T](https://go.glideapps.com/app/LKaQTUG3pXNscBtcRE8T)

@Mark—here’s a fun one for you.

The title for this post is long…sorry. Here’s the context:

1. Replicate a shopping cart experience without using Glides built-in cart functionality.
2. Two-factor checkout process  
– using buttons that increment and decrease value to show and hide themselves.  
– using a choice component to show “Complete order” but write “New” in the order status column
3. When a new value enters the “Status” column, an if-then column no longer displays the user’s email address
4. The cart tab in my app is being filtered by this if then column being assigned in user so that the only cart items displayed are ones that haven’t been checked out

My logic is sound and everything seems to work except that when I add this layer of filtering the tab by that “if-then signed-in user” column, the choice component never writes the “new” value to the “status column”. It WILL write the new value to the status column if I don’t filter the tab by that “if-then signed-in user” column. Oddly, although the value doesn’t get written to the status column, the logic still works and the tab clears itself. It’s almost as though the filtering by signed-in user breaks the writing of that new value to both the sheet and datatable.

---

<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:** [July 4, 2020, 12:03am UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/3 "2020-07-04T00:03:56Z")

</div>

@Mark: sent video in private message.

---

<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:** [July 4, 2020, 12:10am UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/4 "2020-07-04T00:10:51Z")

</div>

What must be happening is that the screen no longer is filtered by signed in user BEFORE it attempts to write the choice component to the row which means that the app doesn’t know to which row to write the value.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 4, 2020, 2:52pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/5 "2020-07-04T14:52:06Z")

</div>

I can reproduce it. Will fix. Thank you so much for reporting it!

PS: Neat trick with the Choice!

---

<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:** [July 4, 2020, 3:46pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/6 "2020-07-04T15:46:34Z")

</div>

Thanks Mark for the attention! Ya, the choice component allowEd me to write to the sheet without submitting a form… I wanted the satisfaction of pushing a button.

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [July 4, 2020, 10:06pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/7 "2020-07-04T22:06:51Z")

</div>

This will be fixed by Wednesday.

---

<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:** [July 4, 2020, 10:19pm UTC](https://community.glideapps.com/t/bug-choice-value-doesnt-write-to-data-table-nor-sheet-if-screen-is-no-longer-filtered-by-signed-in-user/11937/8 "2020-07-04T22:19:52Z")

</div>

Appreciate the communication!
