Hi all. I am trying to make a product configurator app. We are using a query column to filter all the parts we need to add to our cart for a single built product based on the choices selected. Now we actually need to be able to add this to an array or user specific table or even just loop through each item in the query and add it to a row along with the current user ID. We want to be able to add the results of the query to the “cart”, clear the query column, and allow a user to select more options and add more. Any advice would be appreciated. Thank you.
It will be challenging to store data into user-specific columns within a loop, since webhook workflows don’t support updating user-specific columns, and using the Glide API for mutations also doesn’t allow modifications to user-specific columns. You may need an alternative approach.
One option is to store the data in a standard text column within the user table, ensuring it’s saved in the correct row for the current user. To maintain privacy, you can set row owners on this column to prevent users from accessing others’ cart data.
To store that as an array, you could use the lookup, joined list and then set column values for that joined list column into the user table.
I think you do have the option to:
- Send those values to a webhook trigger through the body of an API call. You can also send the signed-in user’s ID.
- Query out those rows based on a filter.
- Add rows to the intended table, with context about the signed-in user’s ID as well.