Show a User only their data in AppSheet (Custom User Permissions)

Demo User Filtering
- User Table
- Table Security Filter
- User Slice
- User Specific View Access
- User Specific Column level Access
AppSheet Toolbox Extension: chrome.google....
AppSheet Toolbox User Guide: docs.google.co...
Expressions Library: www.appsheettraining.com/expressions
Feel free to catch us every week for a new concept from AppSheet Training using this link: appsheettrainin...

[@lukundokampeshi7822]

Finding this video months later and it's just what i needed. I'll be tuning in weekly

[@AppSheetTraining]

Glad it’s helpful to you! We’ll see you next week!

[@phocasmaniraguha2474]

Thank you for this video. It helped me a lot looking at what I need for the application that I was introducing to my team in the healthcare field. It is so amazing and insightful.

[@AppSheetTraining]

That’s excellent! I’m so glad you were able to launch your application.

[@robertsincere3964]

I realize it's kind of off topic but do anybody know of a good site to stream new tv shows online ?

[@ronmouw5380]

Great job Landan and Clark! Very helpful webinar.

[@AppSheetTraining]

Thanks, Ron! Glad it was helpful.

[@tommywama4621]

Excellent Video, the level of knowledge shared here is just unimaginable. I'm subscribing and cant wait for more content like this. Thankyou

[@AppSheetTraining]

Awesome! Glad you are enjoying the content!

[@brand-ittechnologies8443]

Great job Landan! very well explained. Thanks Appsheet Training

[@AppSheetTraining]

My pleasure!

[@brand-ittechnologies8443]

@@AppSheetTraining I also like the way you further developed the app instead of starting a new one. After watching the first demo video, I immediately felt at home with this app & demo. It would be great if you could develop this app even further for the next demo. Maybe show how to connect it to a shared Google Calendar or something.. If you're looking for other ideas.. I'd like to know the best way (or any way) to integrate an Appsheet 'Order Form' into a webpage. I've been reading about iFrames etc but I'd like to have a dropdown (link) option on our webpage that would just open up the Form. Is this possible yet? Thanks for all the help so far!

[@MicahJohns]

Fantastic training. Thank you for creating this!

[@AppSheetTraining]

Glad you enjoyed it! Are there any other topics you’d like to see content on?

[@MicahJohns]

@@AppSheetTraining I think it would be really valuable to see more GIS/Map focused tutorials (for me personally), as well as focusing on how to build out connections to external data sources to be consumed by appsheet apps.

[@gianemosquera1313]

That was absolutely amazing. Thank you for this video.

[@AppSheetTraining]

Glad you found it useful! Did you implement this concept? - Camron from AST/QREW

[@gianemosquera1313]

@@AppSheetTraining currently applying it on a project that im working on :D

[@TheeMalikPeterson]

Hey guys, GREAT TRAINING! I was wondering if there is a link to the time card spreadsheet because everything was working for me until I tried to restrict the data by user. When I switch to non-admin users, they can't see anything except for the views...no data. I'd like to take a look at the sheet so I can compare mine. I feel like something isn't right with the way I have the emails set up.

[@pagevpetty]

19:04 column constraint - 'Admin'=ANY(SELECT(User[Role]), [Email]=USEREMAIL()))

[@AneedAnand]

Thank you!!!

[@abadj82]

Fantastic training

[@AppSheetTraining]

Thanks a ton!

[@StephenMattison66]

Great video & great information, helpful, TYVM!. Please consider making sure everyone in all of your videos have EXCELLENT audio, best advice for most consistently great audio is a decent lapel mic. This allows you to move head/look at stuff & still have good audio. The main teacher audio was pretty good, but the guy in top right at the end of the video audio was terrible, lazy to use the computer mic, it is never good, always echo. It's really very easy to have great audio, and you don't get a second chance. Lapel mic ftw!

[@levi_jeager]

This was extremely helpful thanks bro ❤

[@rogersthilaire8179]

Thanks a heap Clarke and Landon !

[@eytanlevy9399]

Amazing video, Thanks a lot😀

[@user-co5xg3xj9g]

Security filter is restricting the view but does it restrict actions also?

[@marksaunders3767]

great video, cant get my brain around this "[User].[Region]=ANY(Current user[Region])," I thought the region column was in the user table ? is this referring to this or the user column in the user table later on. I tried something similar in my own app and it returned " Column User in expression '[User].[Region]' does not contain a reference", Does the security filter when done on a table refer to that table you create it in?

[@commonmanvlogs7]

Great Video. Thanks

[@ralphroycanonigo4639]

May I ask where's the link of the previous video where all the other data is filled in, please?

[@renashbell4317]

just google it a hour ago and this appear , nice

[@AppSheetTraining]

Awesome! Guess we got it out just in time haha

[@Haggard380]

Great webinar indeed!

[@AppSheetTraining]

Thank You Haggard! Do you have any ideas for future topics?

[@Haggard380]

@@AppSheetTraining everything related to dates will be great. i.e. searching for the next date available in a reservation app, is something that I have some issues with.

[@kennylow5807]

For the filters to work, must there be the ‘user’ column in the various data tables?

[@AppSheetTraining]

You do need someway to determine who is seeing the app, the best way is doing that is USEREMAIL(), so its usually best to base Security Filters off of a User table using Emails the key. You could. still rig up a security filter without a User table but it usually wont be as dynamic

[@ubershootph5813]

Hello! can you send me the link where you created first the google sheets?

[@hecalg]

Great training! Thank.

[@Lyes_Abdellatif]

i love it

[@17jatindubey88]

Sir I'm having problem that what condition should I give if their is two admin please help me out for this

[@ShouryaShukla]

I have imported the file list from Google drive into Google sheet with Name, URL, Folder Path, Created Time, Modified Time, MIME Type and Size (Bytes) columns. I have added one more sheet called Sheet 2 into same Google sheet and added columns as Name, Email, Role and Folder Path. Objective of this sheet is to define which user role has access to which folder path. I have imported these two tables into Google App Sheet. I need to apply validation that if current logged in user has 'Leadership' or any other role mentioned for that matter under role column in Sheet2 then based on the folder path mentioned for the role it should display data from Sheet 1? I tried a lot of things but to no avail because there is no email column in the sheet populated from Google drive. Would really appreciate if you could help

[@tejdeeps]

This is awesome, Thank you so much

[@Dradeth100]

Question! Does this work with Calendar views?

[@pagevpetty]

Hey really appreciate your vids, just want to mention it would be HUGELY helpful if you can zoom in or make text bigger so we can actually see it . Thanks!

[@pagevpetty]

LOL! The other guy mentioned it right after I made this comment! I almost thought it was live for a second 😆 Still, a bit BIGGER would be helpful. It's not like you don't have enough room on the screen to make it much bigger. I don't have a bunch of different monitors to display vid on one and what I am doing on another.

[@AppSheetTraining]

@@pagevpetty Yes! Thats one thing we've been focusing more on esspecially with the live feedback from our live bootcamps. We often include guests from our Team who don't often do media creation so some of these standards slip. We are trying to be more intentional with all these things to look out for! :)

[@johnpearson7910]

Hey guys! great video! I don't have a professional background in coding and very new to App Sheets. Since discovering it, I have been watching your videos non stop and have learnt a ton over the last few days. In saying that, I need some assistance in understanding how the symbols { } & [ ] & " " & ( ) & have a relationship to each other when entering them into formulas, and the actions they are responsible for. I don't understand the relationship they have to each other. For some background: I'm a contractor that sub-contracts work out to electrical tradies throughout my city. I need to have the ability to limit who can see what. More importantly which company, and which electrical worker associated with the company, completed the tasks. Basically, If you could explain how to go about setting up a login page, or like this video explains, how to go about better controlling access for some security and privacy. Could you do a video for raw beginners in understanding that relationship please covering the technical aspects? More videos the better! Keep up the great work! Cheers - John

[@AppSheetTraining]

{ }: indicate a List || ex. {1,2,3,4,5} [ ]: indicate a Column || ex. [FirstName] " ": indicate a Text Value || ex. "Hello World" >: usually indicates inserting an expression into a Template || ex. Weekly Report of

[@tehskhemkhongsam1917]

Thank you

[@AppSheetTraining]

You are very welcome!

[@pagevpetty]

27:50 multiple roles Timecard view

[@AneedAnand]

Tq!

[@nileshmehta7540]

How do you restrict display/visibility on the APP of a ENUM values based on user roles?

[@AppSheetTraining]

IFS( ANY(SELECT(User[role],[email]=USEREMAIL()))="Admin", LIST(1,2,3,4,5,6), ANY(SELECT(User[role],[email]=USEREMAIL()))="Employee", LIST(1,2,3,4), ANY(SELECT(User[role],[email]=USEREMAIL()))="Contractor", LIST(1) ) Make the lists the options you want available to that user's role.

[@mmmconcrete5628]

this is very helpful but text looks blur...hard to see.

[@Shucasm]

how can i filtered by Region? like if a belong to US it will show him only that data .not other country data

[@AppSheetTraining]

SELECT(JobSites[ID],[Region]=ANY(SELECT(User[Region],[Email]=USEREMAIL()))) This would return all the 'JobSites' that have their region set to the same value the the user currently using the app has assigned to them. This requires a [Region] table in both 'JobSite' table and 'User' table.

[@pagevpetty]

25:05 Security filters based off USER table with only 2 roles

[@pagevpetty]

IF(ANY(current_user[Role])='Admin', TRUE,[Email]=USEREMAIL())

[@CraigHatton1986]

Need Help!!! I made a slice exactly how it was done on this video when i add it into my security section of the sheet i want to use i just get error unable to find 'Current_User' IFS( ANY(Current_User[Role])='super', TRUE, ANY(Current_User[Role])='admin', OR ([Email]=USEREMAIL(), AND( [Email].[Town]=ANY(Current_User[Area]), [Email].[Role]='non admin' ) ), TRUE, [Email ]=USEREMAIL() )

[@dboywander5855]

I think you need to save after making a slice(Current_User). For it to be a reference data

[@qualityengineer7240]

How to give a permission to behavior button?

[@asociacionquetzal]

Hello, how can I show a user only their data and also not allow to edit certain columns. Thanks

[@AppSheetTraining]

You can add permission constraints in the Editable If section of each column

[@informationtechnology.]

Create to delegation app in user control and dashboard

[@uzairkarim8770]

hello sir, what the mean of True?? I don't have that option in my user data, can i write it down?

[@AppSheetTraining]

the meaning of true? Yes/No (Boolean) fields require a return of type True/False or Yes/No. 1=1 : TRUE YES 1=2 : FALSE NO 1>1 FALSE NO 2>1 TRUE YES [USER].[ADMIN]=YES [USER]=USEREMAIL()

[@heathermarlatt5367]

UUGGGGHhhhh I literally followed along step by step and cant make it work. I think this may be above my skill level

[@pagevpetty]

36:16 Users view security

[@MrPranavsr]

Can Someone help me with restricting the views of certain tables to admin users only? If it is available in this video please refer to the timestamp.

[@AppSheetTraining]

Something like this(in your schema structure) in the Views Display Show If: ANY(SELECT(Users[Role],USEREMAIL()=[Email]))=Admin

[@MrPranavsr]

@@AppSheetTraining Thanks a lot, does "USERROLE() = Admin" does the job or is your recommendation more good than this. If yes, what is the reason. Please give me some clarification. Thanks in advance.

[@mukeshsagar7372]

Hello sir. Will plz help me in creating an app for a college project.

[@AppSheetTraining]

What type of app are you looking to create?

[@pagevpetty]

Vid starts at 9:25 to skip the gibberish :)

[@AppSheetTraining]

We were adding context to the schema of the app so that people can have a more complete understanding of the use case and how they can incorporate these features into their own apps.

[@sandeepkumarjha4600]

Expression IFS(ANY(Current_User[Role])='Super', TRUE, ANY(Current_User[Role])='Admin', OR([User]=USEREMAIL(), AND( [User].[Region]=ANY(Current_User[Region]), [User].[Role]='Non-Admin' ) ), TRUE, [User]=USEREMAIL() ) was unable to be parsed: Unterminated string.

[@sandeepkumarjha4600]

Table as it is you showed

[@AppSheetTraining]

Are you still having trouble with this one?

[@sandeepkumarjha4600]

@@AppSheetTraining Thanks for your reply But I change the code IF( OR( LOOKUP(USEREMAIL(),USER,Email,Role)="Super", LOOKUP(USEREMAIL(),USER,Email,Role)="Admin" ), TRUE, [Email ID]=USEREMAIL() )

[@pagevpetty]

23:11 Current user slice

[@pagevpetty]

Same diff? [Email] = USEREMAIL() suggested by Expression Assistant

[@AppSheetTraining]

@@pagevpetty Yes these will return the same rows for the slice. doesn't matter the order that the two parts of the comparison.

[@JamieLaing1]

Text too small, why so small? Think of all the ways people will view your content.

[@greggapowell67]

Come on guys.... get rid of the head bobbing parrot.

[@AppSheetTraining]

I can’t stand that parrot...