# Using the column heading as data entry **URL:** \ **Category:** Ask for Help\ **Created:** [September 2, 2021, 9:02am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261 "2021-09-02T09:02:44Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 9:02am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/1 "2021-09-02T09:02:44Z")
Looking to combine the column heading along side the associated row value to create a product list, which is then entered into a cell upon pushing button. This will be a summary of products ordered. Any help appreciated ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 2, 2021, 9:04am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/2 "2021-09-02T09:04:31Z")
You can’t use the column heading, but can reference it as fixed text using a template column. ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 9:27am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/3 "2021-09-02T09:27:33Z")
I see, so would i need to create a template for each column heading? ---
**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:** [September 2, 2021, 9:27am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/4 "2021-09-02T09:27:37Z")
you probably have the wrong data structure, if you are looking for this kind of solution… you should have a category of the product as a column, not a column title ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 9:35am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/5 "2021-09-02T09:35:04Z")
so that the product is displayed in the neighbouring cell to amount ordered? ---
**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:** [September 2, 2021, 9:37am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/6 "2021-09-02T09:37:46Z")
all properties and values that you wanna display… have to be in columns not in columns titles… so in your case… column title - products names… rows contain names of products column title - amount ordered… rows contain amounts of ordered products ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 9:41am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/7 "2021-09-02T09:41:56Z")
Thanks for your help on this! ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 9:45am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/8 "2021-09-02T09:45:52Z")
meant to ask, assuming i’ve set it up this way, do you have any suggestions on how to get this into a list that can populate a single cell? ---
**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:** [September 2, 2021, 9:48am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/9 "2021-09-02T09:48:12Z")
it depends on how your data is structured… you can use a single value column if you know where the value is… or create a filter to bring out that cell based on multiple criteria’s ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 10:05am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/10 "2021-09-02T10:05:33Z")
Looking to have it set up in row as Product 1 name - amount- £ , Product 2 name - amount - £, etc… What i would like to do is have an order summary cell in sheets that updates upon pressing a button displaying all product names and amounts where amount is populated. ``` **Order summary** ``` Product 1 name - amount Product 2 name - amount Thought initially set column value on button would work but can only assign one value to heading? ---
**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:** [September 2, 2021, 10:11am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/11 "2021-09-02T10:11:47Z")
wrong structuring! why you are into columns titles? columns titles are only for your convenient … have nothing to do with data… if you really need to depend values on columns titles… you can do that in Google sheets or scripts… not in Glide ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 10:24am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/12 "2021-09-02T10:24:08Z")
I may not be explaining this correctly. I wont be using the column titles, i would like to take the product name in row and quantity ordered to create a summary that i can use to populate a single cell in sheets. Is this possible? Thanks ---
**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:** [September 2, 2021, 10:31am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/13 "2021-09-02T10:31:37Z")
yes… use a template column to combine rows ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 2, 2021, 10:33am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/14 "2021-09-02T10:33:38Z")
Will give it a try, thanks for your help ---
**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:** [September 2, 2021, 11:07am UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/15 "2021-09-02T11:07:07Z")
You might also find the Joined List column useful for this. ---
**Author:** ![Siglide1110](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siglide1110/32/15991_2.png) [@Siglide1110](https://community.glideapps.com/u/Siglide1110)\ **Post date:** [September 7, 2021, 8:12pm UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/16 "2021-09-07T20:12:00Z")
If the cell being matched to the template is empty, I’m getting the cap letter text displayed instead. Is there a way to return nothing in template if the cell is empty? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 7, 2021, 11:30pm UTC](https://community.glideapps.com/t/using-the-column-heading-as-data-entry/31261/17 "2021-09-07T23:30:12Z")
What’s the “cap letter”? Do you mean the letter you use for the template? It should not happen, so can you share some screenshots of how you’re setting that up?