# Set Values of Whole User Specific Column **URL:** \ **Category:** Ask for Help\ **Created:** [April 6, 2023, 4:07am UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202 "2023-04-06T04:07:32Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![KristofU](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kristofu/32/55287_2.png) [@KristofU](https://community.glideapps.com/u/KristofU)\ **Post date:** [April 6, 2023, 4:07am UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202/1 "2023-04-06T04:07:32Z")
Hey team! I’ve got a multi-step form that uses a custom collection to display all questions dynamically - the source table for the collection has each question in a column (as opposed to a row), and each question has a few extra data points (a description, weighting, etc) each saved in columns of that table. I’m doing it similar to **[this video](https://www.youtube.com/watch?v=t-sh_Q3WbQc)**, so that to add more questions or categories (each category is a step in the form) all I need to do is add another row to the table and not update any hard-coded values. The answers are all numerical, and to I use a user-specific column in this same table to capture them, so each element in the custom collection just needs a numerical entry field. To get submissions _out_ of the table, I use a joined list in the Users table of all values in the ‘answers’ column, then split those in an output Google Sheet. The problem I’ve encountered is in clearing the ‘answer’ column values after the form is submitted. Using a ‘set column values’ action only clears the first row’s answer, and since it’s a user-specific column (multiple users can be completing the form at once) I can’t use a Google Sheets script to clear it either. Does anyone have any suggestions, or is there instead a way I can have the questions / descriptions in rows to use with a custom collection, but have the in-progress form save values into a row instead of a column? Thanks in advance!! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 6, 2023, 10:57pm UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202/2 "2023-04-06T22:57:36Z")
So you’re displaying a collection of questions and users would have to click on each question to answer it? ---
**Author:** ![KristofU](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kristofu/32/55287_2.png) [@KristofU](https://community.glideapps.com/u/KristofU)\ **Post date:** [April 8, 2023, 6:53am UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202/3 "2023-04-08T06:53:18Z")
Each item in the collection is an action row, with the question as the title, and the action displays a slide-in of the description column (for more info about the question). ![chrome-capture-2023-3-8 (1)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce8e76a2dd5746b547fd43e791ea6a7d735278b8.gif) The data table looks like this, with the ‘score’ column being the one I want to clear on form submission: ![Screenshot 2023-04-08 185156](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d3441ad116ae13bc3adca5abe9628dce75423e92.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 8, 2023, 7:29am UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202/4 "2023-04-08T07:29:26Z")
> [@arrows\_counterclockwise Bulk clear, edit, restore and delete columns plus Undo action](https://community.glideapps.com/t/bulk-clear-edit-restore-and-delete-columns-plus-undo-action/59546): > > A little fun with Glide columns, using Java wink It works well and fast. You can edit or clear the whole column in one click… then undo, edit, or restore all to default. I used a regular inline list. You can still edit, add or delete individual rows as usual. It is a free app with no scripts and no Google Sheets… Pure Glide Page (App) ---
**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:** [April 9, 2023, 7:29am UTC](https://community.glideapps.com/t/set-values-of-whole-user-specific-column/60202/5 "2023-04-09T07:29:43Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.