How can I display a grid composed of different fields on a form? Is there a way to do so?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
To do this natively on the form, put each ___ as a field like bench_set, bench_rep, etc. Then put those on the same line in the form elements page. 
Photo of Chuck Grigsby

Chuck Grigsby

  • 1,978 Points 1k badge 2x thumb
Another way is to have a table of Workouts, then the form consists of fields like Type (Curl, Bench), Sets, Reps, and Weight,. Then create a grid edit report. Could just use the report on a page or place it on another form. Edit mode would show grid edit, View mode would show the workout report.
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb
I think that would work, making a grid report and displaying it on this form. 
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I've built a gym management app, as part of it we create and manage the workout programs.

This is actually the app that we won the 2017 App-a-thon with at Empower.



This is only a fraction of what it does.  But should give you some ideas.
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb
Thanks Matthew, so with reference to my application, should I construct the fields Reps, Exercise, Set, Weight as fields? 
Photo of Raj Helaiya

Raj Helaiya

  • 1,298 Points 1k badge 2x thumb
As I also need a dashboard with analytics from these fields. 
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Are you looking for analytics on the types of movements they are performing, frequency, etc.  Or on the weight used?  Every sessions weight, or just the max used in the cycle?

How you construct it depends on how you want to use it, and how you might want the end user to interact with it.  I've done a few different versions for different needs.