# Publish and umpublish rows

**URL:** <https://community.glideapps.com/t/publish-and-umpublish-rows/25153>\
**Category:** Ask for Help\
**Created:** [April 5, 2021, 5:01am UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153 "2021-04-05T05:01:40Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 5:01am UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/1 "2021-04-05T05:01:40Z")

</div>

I need some advice.

I have to glide tables both with row owners.  
Table look and look products.  
One look can have n look products.

My goal is that the user has a button publish in the look detail view that make the look and related look products visible for everyone.

Then unpiblish button reverse this.

Any Ideas?

My first thought was to make to tables without row owner. But hiw to cooy all related looks products at once?

Happy for any advice.

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 7:10am UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/2 "2021-04-05T07:10:42Z")

</div>

Ok I think I have an idea.

Using template columns to create my own json object and yous a web hook and Integromat to copy the complete look.

Hmmmm. What do you think?

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 10:36am UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/3 "2021-04-05T10:36:04Z")

</div>

Yup this works.

Here the json column for the look product:

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

Than the joined list for the product array:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2bd8f36f2cbef7c81f830669af17723282b626b.png)

The complete json for the look:

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

Next the integromat scenario:

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

The json node parse the json out of the value that glide sends. The iterator process over the look products array inside the json-Object.

Last but not least the webhook:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55aa652b0a74237838a69409e079193ec6d17d65.png)

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 3:45pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/4 "2021-04-05T15:45:01Z")

</div>

I did a little redesign. Now I can handl the publish and unpublish workflow with one scenario.

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

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [April 5, 2021, 6:32pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/5 "2021-04-05T18:32:16Z")

</div>

I think you might have problems with special characters in the strings that are part of your JSON if you build it like that.  
When it comes to building a JSON I use the JSON.stringify function in apps script.

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 7:19pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/6 "2021-04-05T19:19:54Z")

</div>

I hope that the webhook action encode the url correctly.

---

<div class="post-metadata">

**Author:** ![Roldy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/roldy/32/36068_2.png) [@Roldy](https://community.glideapps.com/u/Roldy)\
**Post date:** [April 5, 2021, 7:21pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/7 "2021-04-05T19:21:34Z")

</div>

Let me know

---

<div class="post-metadata">

**Author:** ![Jacktools\_Net](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jacktools_net/32/18500_2.png) [@Jacktools\_Net](https://community.glideapps.com/u/Jacktools_Net)\
**Post date:** [April 5, 2021, 7:25pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/8 "2021-04-05T19:25:36Z")

</div>

I have two URLs with Parameters in my json-object and it works like expected.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/publish-and-umpublish-rows/25153/9 "2024-01-17T16:52:44Z")

</div>


