# Username column **URL:** \ **Category:** Ask for Help\ **Created:** [February 9, 2021, 12:25pm UTC](https://community.glideapps.com/t/username-column/22481 "2021-02-09T12:25:17Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![hayate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hayate/32/20159_2.png) [@hayate](https://community.glideapps.com/u/hayate)\ **Post date:** [February 9, 2021, 12:25pm UTC](https://community.glideapps.com/t/username-column/22481/1 "2021-02-09T12:25:17Z")
I was trying to add username automatically on posts sheet based on user profile sheet. But the username added on posts sheet is not matched properly. ![スクリーンショット 2021-02-09 21.23.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/694f57cf699379da720090001d960592037516d2.png) ![スクリーンショット 2021-02-09 21.24.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2ea9874fa34f3e8fc94675d01f5a03f8fedd6bf2.png) ---
**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:** [February 9, 2021, 12:28pm UTC](https://community.glideapps.com/t/username-column/22481/2 "2021-02-09T12:28:58Z")
Are you trying to do this in Glide, or using spreadsheet formulas? The usual way in Glide is to create a relation between the two tables (probably using email address as the key), and then use Lookup columns to fetch those values you need to use in your Posts sheet. ---
**Author:** ![hayate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hayate/32/20159_2.png) [@hayate](https://community.glideapps.com/u/hayate)\ **Post date:** [February 9, 2021, 12:34pm UTC](https://community.glideapps.com/t/username-column/22481/3 "2021-02-09T12:34:08Z")
on Glide. Yes. I made a relation but it didn’t work… ---
**Author:** ![hayate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hayate/32/20159_2.png) [@hayate](https://community.glideapps.com/u/hayate)\ **Post date:** [February 9, 2021, 12:35pm UTC](https://community.glideapps.com/t/username-column/22481/4 "2021-02-09T12:35:13Z")
I checked replacements again and i found i chose wrong replacement… Thank you! ---
**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:** [February 9, 2021, 12:35pm UTC](https://community.glideapps.com/t/username-column/22481/5 "2021-02-09T12:35:14Z")
Please show screenshots of your Relation Column configuration, and your Lookup Column configuration. ---
**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:** [February 9, 2021, 12:39pm UTC](https://community.glideapps.com/t/username-column/22481/6 "2021-02-09T12:39:49Z")
ah, yes… I just noticed that username column in your Posts sheet. If that was a Lookup, you wouldn’t see it there. So are you populating that with an Add Row action? That’s probably not the best idea… if one of your users changes their name, that won’t update. It’s better to keep that in Glide and use a lookup from your users table. ---
**Author:** ![hayate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hayate/32/20159_2.png) [@hayate](https://community.glideapps.com/u/hayate)\ **Post date:** [February 9, 2021, 12:43pm UTC](https://community.glideapps.com/t/username-column/22481/7 "2021-02-09T12:43:34Z")
![スクリーンショット 2021-02-09 21.42.14](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20e239fe1106eb01dcf8e03ec106cbdbffbd2fab.jpeg) ![スクリーンショット 2021-02-09 21.42.26](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e51047fa8ce7683eb3029e893ac27af655e044cd.jpeg) Is this a correct way of showing items?? ---
**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:** [February 9, 2021, 12:47pm UTC](https://community.glideapps.com/t/username-column/22481/8 "2021-02-09T12:47:36Z")
There is no single correct way. What you have there looks fine 👍 ---
**Author:** ![hayate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hayate/32/20159_2.png) [@hayate](https://community.glideapps.com/u/hayate)\ **Post date:** [February 9, 2021, 1:23pm UTC](https://community.glideapps.com/t/username-column/22481/9 "2021-02-09T13:23:36Z")
Thank you !