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