# Computed column - construct JSON

**URL:** <https://community.glideapps.com/t/computed-column-construct-json/71715>\
**Category:** Feature Requests\
**Created:** [March 15, 2024, 4:11pm UTC](https://community.glideapps.com/t/computed-column-construct-json/71715 "2024-03-15T16:11:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\
**Post date:** [March 15, 2024, 4:11pm UTC](https://community.glideapps.com/t/computed-column-construct-json/71715/1 "2024-03-15T16:11:41Z")

</div>

Escapes all invalid characters

---

<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:** [March 15, 2024, 4:18pm UTC](https://community.glideapps.com/t/computed-column-construct-json/71715/2 "2024-03-15T16:18:43Z")

</div>

You might need to elaborate on that a little, I think.  
The existing JSON columns (JSON Object/JSON Template) already take care of always returning valid JSON, if that’s what you mean.

---

<div class="post-metadata">

**Author:** ![HeartwoodTreeCo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heartwoodtreeco/32/8150_2.png) [@HeartwoodTreeCo](https://community.glideapps.com/u/HeartwoodTreeCo)\
**Post date:** [March 15, 2024, 5:06pm UTC](https://community.glideapps.com/t/computed-column-construct-json/71715/3 "2024-03-15T17:06:43Z")

</div>

Thanks for the reply. Now I see there are several JSON computed columns. Let me see if one of them fits the bill and I’ll get back about this.

I was setting up a DocsAutomator action and it didn’t like line breaks or double quotes (used to indicate inches) so I was eliminating them with Replace text columns.

---

<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:** [March 16, 2024, 5:15am UTC](https://community.glideapps.com/t/computed-column-construct-json/71715/4 "2024-03-16T05:15:39Z")

</div>

Yes, either of those two columns that I mentioned should do the job for you. Use the JSON Object column where you have a simple series of key/value pairs, or the JSON Template column for more complex/nested JSON structures.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 23, 2024, 5:15am UTC](https://community.glideapps.com/t/computed-column-construct-json/71715/5 "2024-03-23T05:15:39Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.