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.
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.
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?
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
@@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!
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
I have successfully implemented security and user permissions. I have an issue where some users can sign in with their google authentication and they can see what they have access to. Other users try to authenticate then get a 403 error, access denied. All of my settings are the same for all users at the moment and still no luck. Anyone have any suggestions? It is a Google Workspace domain environment in education.
@@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.
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!
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.
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
{ }: 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
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.
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() )
@@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.
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()
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!
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.
@@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! :)
@@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.
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.
@@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() )
Finding this video months later and it's just what i needed. I'll be tuning in weekly
Glad it’s helpful to you! We’ll see you next week!
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.
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.
That’s excellent! I’m so glad you were able to launch your application.
I realize it's kind of off topic but do anybody know of a good site to stream new tv shows online ?
Great job Landan and Clark! Very helpful webinar.
Thanks, Ron! Glad it was helpful.
Excellent Video, the level of knowledge shared here is just unimaginable. I'm subscribing and cant wait for more content like this. Thankyou
Awesome! Glad you are enjoying the content!
Security filter is restricting the view but does it restrict actions also?
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?
For the filters to work, must there be the ‘user’ column in the various data tables?
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
19:04 column constraint - 'Admin'=ANY(SELECT(User[Role]), [Email]=USEREMAIL()))
Thank you!!!
Great job Landan! very well explained.
Thanks Appsheet Training
My pleasure!
@@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!
Hello! can you send me the link where you created first the google sheets?
Fantastic training
Thanks a ton!
May I ask where's the link of the previous video where all the other data is filled in, please?
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
Dude anyway you can help me convert my AppSheet into this
Sir I'm having problem that what condition should I give if their is two admin please help me out for this
I have successfully implemented security and user permissions. I have an issue where some users can sign in with their google authentication and they can see what they have access to. Other users try to authenticate then get a 403 error, access denied. All of my settings are the same for all users at the moment and still no luck. Anyone have any suggestions? It is a Google Workspace domain environment in education.
Great Video. Thanks
Question! Does this work with Calendar views?
This was extremely helpful thanks bro ❤
Fantastic training. Thank you for creating this!
Glad you enjoyed it! Are there any other topics you’d like to see content on?
@@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.
That was absolutely amazing. Thank you for this video.
Glad you found it useful! Did you implement this concept?
- Camron from AST/QREW
@@AppSheetTraining currently applying it on a project that im working on :D
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!
how can i filtered by Region? like if a belong to US it will show him only that data .not other country data
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.
just google it a hour ago and this appear , nice
Awesome! Guess we got it out just in time haha
How to give a permission to behavior button?
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
{ }: 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
How do you restrict display/visibility on the APP of a ENUM values based on user roles?
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.
Amazing video, Thanks a lot😀
Hello, how can I show a user only their data and also not allow to edit certain columns.
Thanks
You can add permission constraints in the Editable If section of each column
Thanks a heap Clarke and Landon !
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()
)
I think you need to save after making a slice(Current_User). For it to be a reference data
Great webinar indeed!
Thank You Haggard! Do you have any ideas for future topics?
@@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.
this is very helpful but text looks blur...hard to see.
Great training! Thank.
hello sir, what the mean of True?? I don't have that option in my user data, can i write it down?
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()
i love it
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!
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.
@@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! :)
Create to delegation app in user control and dashboard
27:50 multiple roles Timecard view
Tq!
This is awesome, Thank you so much
Thank you
You are very welcome!
Hello sir. Will plz help me in creating an app for a college project.
What type of app are you looking to create?
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.
Something like this(in your schema structure) in the Views Display Show If:
ANY(SELECT(Users[Role],USEREMAIL()=[Email]))=Admin
@@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.
25:05 Security filters based off USER table with only 2 roles
IF(ANY(current_user[Role])='Admin', TRUE,[Email]=USEREMAIL())
UUGGGGHhhhh I literally followed along step by step and cant make it work. I think this may be above my skill level
Vid starts at 9:25 to skip the gibberish :)
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.
36:16 Users view security
23:11 Current user slice
Same diff? [Email] = USEREMAIL() suggested by Expression Assistant
@@pagevpetty Yes these will return the same rows for the slice. doesn't matter the order that the two parts of the comparison.
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.
Table as it is you showed
Are you still having trouble with this one?
@@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()
)
Text too small, why so small? Think of all the ways people will view your content.
Come on guys.... get rid of the head bobbing parrot.
I can’t stand that parrot...