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, "email@example.com") but that doesn’t seem to work.
Anyone know how to do this?