Appsheet Episode 13: How to add Custom User Role and filter views. SIMPLE STEPS
Вставка
- Опубліковано 26 сер 2024
- Hi, thanks for watching this video about Google Appsheet!
In this video we’ll walk you through:
- How to add your own custom user role
- Hide views for certain user types
Formula
IN(LOOKUP(USEREMAIL(), [YOUR TABLE HERE], Email,Role), LIST("ADD YOUR ROLES HERE WITH COMMAS"))
______
The example used in the video is the following :
IN(LOOKUP(USEREMAIL(), User Manager, Email,Category), LIST("Rejected","Admin"))
ABOUT THIS CHANNEL
My channel is about Technology and General videos. We cover lots of cool stuff such as Appsheet tutorial, highlights and day to day stuff.
Don’t forget to subscribe!
This is how tutorials should be made, most people talk to much, cook your brain and you learn nothing! You are awesome sir! This was a perfect tutorial!
This comment is something i will cherish forever in my heart. Thank you for your support. This drives me to make more videos!
That's right ! So clear, calm, and well organised. But were does our favorite teacher comes from ? India ?
@@LionelCOSTE oh my! Just realised i havent responded to this..i am from Malaysia 🙏
But you are using Tamil Nadu sign 🙏 to respect the other person ❤
I really thank you I spent 6 hours trying to understand appsheet, 6 minutes of your explaining really equals eight hours of other people explaining. you are really terrific and amazing person
You're very welcome! i am glad my videos are helpful to you. Thank you for the support!
Thank you so much for explaining that
Your videos have taken the top spot for my Appsheet training! Thank you very much for taking the time to make and share them.
You are the best one with APPSHEET Tutorial. I SWEAR!
Heyyyy!! Such kind words! Thank you! I do my best to share my knowledge to everyone. Appreciate the support
This is the best explanation for user role. Thanks so much
And you're one of the best supporters! Thank you for the kind words..this made my day 😄
Awesome, Thank you sir for this I watched your videos due to need to explore appsheets capability and you made it simple to understand..
You are most welcome! there's more to discover and you're on a good start
man, tnx for the very understanble description. I'm an MS patient and this was very helpfull to me. thank you. wish you all the best!
It is my pleasure Sir! glad this helped you. Do let me know if there's anything else needed.
Actual useful content. Thanks
You made my day sir..thank you!
Good Job! I have now a functional working Admin user views.
That's great man! happy to hear it's working well for you
Thanks for the tutorial being straight to the point !!! Appreciate it !
Good job, Thank you for explanations.
I wonder if you could show us how to use the user manager table in order to set only admin as "ALL_CHANGES" and customer as "READ_ONLY.
Thank you
Excellent tutorial , concise and very clear.
Glad it was helpful! Appreciate your support
Ill try it now, its a very good solution
Thank you Good sir!
This was straight forward explanation, very helpful indeed.
Glad you like it! Appreciate the support and hope this helps
This was very well explained! thank you so much aris
YO WTF NO WATCHED THE SAME VID AAHAHAHAHAHAHHA
@@syednazrinsyednurshadir9789 AYYYYYYYYYYY MA MAAAAAAN HOWWWWWWW🤣😂😂😂😂😂😂😂
You're so welcome! Glad you enjoyed it..it's my pleasure
That's exactly what I was looking for. Thanks you so much!!!
You are welcome! Im glad it worked out well for you
I was looking for this.... thank you very much
That's great news! I'm glad it helped.
Thank you so much for your explanation.Top
You are welcome! Glad it helped you in some way
What if we give a group of clients a QR code to download this app, and we have a user view for users only? Then how to do that... for upcoming users
Hi I tried this but not working with custom view. So I want some users not to see referenced tables in a custom view
Is it possible to create a login menu and role without needing to sign into your Google account?
Worked pretty well! Thank you!
Amico mio sei bravissimo! Continua così. My friend you are very good! Keep it up
And you are very kind! Thank you for the support!
what if my table if system generated reference to other table, and I just want to hide to certain users that specific system generated table?
Can you share some more details to this? I have some rough idea but would want to confirm this matter. Thank you!
Thank you so much for explaining that 💐
You're most welcome! Glad it helped
What if I have a dashboard view.I tested it but does not work with dashboard view
Very helpful .. will try it out . Thanks for video 🙂👏🏼👏🏼
Glad you find it helpful! Please try it out and let me know if there's anything you need
@@aris_azhar sure . Thanks again 🙂👍🏼
I am a manager, and I have subscribed in AppSheet Core plan, I have 10 employees, and I want to let them use my app just to fill out a specific form, and view all the app content without edit anything else just fill the form, do you have any idea what should I do?
Pls create a vedio sr no . App sheet me admin user or staff user ko different sr no show hote jab hm user email ke dawar show krtate h. Pls create a vedio this topic.
Thank you
You are most welcome!
Hello sir i have a issue my appsheet app pdf is working only android in ios device i have facing a problem to open new pdf its when i was generate new pdf its shows old one not new kindly suggest any solution
Does this work the same way if you want to control the data not just groups of data. Like in a crm the agent can only see what they have entered vs an admin they can see everything?
Yes it is possible in that sense. I will try to make another video to replicate your case. Thanks for triggering the thought!
You are the best! OMG!
You are the best amongst the best!
Questions: How do I add a Login screen, How do I include a password and check if is correct, how do I add more paramiters. I build an app for hotels and I want every user to be able to view One hotel and from that hotel some deparments. How can I create such filter?
Thank you!
Login Screen is possible, but someone (can't mention names, im sorry) told me it's not recommended since they already have the login connector. But what you can do is set the role. I tell you what, let me do a video for this.
good ,thanks
Pleasure is all mine
congrats, U got a subscriber
Thank you! You now have an admirer (thats me) 🙏
Ty for videos ...But I want to know ..if I used a app for location tracking from different user by Email ID ..and I want each user see only own data and admin see all email id data ...so pl share me user role and admin role formula...pl
Hello, for this to work you can set user filter at slice. But before that, ensure every data has it's owner recorded. May i suggest you have a column named "Added by" and user the USEREMAIL() formula. So that everytime a data is added by the user it captures their email as well. Then in slice you can use -- and(contains(useremail(),[added by], isnotblank([added by))
There are many other ways to do it, but you can try this one first
Thanks for your great video. I'm looking for adding payment button (i.e., My customer Scan the QR code in my Appsheet to pay the services booking. After scanning, it link to my Bank account where customer can pay promptly.). Would you mind sharing the video about this one? Thanks in advance.
Useremail() é uma função? Ou é uma coluna que vem de alguma tabela?
hey bro just learning this app but then mine didnt went out as your tutorial This formula is not evaluated in the context of a row, so column values are not available. it shows that how can i possibly fix it
Hey man, i would love to see more info on this issue. Can send me an email to arisazhar.digital@gmail.com
I'll see what i can do to help
hi mr aris. wanna ask. how to restrict role once you are not an admin?
means that, if i am admin, i assign others as employee. but my employee should not have access to change themselves into admin role.
Hello Bossku! Yes there's a way and to explain it i'll make a video just for you soon! Today or tomorrow it'll be posted
I've tried all the codes from your videos in user log in to this video and all of it does not work.
It is Cool.....thank 👍
Thank you Sir! Terima kasih!
Is the role restriction available only in paid licenses?
Thanks
You're most welcome!
How do you restrict display/visibility on the APP of a ENUM values based on user roles?
i personally would prefer creating a separate table for this since i can add a user role column which will display according to the assigned role. Explaining here would be difficult, i will make a video on this next few days.
Alternatively some would go for Valid_if expression. Hang in there! i will make one soon on this matter.
Hi Aris,
This is great! How can we use this or similar expression to control "Are updates allowed?/Are adds, deletes and updates allowed?" in table settings in Data?
Hello! You can try to use the same expression in the editable_if section in update behaviour under the data tab..
Dear Aris Azhar ji ! How to create Nepali Date field in Appsheet ?
Hello! Nepali date field sounds interesting. Do you have some info on this?
very informative but how about I have bunch of DATA in a table and I want each individual to see their OWN DATA. Do we have a formula for it?
Why yes! there is a way. Let me do a video regarding this.
@@aris_azhar thank you so much. Looking forward to it 🥹🙏
My app sheet account is publisher pro plan, so I can't this way. Do you have another way please.
Pro plan is possible to be honest since i've tried this for free version too. i have tried both free and enterprise license. All working well
TQ, awesome
In this scenario, views can be hidden from the user, but if the user enters the link of this view in the browser, they can still see this view. How can we prevent this?
Hello there! you have a valid point i agree. This would require security filter for respective tables and that inspires me to do for my next episode! thank you!
waiting for this vid! thx @@aris_azhar
AMAZING love it
Could the member use a phone number or password, instead of a email to login into the app? thank you
Unfortunately with the default SSO it seems impossible.
There is a limit of 10 user only. What you have any solution for that ?
Can we give more than 11 role in appsheet in free version
Unfortunately that's the limit for free version. A temporary solution would be clusters of the same app for different group of users maybe? But thats a lot of work when there's changes or enhancement. Have a chat with any of their representatives, Google is always kind and generous in giving good deals
How if i want the user can change their data only,
We can utilize the editable_if constraint if you like... for this i will make a video real soon just for you
bang, kalau kayak gini nanti user employee malah bisa milih role sebagai admin nanti.
kalau bikin login page aja bisa gak bang?
jadi di database kita tentukan login A sebagai user dan login B sebagai admin.
lalu ada login page nya.
yang login pakai informasi tabel A maka role nya sebagai user.
yang login pakai informasi tabel B maka role nya sebagai admin
Bila page/view untuk pilih role sudah disetkan hanya admin saja boleh lihat maka ngak bisa employee biasa pilih role admin mas.
Login page bisa juga, atau "User Management" table dimana role selain user biasa ditentukan dan filternya dihasilkan dikesemua views
@@aris_azhar betul bang, apabila suatu page sudah di set kan hanya admin saja yang boleh lihat, maka employee tidak bisa lihat.
maksud saya, nanti misalnya employee pergi ke user manager tab, lalu ganti role nya menjadi admin, seperti apa yang telah abang tunjukkan diatas, berarti page yang semua hidden, akan tampil kan bang?
Di video diatas abang ganti role dari employee ke admin dengan mudahnya.
tanpa perlindungan password.
berarti jadi nggak secure bang?
karna user employee sesiapa pun dapat dengan mudah apabila hendak menjadi admin.
mereka hanya perlu pergi ke tab user manager, ganti role nya dan tab panel admin pun bisa diakses.
bagaimana bang?
@@RianHidayat-cz7yi benar, jadi bagi user manager tab tu pun bisa set hanya admin sahaja yang bisa lihatnya. Di tutorial yang saya buat sengaja saya biarkan tanpa admin filter bagi kemudahan dalam video sahaja.
Dalam practice yang sebenar sila tambahkan filternya di user management sekali bang.
Hello I've Got a mistake "If the app uses the USEREMAIL() function, it must require users to sign in." do you know why?
Hello, yes, that is normal for the error to occur if your app is set to public. You may want to change it to "Require User sign in" . Useremail() is a function that captures the email address logged in.
@@aris_azharHello if my app is login based on the data on the spreadsheet do I remove the USERMAIL() or change it?
Bang gimana caranya agar yang sudah login auto kena logout pada waktu tertentu? Soalnya kalo sudah log in biasanya mereka gak log out lagi
❤❤❤❤❤❤❤
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
how about hide certain functions like EDIT, DELETE?
SWITCH(
LOOKUP(USEREMAIL(), "Funcao", "Email", "Funcao"),
"Admin", "ALL_CHANGES",
"Gerente", "ALL_CHANGES",
"Atendimento", "ADDS_AND_UPDATES",
"Assistente1", "UPDATES_ONLY",
"Assistente2", "READ_ONLY",
"Producao", "READ_ONLY",
"Financeiro", "READ_ONLY",
"READ_ONLY"
)
Onde vc tenha uma tabela Funcao com os campos de Email e Funcao (que define suas permissões) .. aí nesse exemplo que dei acima vc consegue restringir bastante.
How to filter email address that is not in the table?
If the user is not the list and part of any roles you assign by right they can't view that particular page that you have set the "show if" condition
if need more assistance do let me know
How to hide show view in public appsheet sharing.
Is it possible to generate PDF receipt and share the pdf on WhatsApp?
It is possible to generate PDF Mr Ganesh, i will do a tutorial for it soon but in the meantime basically you need to :
-Create a Receipt template
-Automate whatsapp message using api.whatsapp.com with ENCODEURL()
Thank you so much Mr Aris Azhar, I'm waiting for that tutorial.
Also, i have one more doubt, I'm having a table with three columns, one is employee name and next one as month and last one as salary drawn. I want to calculate the sum of salary with respect to month for all employees, which means multiple rows having same month. How to perform this task.
Thanks in advance.
@@ganeshramu5083 pleasure is all mine Mr Ganesh. Anyways for the sum of salary you can either use
- Virtual columns with the right expression
- Sum directly from the view (UX) where you can actually group by and group aggregate with count or sum..
this is basically the theory and i will do a tutorial for it within 24 hours just for you
@@aris_azhar Thank you for quick response
@@ganeshramu5083 the pleasure is all mine sir
Hi I tried this but not working with custom view. So I want some users not to see referenced tables in a custom view