Set Multiple Column values at once via Glide API

Ask for Help
1

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

2

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

3

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

4

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.

4 Likes