# Copy Row for Relation **URL:** \ **Category:** Ask for Help\ **Created:** [August 6, 2021, 1:38am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074 "2021-08-06T01:38:40Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 1:38am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/1 "2021-08-06T01:38:40Z")
I have a few pages that relation to each other. How to make it when click one button automatic copy row in all sheets that have relation to it? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [August 6, 2021, 1:47am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/2 "2021-08-06T01:47:24Z")
You wanna copy a whole row? and what do you wanna do afterwards? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 1:51am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/3 "2021-08-06T01:51:58Z")
Whole row. Eg Sheet 1: customer details Sheet 2 : items (which one to many to sheet 1) This is only an example because there’s another sheets. I need to copy let say the running number i created has changed. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [August 6, 2021, 1:59am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/4 "2021-08-06T01:59:19Z")
Sorry, but I still don’t understand what you wanna do ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 2:13am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/5 "2021-08-06T02:13:01Z")
Hmm my question is how add the whole row the item that have relation in other sheet. For example in image below. If i wish to add row/copy at M-Front on Quotation Number GE-2108-0258.Rev.0 , how to make automatically add in second sheet (M-Items) which it will automatically added two lines that have GE-2108-0258.Rev.0 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3a5ad8405711fe6ed01a56326a585bf40eb57524.jpeg) ---
**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:** [August 6, 2021, 2:17am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/6 "2021-08-06T02:17:13Z")
- Make sure your current screen is based on the source sheet (so that you have direct access to all the columns you need) - Then create a custom action sequence with two Add Row actions ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 2:27am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/7 "2021-08-06T02:27:03Z")
Hmmm. To add row for M-Front is no problem. But to add row to relation sheet which in this case M-Items is impossible because you can see image below: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d49a85a9bea6154edb4d4bb3dd391f7b5b2bad4.png) ---
**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:** [August 6, 2021, 2:45am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/8 "2021-08-06T02:45:21Z")
If you need to use values from another table in your Add Row action, then you’d need to first “import” those values into the current table using Lookups via a relation, or Single Value columns, or whatever is appropriate. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 2:48am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/9 "2021-08-06T02:48:51Z")
Darren, Of course value from another table since ive asked the relation to add row. You mean doing lookup one by one column right? hmm i think its very messed up since a lot column & calculation in each sheet. Imagine i had like 5 sheets. hmmm ---
**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:** [August 6, 2021, 2:53am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/10 "2021-08-06T02:53:54Z")
yes, one by one. There might be (and probably is) a more efficient way to get what you want, but I don’t know enough about your app or how your tables are laid out to be able to advise any further. ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [August 6, 2021, 3:11am UTC](https://community.glideapps.com/t/copy-row-for-relation/30074/11 "2021-08-06T03:11:01Z")
My apps was doing quotation generation which include automated calculation. First image below, shows the Quotation number which have revision number at last. Zero means new. I need it to be revised . it will change revision 1 for first revised. For example it will be GE-2108-0258-Rev.1. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/782857eb9ebb67c42e43a276f0ce2aa67b4c19fb.jpeg) To be revised the old quotation number should remain the same . And revision 1 should be same at first & user can edit the details inside. So, it need to be copied all details from revision 0 to be 1.