# How can I take a value from a User Specific column and write that value into a basic (non-user specific) column? **URL:** \ **Category:** Ask for Help\ **Created:** [April 13, 2023, 9:25pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509 "2023-04-13T21:25:03Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 13, 2023, 9:25pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/1 "2023-04-13T21:25:03Z")
Hi, i am trying to take a take a value from a User Specific column and write that value into a basic (non-user specific) column because i need to send this data back to my google sheet! ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 13, 2023, 9:34pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/2 "2023-04-13T21:34:10Z")
Hello and welcome to the community 🥳 You could do that with a set column value. First create a new basic column. Next use a set column value somewhere in your flow to write the value from your user specific column to that new basic column. > **[Glide • Set Column Values](https://www.glideapps.com/docs/reference/actions/set-column-values)** > > Change another row's values. ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 13, 2023, 10:07pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/3 "2023-04-13T22:07:45Z")
hey! I tried to do so, but it didnt work. Should i set the action somewhere specific? Because i set the action on a flow of a button, and it didnt work. The basic column is not receiving the information of the user specific column: This is what i did: ![Screen Shot 2023-04-13 at 19.06.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4dad85f699e190b1735e9242131c7403819b30e.jpeg) ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 13, 2023, 10:09pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/4 "2023-04-13T22:09:11Z")
I have the data at the user specific column, but not on the others: ![Screen Shot 2023-04-13 at 19.08.32](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/d/9d8c71be251f010853beefcdcb93d64f24735d69.jpeg) ---
**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 14, 2023, 12:34am UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/5 "2023-04-14T00:34:21Z")
So the second set of columns you’re showing in the screenshot are basic columns? When you click the button nothing happens? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 14, 2023, 12:43am UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/6 "2023-04-14T00:43:54Z")
Are you positive that you’ve selected the correct columns in your Set Column Values action? I can see that you’ve named both sets of columns exactly the same. Which is a really bad idea, as it will be very easy to get them mixed up. Even if it isn’t the source of the problem now, I’d advise changing that. Perhaps add a prefix like `usc/` to the User Specific Columns. Whatever - just name them so that it’s obvious which is which. ---
**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 14, 2023, 2:24am UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/7 "2023-04-14T02:24:52Z")
Your screenshot is not showing essential clues. Is that a user profile sheet? And if yes… do you have the row owner selected? And… change column names… as Darren mentioned… it is hard to know if you selected the right ones. ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 14, 2023, 12:28pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/8 "2023-04-14T12:28:03Z")
Hey guys! Yes, i selected the write columns, but i didnt put the row owner! Should I do that? I cannot select my user specific column as my row owner, only the basic columns. and yes, i didnt change the name! I will do that, thank you all for the advice 🙂 ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 14, 2023, 2:42pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/9 "2023-04-14T14:42:27Z")
![Screen Shot 2023-04-14 at 11.40.13](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/0/102fc72d754d4be4c558e90ee55b8d0aa8be23a6.jpeg) I am also trying to do that (send the data to my google sheets) using zapier, but i am also not able to configure the zap on my glide, and i already checked that I’m connecting the right glide project inside zapier. Heeelp, please! ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 14, 2023, 2:42pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/10 "2023-04-14T14:42:58Z")
![Screen Shot 2023-04-14 at 11.42.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6af5bf0116328215047c0a9620b160b03ff6171e.jpeg) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 14, 2023, 3:02pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/11 "2023-04-14T15:02:39Z")
For your use case Zapier is not necessary. Here take a look ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 14, 2023, 3:24pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/12 "2023-04-14T15:24:22Z")
Thank you for the video! I also record my screen so you can see what i am doind wrong… Because i did exactly the same thing and it is now working ☹ Here is the [video link](https://drive.google.com/file/d/1FVytvj44ZaXZLCsWepve8EahhZisjBKh/view?usp=sharing) ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 14, 2023, 4:22pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/13 "2023-04-14T16:22:43Z")
Thank you for sharing a video. I did notice a problem. On your button block you have two actions (Enviar and setcolumnvaluer) however only your Enviar button is visible. This indicates that your setcolumnvaluer button is hidden because a condition is not being met. Are you using row owners? Try removing row owners from any columns in table Teste-jo. You can tell if a column is a ‘Row Owner’ by a little blue person in the header row. ![Screen Shot 2023-04-14 at 12.21.44 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/a/5ab13710c6b12948adca7f29f97b57e5265b74ea.png) Also instead of three separate set column value actions you could use one set column value action and set three values. ---
**Author:** ![Joanna\_Delg](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joanna_delg/32/54763_2.png) [@Joanna\_Delg](https://community.glideapps.com/u/Joanna_Delg)\ **Post date:** [April 16, 2023, 4:49pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/14 "2023-04-16T16:49:40Z")
Hey!!! Omg, it was that simple hahaha thank you all for the help! It is working now 🙂 ---
**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 17, 2023, 4:50pm UTC](https://community.glideapps.com/t/how-can-i-take-a-value-from-a-user-specific-column-and-write-that-value-into-a-basic-non-user-specific-column/60509/15 "2023-04-17T16:50:21Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.