AppSheet 68 - LOGIN DE USUARIOS COMO NADIE TE LO EXPLICO! Paso por paso de VERDAD!

Introduction

In this tutorial, you will learn how to create a user login screen in AppSheet step by step. This guide emphasizes security and user role views, providing detailed instructions to ensure you can implement a secure and functional login system for your app.

Step 1: Create User Registration Table

• Create a new table to store user information with the following fields:
  • ID (unique identifier)
  • Usuario (username)
  • Email (user's email address)
  • Contraseña (password)
  • Rol (user role)

Step 2: Configure Security Settings

• Adjust the app’s security settings:
  • Uncheck the option that requires login.
  • Check the option to make the app public.
  • Acknowledge that the app will be insecure.

Step 3: Set Up User Setting Table

• Create a new table named UserSetting with the following columns:
  • Usuario (Text)
  • Password (Text and required)
• Set data validity for the password field with the expression:

  [_THIS]=LOOKUP([_thisrow].[Usuario], Usuarios, Email, Password)
  

• Specify an error message for invalid logins.

Step 4: Set User Setting View as Default

• Make the User Setting view the initial screen of the app.
• Customize the icon and title for this view.
• Define the target view that users will be directed to after logging in.

Step 5: Remove Cancel Button

• Modify the Cancel button's visibility using the following expression:

  If(In(CONTEXT("View"), List("Settings")), "", "Cancel")
  

Step 6: Rename Save Button

• Change the Save button's label based on the view context:

  If(In(CONTEXT("View"), List("Settings")), "Ingresar", "Save")
  

Step 7: Limit Views for Non-Logged-In Users

• Restrict access to all views by using this condition in the Show If property:

  in(USERSETTINGS(Usuario), Usuarios[Email])
  

Step 8: Role-Based View Restrictions

• Create a slice of the Users table to manage view restrictions based on the user role:

  IF(LOOKUP(USERSETTINGS(Usuario), Usuarios, Email, Rol)="Admin", True, [Email]=USERSETTINGS(Usuario))
  

Conclusion

By following these steps, you will have successfully implemented a user login system in AppSheet that includes security measures and role-based access. This setup not only enhances the functionality of your app but also ensures that users have a secure experience. For further enhancement, consider exploring additional features of AppSheet to expand your app's capabilities.