Daily step counter app structure advice

[hantsjoel]

Hi all,

Not a specific problem, just wondering if anyone had some ideas that could set me off in the right direction with an app I need to build.

Our workplace is running a challenge, where each of the 150 employees (divided into 8 teams) will log their daily steps into an app for two months.

I will be using SharePoint as the data source and my thinking was to have an item for each participant with columns for name, team number and a separate column for each day of the challenge, into which each day's step counts will be patched. I understand, though, that when doing a patch, column names can not be dynamic so I will need to have a separate textinput and formula for each day of the challenge...61 in total! 😮 

An I right in my thinking? Does anyone know of a smarter way of doing this?

Many thanks!

Joel

[jlindstrom · Accepted solution]

I would make this two lists

List 1 Team that has the team information

List 2 Team Steps: includes a lookup to team, the date, and step total.

so when you patch the daily step totals, create a new record in list 2 for the team steps.

you can the display this Ina gallery just like it was on one list

[ajdhingr]

Yes, creating 2 list is a  good idea and you can create an APP directly from List 2 for users to input the data. 

[hantsjoel]

Thank you @jlindstrom and @ajdhingr. Great idea and just what I needed. I've gone for a central list to hold the team and team member details and a list each for the 8 teams creating a new item per person per day for step counts.