# Script Needed - Please help!

**URL:** <https://community.glideapps.com/t/script-needed-please-help/21916>\
**Category:** Ask for Help\
**Created:** [January 29, 2021, 1:01am UTC](https://community.glideapps.com/t/script-needed-please-help/21916 "2021-01-29T01:01:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![drascon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drascon/32/20070_2.png) [@drascon](https://community.glideapps.com/u/drascon)\
**Post date:** [January 29, 2021, 1:01am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/1 "2021-01-29T01:01:38Z")

</div>

Can anyone help me with a script that can copy from one cell down to the another (same column) when a new row is created? I need a default value in a choice component that’s not in a form and the only way that I can think to do it is to have the needed default value in the #2 cell then have it auto-populate on row creation.

Please help!

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [January 29, 2021, 1:25am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/2 "2021-01-29T01:25:59Z")

</div>

Hola @drascon,

Does it have to be a Script or would something like this help?  
={“Choice”;ARRAYFORMULA(IF(A2:A="","",“SOMETHING”))}

If that’s not what you are looking for, maybe @Darren_Murphy, or @ThinhDinh or @Drearystate might be able to help.

---

<div class="post-metadata">

**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:** [January 29, 2021, 1:26am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/3 "2021-01-29T01:26:16Z")

</div>

If you need the same value every time then you can have a text entry that has a default value and just hide it in the form, it would still write.

---

<div class="post-metadata">

**Author:** ![drascon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drascon/32/20070_2.png) [@drascon](https://community.glideapps.com/u/drascon)\
**Post date:** [January 29, 2021, 1:39am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/4 "2021-01-29T01:39:06Z")

</div>

Hey @SantiagoPerez - whatever I can use to automate it is what I need!

@ThinhDinh I need a default value on a choice component (weight based calculator) so I still need the choice component vs the basic text

---

<div class="post-metadata">

**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:** [January 29, 2021, 1:40am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/5 "2021-01-29T01:40:07Z")

</div>

So do you mean that inside a form, you want a choice component to have a default value? I’m just trying to understand what you want to have here, if you’re talking about the choice component, is it inside the form or for a later process? Probably some screenshots would help.

---

<div class="post-metadata">

**Author:** ![drascon](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drascon/32/20070_2.png) [@drascon](https://community.glideapps.com/u/drascon)\
**Post date:** [January 29, 2021, 1:51am UTC](https://community.glideapps.com/t/script-needed-please-help/21916/6 "2021-01-29T01:51:42Z")

</div>

Disregard this 🤦‍♂️

I’m not sure what the issue was but before, when a weight was entered into the calculator, if the measurement was not chosen it would produce and display the values for BOTH (pounds and kgs). It isn’t doing it now.

Sorry guys and thank you both for your quick responses!!