# Column Type: 'Copy Value' **URL:** \ **Category:** Feature Requests\ **Created:** [May 19, 2020, 4:00am UTC](https://community.glideapps.com/t/column-type-copy-value/9403 "2020-05-19T04:00:21Z")\ **Posts on this page:** 7\ **Page:** 2
**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:** [July 12, 2020, 3:34am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/21 "2020-07-12T03:34:33Z")
This should do it, but beware of what columns you need to copy down after a new row is created (I assume via a form) and change it accordingly in the part. ``` sheet.getRange(i-1, 2, 1, 2) ``` [http://bionicteaching.com/google-script-to-copy-row-above-to-blank-row-below/](http://bionicteaching.com/google-script-to-copy-row-above-to-blank-row-below/) ---
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 12, 2020, 3:58am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/22 "2020-07-12T03:58:04Z")
it works, but then I image now Ive to trigger it… I changed the script, I removed this test `` `var` `test = sheet.getRange(i, 2);` ` ` `Logger.log(test);` ` ` `//looks to see if the cell is empty` ` ` `if` `(test.isBlank()) {` that looks with no sense, when was easier to check if (i= last) anyway its work ---
**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:** [July 12, 2020, 5:09am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/23 "2020-07-12T05:09:20Z")
Add an automatic trigger for it, change the event trigger to on change. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 21, 2020, 12:23am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/24 "2020-07-21T00:23:08Z")
I’ve populated rows with previous row data using arrayformulas. Copy and take a look at the MemoriesDetailsLookup sheet in [https://rwtsk.glideapp.io/](https://rwtsk.glideapp.io/). The navigate columns pull previous row and next row values. There is a little extra in the formula to handle my needs, but this should give you an idea. ---
**Author:** ![trisixnine](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/trisixnine/32/10044_2.png) [@trisixnine](https://community.glideapps.com/u/trisixnine)\ **Post date:** [July 21, 2020, 1:03am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/25 "2020-07-21T01:03:49Z")
Thank you Jeff appreciated. My needs was a bit different, but anyway I see your formula is also good. Thanks so much. ---
**Author:** ![Sage\_Edutitrof](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sage_edutitrof/32/28772_2.png) [@Sage\_Edutitrof](https://community.glideapps.com/u/Sage_Edutitrof)\ **Post date:** [July 14, 2021, 12:44am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/26 "2021-07-14T00:44:11Z")
How do you get the “Navigate” feature? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 14, 2021, 12:59am UTC](https://community.glideapps.com/t/column-type-copy-value/9403/27 "2021-07-14T00:59:11Z")
It’s just a Tiles style inline list that uses a relation. The data for the relation is built using formulas in the sheet. I explain it below, but you can copy the app and take a look for yourself. > [@NEXT button option](https://community.glideapps.com/t/next-button-option/9412/17): > > Sorry for the delay. I’ve been away from my computer for a few days and I just saw your other post a little bit ago, so I fired up my laptop to make the app copyable again. Now you can make a copy so you can take a look at it. The quick version is that I have the MemoryDetails sheet which holds all of the submitted images by users. Then I have a MemoryDetailsLookup sheet which takes those rows and compresses them without spaces and I then add navigate columns which determine the previous and… [Previous page](https://community.glideapps.com/t/column-type-copy-value/9403.md?page=1)