I am creating a digital diary app. I have a sheet named Diary and each row is a single entry, and I use Add row action to create each entry. I have also used row ID for each entry. I sent the users email along with each entry. I then filter the list by email is signed-in user in order to show only the diary entries of the signed-in user.
When I click on View as, I see the same user’s email multiple times. May I know what is happening? Normally, each user will be shown only once. So, why is it considering each row as from a different user though with the same email.