Struggling to link screens and tables with relations

Hi, I’ve been trying for some hours (and failing), to get my action button to take the user to the right place. It had been working but I accidentally deleted the button and don’t seem to be able to rebuild as easily. So I have a screen with a button that is supposed to, when clicked, take the user to a list of templates, from which they then add any that they want to their own list. I have a master table with all templates and I have a table with each ‘user’ listed but I cannot get the master list to appear in the dropdown menu. It is only showing 2 basic text columns from the table from which the user starts on. No row id options either… I hope that makes sense to somebody? I’ve been asking chatgpt and copilot and watched the Glide tutorials but can’t find the answer. Thanks to anyone with the patience to read this.

Have you gone through Glide Docs? I would recommend you take the time to read through this and watch some of the videos, especially the ones on relations, buttons and workflows.

1. Design the data model first

Start with clearly separated tables:

  • Users: one row per user (add a rowID, and collect the user’s email, name and other info you want here).
  • Templates (Master): one row per template available to all users.
  • User Templates (or “My Templates”): templates that each user has added to their own list.

2. Set up relations and lookups

In the Glide Data Editor:

  • Create a relation in ‎User Templates:

    • From ‎User Templates → Template ID
    • To ‎Templates → Template ID
    • This lets you display master template details from the user’s copy.
  • Create a relation in ‎Users:

    • From ‎Users → User ID
    • To ‎User Templates → User ID
    • This lets you show “My Templates” as a collection on a user profile or home screen.

3. Build screens bound to the right tables

In Glide, what you see in dropdowns and actions depends heavily on which table the screen is attached to.

  • Start Screen: attach to ‎Users (or ‎User Profile) so each user sees their own data.
  • Templates Screen: attach to ‎Templates so you can show the full master list.
  • My Templates Screen: attach to ‎User Templates so each user sees only their selections.

4. Define the action flow for “Add from master templates”

Your desired flow:

  1. User taps a button on their main screen (“Browse Templates”).
  2. They go to the Templates (Master) list.
  3. From there, they tap “Add” on a template.
  4. An action creates a row in ‎User Templates linked to:
  • The current user.
  • The chosen template.

Implementation approach:

  • On the main user screen (bound to ‎Users):

    • Add a Button: “Browse Templates”.
    • Action: Navigate to Tab → Templates (or “Navigate to New Screen → This item”).
  • On each template row (in ‎Templates list):

    • Add a Row Action or Button: “Add to My Templates”.
    • Action: Add Row to ‎User Templates with:
      • User ID: set from ‎User Profile → User ID.
      • Template ID: set from ‎This Item → Row ID.
      • Any other fields you need (status, created at, etc.).

This avoids needing the master table in a dropdown: you navigate to a screen already bound to ‎Templates, then create the linkage via IDs.

Examples

Example tables and relationships

Users

Column Name Type Example Value
User ID RowID U001
Name Text Emma R
Email Email emma@example.com
Role Text Member

Templates (Master)

Column Name Type Example Value
Template ID RowID T001
Name Text Weekly Planner
Category Text Productivity
Description Text Plan your week…
Active Bool true

User Templates (User’s own list)

Column Name Type Example Value
User Template ID RowID UT001
User ID Text U001
Template ID Text T001
Custom Name Text My Week Plan
Created At Date/Time 2026-02-07