# Need Help : Choice Component not syncing to database

**URL:** <https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383>\
**Category:** Report a Bug\
**Created:** [February 8, 2021, 2:06am UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383 "2021-02-08T02:06:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [February 8, 2021, 2:06am UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383/1 "2021-02-08T02:06:53Z")

</div>

Hi,

As pictures below, its work when i am using the preview one.  
But when I am using the **android or iOS,** it is **not** updated the database.  
So that, the charts also not updated.

Here is the link : [https://awful-ants-8702.glideapp.io/](https://awful-ants-8702.glideapp.io/)

 ![Picture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/9935d024721674ecd0febab72f342597948ef488.jpeg) ![Picture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f3100fdfe5924583caf913a31f8abe368311e43.jpeg) ![Picture3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a13a88b205e6d02968c65b77d70879e8b05a7720.jpeg) ![Picture4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/d/5d895e3a7ce26e214b3cf5a5497e241bd74ab05e.jpeg)

---

<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 8, 2021, 12:30pm UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383/2 "2021-02-08T12:30:03Z")

</div>

Can you provide more information? What’s suppose to make the chart change? What is supposed to be controlled by changing the choice?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [February 9, 2021, 1:06am UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383/3 "2021-02-09T01:06:18Z")

</div>

Hi,

Thank you for replying.  
At layout , if I change the choice component .  
Its work.  
the database updated.

If i choose “Machine”  
The first chart updated.  
and also updated at googlesheet.

 ![Picture1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/9935d024721674ecd0febab72f342597948ef488.jpeg)  
 ![Picture5](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c735089be42c1ecd9276eac287651dd437fac76.jpeg)

If I choose “Rental”  
The chart and database updated.

 ![Picture3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5a1940a7d5803840249c79bc2d81642f3d68c1ea.jpeg)  
 ![Picture6](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9a276a9ada5c642346c12da469a3292a46ae504.jpeg)

But when I am using apps in android or iOS. it is **not** captured.

---

<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 9, 2021, 1:29am UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383/4 "2021-02-09T01:29:34Z")

</div>

So it is google sheet formulas that make the numbers change? I realize that changing the choice makes the numbers change, but I’m trying to understand how that happens. My only thought right now, based on your screenshots, is that there might be a problem with the ’ \* ’ in your column heading. Can you try removing the ’ \* ’ to see what happens?

---

<div class="post-metadata">

**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\
**Post date:** [February 9, 2021, 1:48am UTC](https://community.glideapps.com/t/need-help-choice-component-not-syncing-to-database/22383/5 "2021-02-09T01:48:19Z")

</div>

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

I have change the “Sales Type \*” to " Sales Type First" .  
The apps not captured. The layout captured.

If you need the link to review there you go.

> **[Sales Tracking](https://awful-ants-8702.glideapp.io/)**
>
> Purposely for Sales Tracking