User-Specific Data Example

Login
Demo Users:
  • Username: 1, Password: pass1
  • Username: 2, Password: pass2
  • Username: 3, Password: pass3
User-Specific Data Filtering

This example demonstrates how to filter Google Sheets data based on the logged-in user:

How it works:
  1. Log in with one of the demo users (1, 2, or 3)
  2. The system retrieves all data from the 'user_data' sheet
  3. It filters the data to show only rows where 'user_id' matches the logged-in user's ID
  4. The filtered data is displayed in a table
Important:
  • Make sure you've imported the sample_user_data.csv file into a sheet named "user_data" in your Google Spreadsheet.
  • The 'user_id' column in the user_data sheet should contain numeric values (1, 2, 3) that match the 'id' column in the users sheet.
Back to Main Page