Approving User Submitted Images

There’s a couple of ways to do this.

If you only have one admin, place their email on a sheet by itself. Then use the single value column to grab the email of the admin from the sheet and include it on the photos sheet.

Another method is to first place an Admin column on a user specific sheet. Fill that column with ‘Admin’ for those have admin rights. On the photos sheet create a template column and make the result of that column ‘Admin’. Next create a relation column to link the Admin column in the photos sheet to the Admin column in the users sheet. Finally create a lookup column in the photos sheet to get the emails from the relation.

Both methods will provide a column of admin emails that can be used for filtering the photos list.

1 Like