by static I meant the data is not changing based on the user profile.
I was trying to avoid the sign in by using a form (name, email) and using that as user profile (under “users & authentication” settings, Im using a google sheet as the source with user data from the form in Glide.
Users will either be signed in or they won’t. There is no way to “pretend” that a user is signed in, if that is what you are trying to do.
It sounds like your users are not signed in, in which case any values added to user specific columns will be lost as soon as the user navigates away from the App.