Glide: Secure Your Data with Row Owners and Public Profiles

[@BalajiPasumarthy]

On clicking "Complete Profile" button, the "Hide Screen" comes. Instead how to not show the Hide Screen and go to the "People" Tab? Getting users to cick on "Hide Screen" is poor user experience.

[@RobertPetittoWA]

Just add a "Go to tab" action at the end of the action sequence.

[@toddlichtenwalter2041]

uh oh! I have something like 50+ lookups etc tied to the User sheet, if I make a public facing User profile, I am going to have to go back and recreate all of the relations and lookups?

[@RobertPetittoWA]

If you’re creating a public facing app (anybody in the world can sign in), then yes you’re gonna want to secure user data which means you’ll need to re-create the relations and look ups

[@peacefull_moment]

I followed every step in the video but when I created an account one account in the public profile was without a row ID while another duplicate account is with a row ID. Is this just a glitch? if not how do I fix this?

[@RobertPetittoWA]

What are you using as your source? Glide? Airtable? Google sheets?

[@aironorphan]

The only real use case for this would be if you don’t want other users to see other users email address, but each user needs to use their email address for login. All other info is not really necessary. For example, there’s no reason only logged in user can see their own SSN or phone number. Why would I need to see that info about myself in the app? So for practical use, in the users table, only have email address field, and in public profile table, you can add whatever info is necessary for your app for other users to be able to access, for example name, profile pic etc. This way, you won’t need an extra step to set column values to update both tables. In the edit profile tab, just have it link to the public profile page, and to edit email, have it link to the users page.

[@RobertPetittoWA]

Ya, I used some extreme use cases just to show the severity of the issue. You make a great point about just relating/displaying the public profile info at all times. However, if you needed to keep the two sheets in sync, the set column method works well

[@marvinranoke7278]

thank you for the video but would it be possible to have a template?

[@RobertPetittoWA]

It’s available as a template if you join my VIP membership. See more details on my channels homepage.

[@andrewpndavies]

Another great video - this has helped me so much! Thanks Bob. Quick one though - instead of having a "profileCompletedOn" column - could we not just use the relation back to the user profile table? (rel_profile in your video). Instead of checking if "profileCompletedOn" is empty, we could see if "rel_profile" is empty. One less column, and if for some reason the row from the profile row gets deleted, the user can re-do their profile. Just a thought?

[@RobertPetittoWA]

That could work for sure. Sometimes I just like to have the data point of when someone completes a profile in case I need to investigate

[@jeffcox7676]

This seems like a bad design on Glides part. Why wouldn’t they filter the data on the server side before pushing that down. So if I don’t implement row owners and I have an app with 10000 records it’s going to push all 10000 records but only display 1

[@RobertPetittoWA]

10000 records with row owners will only push the rows that are owned (so yes, 1 row if it’s the user’s table). All filters are computed on the device.

[@tikhonr9223]

Robert, thank you so much for very useful and instructive video

[@RobertPetittoWA]

Glad it was helpful! Let me know if you have any further questions.

[@KiraWorld]

Thank you for detailed and clear explanation, I exactly need this from yours video... perfect... Please can you explain to me: " how make to user staying log in when close app and open again?" Maybe making any "check box" for save login data? And please can you recommend video where I can see how to install app on android phone? I found alot glide videos but this is not up-to-date with Glideapp.... Great what you making videos about Glide, thank you for that! My respect!

[@RobertPetittoWA]

Hi Leon. Users should stay logged in even when you close the app unless the user accesses the app from a different device or via a different browser. Here's the documentation on installing app on Android: kzbin.info/www/bejne/eoPXlYqomauYpc0

[@KiraWorld]

@@RobertPetittoWA great, thank you very much! Definitely I will follow yours next videos and also will see yours rest videos about Glideapp....please can you tell me is old video about glideapps, (example 1year) also valid for currently Glideapp platforms? I will also connect in Glideapp and in Glide community! Thank you!

[@baseballvideo9975]

Hi Robert. Very useful video, thanks! If I want to get several values (name, image, nickname for example) from choice component should I do it with Join List of this values? Or there is another way? Thank you!

[@RobertPetittoWA]

Depends what you're trying to do. You're looking to allow users to select another user's name, image, etc from a choice component? For what purpose?

[@baseballvideo9975]

@@RobertPetittoWA I have a table with a set of tasks created by admin of the app. Each task has name, description, image and reward (bonus points). One users can set these tasks to another ones. So when one user (task manager) set a task to another one (task executor) it adds a new row in a table of created tasks by managers. So during setting of a new task manager choose one of the task template from set with choice component. And I need name, description, image and reward values to be added to a row in the created tasks table. But the choice component allows to send just one value (column) to destination table on form submission. So I have to join these values together, send it to the destination table then split to different columns from array with a single value (I saw it in one of your video lessons btw). Does it look like a good workflow for this purpose in your opinion? Or I missed much easier way to do it? Thank you for your attention!

[@peacefull_moment]

Thank you for this detailed yet to the point video. How do I secure information and yet let users contact each other? I am creating a community members' app of professionals and mentors. Thank you.

[@RobertPetittoWA]

Do you mean contact them via email or SMS?

[@peacefull_moment]

@@RobertPetittoWA Hi, either. I guess what what's the best and more secure way to allow users to reach out to those who have a profile in the directory? TIA

[@pierredeman66]

Nice and handy video. I am already using part of it, but now I can extend it more 🙂

[@RobertPetittoWA]

Glad you find it helpful!

[@peraruor]

Thank you so much for posting videos like this!

[@RobertPetittoWA]

More to come!

[@brianridwan]

Thanks, this very helpful ❤

[@RobertPetittoWA]

Glad it was helpful!