Relations in a form

[Jordan_Clevenger]

Hello,

I am working on an application that automatically progresses and regresses clients based on how difficult an exercise is. To do this I have made exercise “groups” which contain numerous levels corresponding with different exercises. For example a “Bicep Strength” group may have 5 different exercises at 3 sets/reps amount each for a total of 15 levels.

My question is: how can I, as an admin, create a user and select which groups I want that user to be able to see, and then select which level it starts with in each particular group? I am able to get the user info and group info to add via a form but cannot figure out how to choose a particular level once I have selected the groups. It feels like a need a form, inside of a form to first add the groups to a row and then create a relation with those groups so I can choose the level.

Has anyone had a similar problem? Any feedback / tips would be great.

[Jordan_Clevenger]

Here is a screenshot of my form I’m using if this helps at all:

[ThinhDinh]

So say you have 15 levels, you can choose for me to start at level 1, level 7 or level 10, something like that?

If you choose level 10 for me, should I be able to view level 1 to 9?

[Robert_Petitto]

Sounds like you need what we call a “custom form” which is just text entry components on a details screen that write to user specific columns. Once those columns are filled in you can do computations on them in Glide data editor (relations lookups etc) which you could then use as values when you go to “submit the form” (button with an add row action).

[Darren_Murphy]

As Bob said, you probably need a Custom Form.
If that’s a new concept for you, you can check the following:

How do I create a custom form?

I’m just dropping this here so I have something to refer people to when they ask. This is a simple concept app (copyable), that demonstrates the following techniques: Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide) Preventing duplicate new entries using User Specific Columns and Relations Enforcing mandatory input items The use of visibility conditions and user specific booleans to control user flow There is nothing particula…

[Jordan_Clevenger]

Ya so for example I might have a “Chest Group” with the following levels in my Exercise Directory

• Lvl 1 | Push up | 3x10
• Lvl 2 | Push up | 3x15
• Lvl 3 | Bench Press | 3x10
• Lvl 4 | Bench Press | 3x20
• Lvl 5 | Flys | 3x 15

Since everyone will be at different starting strengths I need to be able to choose, at the very least, which exercise the person will start with. There will be numerous groups as well. Originally I was trying to do two forms back to back where I could select the groups in the first form, which would put it into the user profile row, and then have the other form to select which level a person will start with for each group. Unable to get it to show just the groups that the admin assigned the user.

I could just create a key for each group that appears and then have the admin type in whichever level they want but some groups have 30+ levels so this isn’t the most user friendly.

[Jordan_Clevenger]

As the admin how can I get the users information to carry over? Do I need to change something in my user profile?

[Jordan_Clevenger]

Thank you for sharing. This is the first I’ve heard of custom forms so I will copy the app and learn how to create the custom form.

[Robert_Petitto]

When doing an “Add row” action, you can select fields from the user profile table.