I have a fitness tracker form to input daily workouts. There is a list of exercises for each muscle group in a separate table which is accessed by this form as enumlist. What I require is for every selection in workout enumlist (for example, squats, lunges,etc) there should be two fields to input reps and sets (for each workout / enumlist selection ) and the underlying google sheet should capture row wise data for every change in enumlist selection. Can anyone help me with this? Thanks in advance
Hi, it sounds it will be quite tricky with this way if you are able to add as many exercises as possible. Would it be better to create this functionality with related table structure so you could add exercises as separate records. Then you could set sets & reps for each exercise individually.
Can you elaborate on how to do that.
Please check this article… https://help.appsheet.com/en/articles/961426-references-between-tables