# Template column only concatenate first row

**URL:** https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362
**Category:** Ask for Help
**Created:** [December 26, 2021, 8:33pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362 "2021-12-26T20:33:05Z")
**Posts on this page:** 17
**Page:** 1

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 8:33pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/1 "2021-12-26T20:33:05Z")

</div>

Template column only concatenate in first row and repeat the same infos for the rest of the rows. Am I missing something or is it a bug?

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 8:43pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/2 "2021-12-26T20:43:54Z")

</div>

maybe you did not put the right variable… do you have a screenshot?

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 9:25pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/3 "2021-12-26T21:25:25Z")

</div>

yes

 ![Capture d’écran (207)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/be4da9821d3076310fa6b0b8b3330da414f12007.png)  
 ![Capture d’écran (208)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/c/2cf7d75560960b6562a5e832457956535c92e028.png)

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 9:32pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/4 "2021-12-26T21:32:59Z")

</div>

you used user profile data, that’s why is populating from a row of signed-in user…  
to do for the corresponding rows, use the direct sheet, not user-specific

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 9:42pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/5 "2021-12-26T21:42:16Z")

</div>

> [@Uzo](#):
>
> use the direct sheet

Ok, but what do you mean by direct sheet?

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 9:43pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/6 "2021-12-26T21:43:33Z")

</div>

do not pick the data from user profile

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 9:51pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/7 "2021-12-26T21:51:33Z")

</div>

Ok, Should l create maybe another table for users?

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 9:52pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/8 "2021-12-26T21:52:56Z")

</div>

no, change the sources in the template

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 10:00pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/9 "2021-12-26T22:00:23Z")

</div>

Ok. But all the five columns (name, surname…) are coming from a form registered in user profile…

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 10:03pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/10 "2021-12-26T22:03:58Z")

</div>

yes, but you are already on the

 ![Screen Shot 2021-12-26 at 5.01.58 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a835474cea22f33915e9c6aa033a6bfc61bb902.png)  
user profile sheet, so don’t take it from user profile data… pick from below it

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 10:24pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/11 "2021-12-26T22:24:55Z")

</div>

Thank you but I don’t get. I will try tomorrow 🤔

---

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 26, 2021, 10:29pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/12 "2021-12-26T22:29:50Z")

</div>

in the template, do not use User Profile \> … use tabs below that, because it will take only data from the row where the sign-in user has he’s email

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 10:44pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/13 "2021-12-26T22:44:31Z")

</div>

In the screenshot that you sent, are you on the user profiles table ?

---

<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: [December 26, 2021, 10:59pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/14 "2021-12-26T22:59:43Z")

</div>

When you select replacement values for your template column, you can choose columns from the user profile row of the current signed in user, or you can choose columns from the current table. You are choosing columns from the signed in user’s profile row. You should instead be choosing columns from the current table instead. In the drowndown, select any of the columns that are below the ‘User Profile’. Don’t select ‘User Profile’, unless you want to have the same values on all rows of the current table from only the signed in user’s profile row.

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 26, 2021, 11:11pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/15 "2021-12-26T23:11:20Z")

</div>

I understood well. But when I expand the list, the infos I want to concatenate are not there. I can only find them in user’s profile. It seems essential to me to be able to have in a single line the first name, the last name, the address of the user, the postal code, the city the country that the user will have entered in a form from his profile page.

 ![Capture d’écran (209)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e99404b2c9772652e7790ad7159ebf4d8026938.png)

The table I am on IS the user’s profile table.

---

<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: [December 26, 2021, 11:25pm UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/16 "2021-12-26T23:25:45Z")

</div>

If you want values from the user profile, then that shouldn’t be a problem. Yes it will show the same values on all lines, but what populates in the template columns will be different depending on which user is signed in.

However, if you do want to see different values in each row, you will need to create a relation column to link something like an email or user I’d in the current table, to the email or user id in the user table. Then you will need lookup columns to pull in each column from the relation to the current table. Then you can built your template against those lookup columns.

Whenever you use the User Profile option, like you showed above, it will ALWAYS return values from user profile of the current signed in user.

The confusing thing is that you appear to be within a user profile table. Is that the same table that your user profiles function is linked to?

---

<div class="post-metadata">

### Author: ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)
#### Post date: [December 27, 2021, 12:38am UTC](https://community.glideapps.com/t/template-column-only-concatenate-first-row/36362/17 "2021-12-27T00:38:31Z")

</div>

Yes it is the sa me table.  
I think I understood what you explained. Tomorrow (it’s very late now :)) I’ll try to build all of this.
