# Automate row owner

**URL:** https://community.glideapps.com/t/automate-row-owner/24932
**Category:** Ask for Help
**Created:** [March 30, 2021, 4:30pm UTC](https://community.glideapps.com/t/automate-row-owner/24932 "2021-03-30T16:30:02Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![Izhar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izhar/32/21308_2.png) [@Izhar](https://community.glideapps.com/u/Izhar)
#### Post date: [March 30, 2021, 4:30pm UTC](https://community.glideapps.com/t/automate-row-owner/24932/1 "2021-03-30T16:30:02Z")

</div>

Hi,

how to automate row owner? i mean when new user create new data i want it follow previous column configuration. At the moment i just do manual at spreadsheet.  
screen shoot as below.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d8c53fbaf0fdc18aac15b3d0ed7460ce41f29455.png)

spreadsheet  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/4/e434ec9d5b4d7d3667ea52773bfef4f131b66539.png)

---

<div class="post-metadata">

### 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: [March 30, 2021, 4:33pm UTC](https://community.glideapps.com/t/automate-row-owner/24932/2 "2021-03-30T16:33:41Z")

</div>

You can create an arrayformula in your Email2 column in the google sheet to automatically fill it. Or you could create a template column with your email address in the app, then have that template column automatically write to the Email2 column through a Column Value component in the form.

---

<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: [March 30, 2021, 11:15pm UTC](https://community.glideapps.com/t/automate-row-owner/24932/3 "2021-03-30T23:15:52Z")

</div>

If the “Email2” column will always be [izis27@gmail.com](mailto:izis27@gmail.com), you can put this formula in the first cell.

```
={"Email2";ARRAYFORMULA(IF(A2:A<>"","izis27@gmail.com",""))}
```

---

<div class="post-metadata">

### Author: ![Izhar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izhar/32/21308_2.png) [@Izhar](https://community.glideapps.com/u/Izhar)
#### Post date: [March 31, 2021, 2:18am UTC](https://community.glideapps.com/t/automate-row-owner/24932/4 "2021-03-31T02:18:57Z")

</div>

Thinh,

Thank you for your help. it worked.

just to ask small clarification when i try to add new record it display in app database but not at spreadsheet. is that normal?

---

<div class="post-metadata">

### Author: ![Izhar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izhar/32/21308_2.png) [@Izhar](https://community.glideapps.com/u/Izhar)
#### Post date: [March 31, 2021, 2:22am UTC](https://community.glideapps.com/t/automate-row-owner/24932/5 "2021-03-31T02:22:17Z")

</div>

@Jeff_Hager

thank you for your suggestion.

i am interest to know for second method. you have any example for it? because glide technology is new to me. not sure which template you talking about.

---

<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: [March 31, 2021, 2:46am UTC](https://community.glideapps.com/t/automate-row-owner/24932/6 "2021-03-31T02:46:29Z")

</div>

Try to clear all the empty rows you have. It might be somewhere in there at the bottom of the Sheet.

---

<div class="post-metadata">

### Author: ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/automate-row-owner/24932/7 "2024-01-17T16:52:43Z")

</div>