New to Glide and have a question on how to reference another sheet, but not using a relation.
I have a workout app with two tabs: Users and Schedule (26 week workout schedule with one workout per day). Each user has a “Schedule Start Date” (i.e., Nov 29, 2019) and the Schedule tab then has a workout for each date.
Each user should be able to choose their own start date in their profile and the schedule should automatically update. Originally, I just linked them in Google sheets, but that only works for the first user.
So, is there a way to run this like a DB where some information can be linked between pages?
Also of interest for the same topic is:
- The Schedule tab will have different workout plans (all 26 weeks, but different types). I would like to filter to the plan indicated in the User tab. It’s too prohibitive to repeat the 180 rows in the Schedule tab for EVERY user to have their email address for filtering
- I would like to give the user a way to mark the workout as complete, then filter out the complete workouts. It would make sense to have a Log tab and filter that.
the app sits on primus.glideapp.io I welcome any other feedback!