User Levels and Choice components

Ask for Help
1

Hey all!

Hoping for a bit of assistance. I have a fitness app and am trying to utilize user levels to determine exercise choices. Here is an overview:

I have a users tab. Each user has a level.

I have a tab for exercises. Each exercise has a category and a level.

I have a tab for workouts. Each workout has a category. I have a relationship setup that pulls multiple exercises from the exercises tab based on category. When a user does a workout, I have a choice component that allows them to choose which exercise they would like to perform.

I’d like to have this choice component filter out exercises based on level. For example, If a user is level 1, then only show level 1 exercises from that category.

Does anyone have suggestions on how to accomplish this?

Thanks in advance!

2

So:

  • Users sheet has a level column.

  • Exercises sheet has category and level columns.

  • Workouts sheet has categories, you then have a relationship that pulls the exercises to this sheet.

When a user does a workout, they go to the workouts sheet and currently have a choice column, is that correct?

3

Would this work? Just a wild idea, I think someone can chime in with a better method.

From the relations that you have in the workouts sheet, let’s say you have 5 levels. Make 5 choice components that would be filtered based on the exercise’s level and set visibility to only show when User’s Level is 1, 2, 3, etc.

4

@ThinhDinh

Thanks for taking the time to reply!

Yes, when a user goes to the workout sheet, they have a choice column.

I have actually considered the setup you are talking about. But how would I make a relationship based on category and level?

5

I think you need something like this demo APP:

Saludos

6

I have added the 2nd comment, I don’t think it’s good when you have too many levels, that would be too many choice components to set up but I think it would work for your case. Sorry it’s pretty late here so maybe I can chime in with a better workaround tomorrow if no one else has come up with it.

7

That suggestion did the trick. I greatly appreciate you taking the time!

1 Like
8

I imagine your workout tab is a list of categories and you select one to view it’s details? If so, I think you could create a single choice component to select an exercise. First you would create a template column in the workouts sheet that joins the category and the level from the user profile. In the Exercise sheet, you would create a template that joins the category and level in that exercise sheet. Then you can create a relation in the workouts sheet that joins the 2 template columns. The relation would be used to populate the choice component.

This should scale nicely if you ever add additional levels and you only need one choice component.

2 Likes