User creates a contact with a form > when the user presses “Send” it does a Set column value to ContactOwner field in my contacts sheet to “User’s email address”.
Now here is my issue, ContactOwner gets the correct email value just as i wanted it, but all users can still see the contact. However when i copy the Email > Empty the column > click out of the column > paste back in the copied Email > It works…
Does row owner always have to be set manually, or am i doing something wrong?
Sounds like you should not do a set column here, you should be able to pass the signed-in user’s email as a special value, to the contacts sheet.
If you have a screenshot demonstrating how you’re setting up your row owners and how it’s still visible for all users then we can know more about the issue.
This is how its currently setup. When i reset the value of the Owner column manually it seems to work.
Edit: Now it has a new issue… it will randomly show 1-2 or none of the contacts even if i manually copy the email in. I have checked all the visibility settings and filter settings but everything is empty, so that cant be the issue…
I just looked again at your original screenshots, and I noticed two things:
Firstly, I see that you are doing a Set Columns Action immediately after a “Go Back”. The Go Back is going to change your context - you’ll most likely no longer be sitting on the same table - so that may explain why the Set Column Values fails.
Secondly, you shouldn’t need the Set Columns in the first place. You could add the Owners email when the row is created, using the current users email special value.
