Automate row owner

Ask for Help
1

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
image961Ă—229 37.9 KB

spreadsheet
image

2

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.

1 Like
3

If the “Email2” column will always be izis27@gmail.com, you can put this formula in the first cell.

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

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?

5

@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.

6

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