# Sending multiple data from the same column to be shown in a template column
**URL:** https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313
**Category:** Ask for Help
**Created:** [May 31, 2023, 11:05am UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313 "2023-05-31T11:05:22Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@AbdulGhafor\_abbas](https://community.glideapps.com/u/AbdulGhafor_abbas)
#### Post date: [May 31, 2023, 11:05am UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/1 "2023-05-31T11:05:22Z")
Dear all, i have a simple database setup
i want to add a template column which includes the values for all categories respectively like this :
but unfortunately, i cannot do that, each time i select category values it selects each column separately, and i only want one version of the template column and it should not be repeating for every row. i want to do this to send this template to chatgpt using the integration (message without history) to return some results.
note : i don’t want to use ask a question about table as it uses a different data model than chat-gpt 3.5 that is being used in messages with and without history
any help?
thanks
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 31, 2023, 11:23am UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/2 "2023-05-31T11:23:27Z")
You could do it as follows:
- Start with a Lookup column that targets your Name column. This will give you an array of categories.
- Then add 3 Single Value columns. Each of these should target your Lookup column and take 0 from Start, 1 from Start and 2 from Start respectively.
- You can then use those 3 Single Value columns in your Template.
---
### Author:  [@AbdulGhafor\_abbas](https://community.glideapps.com/u/AbdulGhafor_abbas)
#### Post date: [May 31, 2023, 11:53am UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/3 "2023-05-31T11:53:29Z")
It definitly worked, thank you very much, an iterations i had to do tho:
- these extra columns i added them to the users table and not categories, as the action editor reads the columns in user table only.
One Concern tho,
this solution will not work if each user have a different number of categories. is there any solution that is more dynamic?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 31, 2023, 4:30pm UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/4 "2023-05-31T16:30:25Z")
An alternative is to build a template column that only contains a portion of the text relative to each row, and then use a joined list column to merge them all together.
---
### Author:  [@AbdulGhafor\_abbas](https://community.glideapps.com/u/AbdulGhafor_abbas)
#### Post date: [May 31, 2023, 7:07pm UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/5 "2023-05-31T19:07:01Z")
I will gove it a try, but i don’t think i can pass this column to a chatgpt api message.
I will try it tho
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 31, 2023, 7:40pm UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/6 "2023-05-31T19:40:25Z")
Joined List is just a normal text string, so I would think it should work just fine.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [June 1, 2023, 7:40pm UTC](https://community.glideapps.com/t/sending-multiple-data-from-the-same-column-to-be-shown-in-a-template-column/62313/7 "2023-06-01T19:40:59Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.