# Set Multiple Column values at once via Glide API

**URL:** <https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713>\
**Category:** Ask for Help\
**Tags:** api\
**Created:** [September 30, 2024, 1:39pm UTC](https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713 "2024-09-30T13:39:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RayLor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raylor/32/80394_2.png) [@RayLor](https://community.glideapps.com/u/RayLor)\
**Post date:** [September 30, 2024, 1:39pm UTC](https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713/1 "2024-09-30T13:39:52Z")

</div>

Hello Guys, I’ve been reading some post in the community and watching some of the videos, but I’m stuck and not able to find a way to update a bool column in a different table.

Explanation:  
I have a table for clients and if these clients dont have a point of contact, the bool column will be empty (false). However, when I add a new point of contact, the user will be given the option to select the client they work to (choice fetching form the clients table)

So, what I want is after they select the client they work for, I want to update the bool column in the clients table. I’m using a helper table so I can store the data for the point of contact and client and once done, everything is clear and ready for the next operation (user specific columns in the helper table)

I know about using API, I have a column in the helper table with the row ids of the clients the user selects from the choice component, but i dont know how to use these comma separated list of rowids to set the api call everything else.

some guidance? thanks

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2024, 1:53pm UTC](https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713/2 "2024-09-30T13:53:22Z")

</div>

Are you permanently storing the comma delimited list of clients in the point of contact row?

---

<div class="post-metadata">

**Author:** ![RayLor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/raylor/32/80394_2.png) [@RayLor](https://community.glideapps.com/u/RayLor)\
**Post date:** [September 30, 2024, 1:59pm UTC](https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713/3 "2024-09-30T13:59:05Z")

</div>

I’ll store the clients row id so i can display that somewhere else thru a relation or something

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 30, 2024, 2:03pm UTC](https://community.glideapps.com/t/set-multiple-column-values-at-once-via-glide-api/76713/4 "2024-09-30T14:03:24Z")

</div>

If it’s just a single RowID, you can create a relation linking the Client table RowID to the Client ID in the POC table.

If it’s a comma delimited list of multiple clients, then you first need a Split Text column in the POC table to convert the comma delimited list into an array. Then you can create a relation like above.

Finally in the Client table, add an IF column that returns ‘true’ if the relation is not empty.