# Is there a way to set Column value when user changes items in choice component?
**URL:** https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419
**Category:** Ask for Help
**Created:** [June 27, 2024, 8:59am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419 "2024-06-27T08:59:22Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [June 27, 2024, 8:59am UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/1 "2024-06-27T08:59:22Z")
Hi Guys,
I have a choice component for every row items. I have multiple items like Submitted, Posted, Live, Sent . I have a requirement where I need to have a count of how many items have had the stage Submitted and Posted.
Point to note is after The states keep changing so I dont think I can use query and rollup combination to have the count.
Is there a way to set a particular column value when user selects the choice options?
Thank you in advance.
Regards,
Dilip
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 27, 2024, 2:18pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/2 "2024-06-27T14:18:23Z")
You should convert those to buttons so you can use a set column action accordingly when the status is changed.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [June 27, 2024, 2:30pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/3 "2024-06-27T14:30:09Z")
Hi @ThinhDinh ,
Thank you for replying. But since my choice component resides inside the column
I’ll need to have 4 columns for 4 choice options
Am I correct ? Or is there any other way of doing it ?
Regards,
Dilip
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [June 27, 2024, 2:49pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/4 "2024-06-27T14:49:27Z")
any way can we use Glide API, or any other solution.?
Regards,
Dilip
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [June 27, 2024, 2:54pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/5 "2024-06-27T14:54:38Z")
> [@Dilip\_Adiga](#):
>
> I have a requirement where I need to have a count of how many items have had the stage Submitted and Posted.
It sounds like you don’t need a set column action. You could try adding a relation from the status column to itself. Then do a rollup via that relation.
Edit: I guess that will only count active statuses. If you need a counter then it should be a button
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [June 27, 2024, 3:08pm UTC](https://community.glideapps.com/t/is-there-a-way-to-set-column-value-when-user-changes-items-in-choice-component/74419/6 "2024-06-27T15:08:30Z")
Hi Eric,
Thank you for your reply.
> [@Eric\_Penn](#):
>
> It sounds like you don’t need a set column action. You could try adding a relation from the status column to itself. Then do a rollup via that relation.
I am not sure this will work because
Scenario: I first choose Submitted as my choice option.
It registers a single relation
Now when I change the status to Posted for same element it looses the relation previously held and count will reduce right?
Meaning it will only show the count for the time the status for the record is either Submitted to Posted. When it changes the number also changes.
Let me know if I am making sense
Regards,
Dilip