# How to read results from JSON Template columns in a JS column

**URL:** <https://community.glideapps.com/t/how-to-read-results-from-json-template-columns-in-a-js-column/84993>\
**Category:** Ask for Help\
**Created:** [October 20, 2025, 5:56am UTC](https://community.glideapps.com/t/how-to-read-results-from-json-template-columns-in-a-js-column/84993 "2025-10-20T05:56:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dpschramm](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@dpschramm](https://community.glideapps.com/u/dpschramm)\
**Post date:** [October 20, 2025, 5:56am UTC](https://community.glideapps.com/t/how-to-read-results-from-json-template-columns-in-a-js-column/84993/1 "2025-10-20T05:56:58Z")

</div>

I have a JSON template column with the following settings:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/4/14d422371bbcf254b04543ed60be62615014e46a.png)

The $SITE and $ACTION properties are both JSON Object columns, but the $HOURS and $MATERIALS columns are lookup columns that contain multiple JSON Objects.

The output of this JSON Template column is something like:

`[`  
` {`  
` “ItemCode”: “SiteVisit”,`  
` “Description”: “Site Visit Fee - 22/9/25”,`  
` “Quantity”: 1`  
` },`  
` {`  
` “ItemCode”: “100-Harry”,`  
` “Description”: “Labour p/hr - Harry - 11:00am - 1:45pm = 2.75hrs”,`  
` “Quantity”: 2.75`  
` },`  
` {`  
` “Description”: “Lawns: Sprayed lawns. Weeds\n\nGardens: Hedge, Prune, Tip-Prune, Clipped, Cut. Hedges\n\nHard surface: Sprayed Weeds.\n\nOther: Left cuttings in garden beds for client”`  
` },`  
` {`  
` “ItemCode”: “GM-Roundup”,`  
` “Quantity”: 0.5`  
` }`  
`]`

However, when I try to read this column in a JavaScript column, I’m getting “undefined”:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f314860e1a2eba2e4a3416534e38dbddb58c05e.png)

`{“type”:“undefined”,“isNull”:false,“isUndefined”:true,“isEmpty”:false}`

Is this working as expected? Is there anything special I need to do to access the JSON Template column from a JS column?

---

<div class="post-metadata">

**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:** [October 20, 2025, 6:01am UTC](https://community.glideapps.com/t/how-to-read-results-from-json-template-columns-in-a-js-column/84993/2 "2025-10-20T06:01:27Z")

</div>

You are passing JSON to the JavaScript column, so you need to parse that first. ie. with `JSON.parse(p1)`.