This app is for a small team. Only registered users will have the link. It’s set as PUBLIC WITH EMAIL.
For some reason when a user signs in to the app for the first time a new row and new user, with a randomly generated email, is created - even though they’re using the email used when registering that’s already in the data.
How can I avoid this?