In a form/edit screen, I like to use visibility settings to show/hide components based on other values the user has already filled out/selected. For example, I could hide a choice component once the user selected an option…but that means the user couldn’t change their mind once they selected it.
Now they can, I can point to the user profile column rather than the identical sheet column to keep the choice component visible until the value actually writes to the sheet.
I love what you are doing here! I am curious, when I have set up my user profiles to a sheet, I am getting repeating data every time a user logs in. like the app:logins and and user profiles sheet have become one. No matter what sheet I use and what app I have enabled this for, this is the behavior I see. Are you seeing this same behavior when using the user profiles?
We had an exchange about this in another thread, but I am trying to understand how others are dealing with this weird duplication of users issue.
Yes this is correct. When you are using user profile option, every time a new user log in one new line will be added automatically and this will eat your row count, which is not favourable for free user under 500 row limit.
With User Profiles enabled, you’ll still get new rows in App: Logins. Glide has mentioned that they might eventually phase this out. There’s no longer any need, though, to reference this sheet with Unique formulas or scripts, etc.
Thanks fore the quick reply. I apologize. I must not be explaining my situation well. I think that logging individual logins in a separate sheet like app:logins is still fine. The situation I am facing is that the sheet I set as the table to store users in the “User Profile” settings is not only recording each user once, but every single time the user logins in. Like you would expect to see in the app:logins sheet, but not a user profile table.
In this screenshot, every “b” email and “g” email are the same users being logged to the sheet I have set up as my profile sheet.
Can you please add the timestamp of the first login as a column in the profiles sheet? Like there is a timestamp in the App:Login. I’m now using a workaround with google apps script because it helps in users data analytics.
Hi, with the new functionality, is there a way to bring the ‘signed in user’ into the data editor? i.e. a ‘signed in user profile’ column, that you can then do lookups to bring in other user profile into the data editor on different sheets? I can do this with a workaround now, but would be great to use this functionality instead. Thanks