To control who can add a show, you’ll need to use a form button. First you’ll need a sheet that contains verified users, or use your existing users sheet with a column to mark the user as verified (we’ll assume you’ll mark the verified column as ‘true’). In the sheet for the page that has your form button, create a template column and fill it with a value of ‘true’. Create a relation column that links the template column to the verified column in your users sheet. Next, create a lookup column to bring back an array list of verified user emails from the relation. Set visibility on the form button to only show when the lookup column is signed in user.
1 Like