How can you auto fill a cell with a default value?

[ray_d]

Hi, I’m trying to create an approval system for an Admin to approve or deny new user submissions.
I saw in one of the Glide tutorials that you can do this by creating an Admin column in your sheet and assign your email as Admin, then also add a boolean switch to the app to control Publish status that is visible only to Admins.

The only problem is I have to manually add myself as admin on each new entry’s row in the sheet. If I try to pre-populate the entire Admin column in the sheet with my email, the new user submitted entry will just jump to the next empty row which will not have my email inputted as Admin.

My question is: What is a formula I can use to automatically input my email in the Admin cell for each new submission row in the sheet? I’ve been scouring the web, but I can’t find a way to make it work. I have a feeling it has to do with =ARRAYFORMULA(A2:A, "my@email.com") but that doesn’t seem to work.

Anyone know how to do this?

[ThinhDinh]

Each new submission row, let’s say it goes in the column A, then you can input in column B.

=ARRAYFORMULA(IF(A2:A<>"","my@email.com",""))

This checks if any cells from A2 to the end of column A is not null, if it’s not null, the value my@email.com will be set to column B, else it’s left empty.

[Robert_Petitto]

@ThinhDinh is correct. However, more recently, I just create a template column in Glide, call it Admin, and then enter admin in the enter value box. No formulas needed!

[ThinhDinh]

That is great!

[ray_d]

This is awesome! Thank you both!