Create User Lists of Items

Ask for Help
2

You’re on the right track. Here’s what I would do:

  1. In the sheet of items, create a user specific text column called userList.
  2. In your user_lists sheet that you already created, add a rowID column. Create a multiple relation column called rel_userListItems that points the rowID column to the userList column in the items sheet
  3. On the details screen of each item, place a choice component that has a source of the user_lists sheet.
    • Values = rowID, Display = listName, Destination = userList column
    • It should be filtered to where email is the signed in user so each user only sees their own lists.
      from the user_lists screen
  4. Now, each listName has an individualized list of items. Display the rel_userListItems relation in an inline list on the details page of each list created in the user_lists screen
3 Likes