# Automatically created concatenating column doesn't update

**URL:** <https://community.glideapps.com/t/automatically-created-concatenating-column-doesnt-update/1296>\
**Category:** Report a Bug\
**Created:** [October 21, 2019, 12:06am UTC](https://community.glideapps.com/t/automatically-created-concatenating-column-doesnt-update/1296 "2019-10-21T00:06:14Z")\
**Posts on this page:** 1\
**Showing post:** 15

<div class="post-metadata">

**Author:** ![filipa](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/filipa/32/190_2.png) [@filipa](https://community.glideapps.com/u/filipa)\
**Post date:** [October 21, 2019, 10:51am UTC](https://community.glideapps.com/t/automatically-created-concatenating-column-doesnt-update/1296/15 "2019-10-21T10:51:34Z")

</div>

@Lighted_Candle, thank you! The problem is: in the New Products sheet, each book has a Category column where up to 5 categories per book can show up, separated by commas. There’s then 5 columns - Category 1-5 - with a formula to split those categories.  
So, each category relation column in the Users Preferences sheet would have to relate to each of the 5 Category column in New Products. I can’t understand how to do this…

I had opened a new post for this: [How to filter by signed-in user - Glide doesn't show automatically created Users relation column](https://community.glideapps.com/t/how-to-filter-by-signed-in-user-glide-doesnt-show-automatically-created-users-relation-column/1307)

My app: [https://t3wff.glideapp.io](https://t3wff.glideapp.io/)  
Google sheet: [https://docs.google.com/spreadsheets/d/1NDPEhQztlho\_V22qSpUgm4U29Oay6A9mDewBfR3H3ec/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1NDPEhQztlho_V22qSpUgm4U29Oay6A9mDewBfR3H3ec/edit?usp=sharing)

Thanks!

---

_[View the full topic](https://community.glideapps.com/t/automatically-created-concatenating-column-doesnt-update/1296)._