Appsheet Episode 13: How to add Custom User Role and filter views. SIMPLE STEPS 

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 ❤

You're very welcome! i am glad my videos are helpful to you. Thank you for the support!

Heyyyy!! Such kind words! Thank you! I do my best to share my knowledge to everyone. Appreciate the support

It is my pleasure Sir! glad this helped you. Do let me know if there's anything else needed.

Glad you like it! Appreciate the support and hope this helps

And you're one of the best supporters! Thank you for the kind words..this made my day 😄

Glad it was helpful! Appreciate your support

You made my day sir..thank you!

You are welcome! Im glad it worked out well for you

You're most welcome! Glad it helped

That's great news! I'm glad it helped.

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

You are most welcome! there's more to discover and you're on a good start

That's great man! happy to hear it's working well for you

You are welcome! Glad it helped you in some way

Glad you find it helpful! Please try it out and let me know if there's anything you need

@@aris_azhar sure . Thanks again 🙂👍🏼

And you are very kind! Thank you for the support!

You are the best amongst the best!

Thank you Sir! Terima kasih!

Thank you Good sir!

Pleasure is all mine

Thank you! You now have an admirer (thats me) 🙏

You are most welcome!

Hello! You can try to use the same expression in the editable_if section in update behaviour under the data tab..

You're most welcome!

Yes it is possible in that sense. I will try to make another video to replicate your case. Thanks for triggering the thought!

❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

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.

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

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

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

Can you share some more details to this? I have some rough idea but would want to confirm this matter. Thank you!

We can utilize the editable_if constraint if you like... for this i will make a video real soon just for you

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

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.

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

Why yes! there is a way. Let me do a video regarding this.

@@aris_azhar thank you so much. Looking forward to it 🥹🙏

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.

Unfortunately with the default SSO it seems impossible.

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! Nepali date field sounds interesting. Do you have some info on this?

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

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?

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

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