# Copy whole row after selecting a vaue
**URL:** https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006
**Category:** Ask for Help
**Created:** [December 25, 2023, 9:07pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006 "2023-12-25T21:07:11Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Alan\_Gabriel](https://community.glideapps.com/u/Alan_Gabriel)
#### Post date: [December 25, 2023, 9:07pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/1 "2023-12-25T21:07:11Z")
Hi, I am trying to copy a whole row based on a Choice component user input.
For ex. I have 2 columns NAME and LINK.
I want the user to choose from a choice component and when it does Copy the WHOLE row to a new table so I get NAME and LINK. When the user only chooses on a NAME dropdown.
Thanks a lot!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 25, 2023, 10:30pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/2 "2023-12-25T22:30:19Z")
What are you giving the user as choices in the component? Do you mean like selecting a value from a row, identify that row and copy them to the new table?
---
### Author:  [@Alan\_Gabriel](https://community.glideapps.com/u/Alan_Gabriel)
#### Post date: [December 25, 2023, 11:51pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/3 "2023-12-25T23:51:17Z")
Yep. I am giving the user ONLY the NAME option and when they select and send that COPY that whole row.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 26, 2023, 3:17am UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/4 "2023-12-26T03:17:59Z")
Only thing I can think of is to point the choice component to the row id of the row instead of the name. Next, create a relation column that relates the selected row id to the row id of the source table. Finally, add lookup columns to fetch the link.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 26, 2023, 4:24am UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/5 "2023-12-26T04:24:23Z")
I would take a step back and ask why you are creating duplicate data?
Maybe there is a very good reason for that, but duplicating data is always something that should be avoided if possible.
---
### Author:  [@Alan\_Gabriel](https://community.glideapps.com/u/Alan_Gabriel)
#### Post date: [December 26, 2023, 4:31am UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/6 "2023-12-26T04:31:28Z")
I have a database where I take data from and display some part of it for some users. That’s why I need only few rows of it.
Would I be better off copying manually? Or what? Thanks!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 26, 2023, 4:33am UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/7 "2023-12-26T04:33:09Z")
Could you not just apply filters?
Or if the data is super sensitive, then use row owners.
---
### Author:  [@Alan\_Gabriel](https://community.glideapps.com/u/Alan_Gabriel)
#### Post date: [December 26, 2023, 4:03pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/8 "2023-12-26T16:03:32Z")
Filters could be a good option but I need them in an specific order also. Will look into it in the meantime.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 26, 2023, 4:31pm UTC](https://community.glideapps.com/t/copy-whole-row-after-selecting-a-vaue/69006/9 "2023-12-26T16:31:07Z")
It’s quite easy to both filter and sort on the front end.
> **[Filter | Glide Docs](https://www.glideapps.com/docs/reference/user-experience/filter)**
>
> Filter your content based on criteria.
> **[Sort | Glide Docs](https://www.glideapps.com/docs/reference/user-experience/sort)**
>
> Sort your lists and collections based on criteria.
If you need more advanced sorting and/or filtering, then there are techniques available.