Hello, I am in the process of creating an app, and given the countless hours of work I’ve put into it, I would like some clarification on a few issues. It will be a fitness app that includes training and possibly diet or nutritional advice. Data such as weight, height in centimeters, and gender will be requested, and the process will be step-by-step. The workouts will be progressive. I will need many columns for each athlete. The app will be offered in various countries, including the United States. There will be a list of workouts that clients can purchase, or there might be customized training options.
My concerns are regarding sensitive data. Do I need to include any type of contract or agreement within the app? Also, is there a limit to the number of columns per user? I believe there isn’t. Will a high number of columns cause any slowdown in the app’s performance? In that case, would it be possible to host up to 20,000 users, with approximately one user per row? The Maker plan seems to be the most suitable for my needs, correct?
Thank you in advance for your response.
Please be careful about the “Health information that is not covered by HIPAA” section.
There’s no limit.
If there’s a lot of calculation happening then it might be, but how many are we talking about here? There are apps running with 500+ columns in a table from what I recall in this forum.
Sounds like a yes, but wouldn’t you need to store rows for training/diet/nutritional advice as well? How do you handle the rows limit for Glide Tables/Google Sheets if you’re on Maker?
Yeah, but you’re limited to personal users.
2 Likes
Thank you very much for your response. Actually, I will have two ways of selling the services and, therefore, providing access. I will have about ten standard training programs, designed according to the target niche. There are several months of training, and each week, the training data changes. It’s a step-by-step process. For this reason, I need many columns that won’t perform calculations but will contain notes for the training diary.
When I find clients who want a personalized training plan, I will request health-related data through Google Forms. I will include a link that connects to the external questionnaire. Other data will be used by the athlete themselves for self-assessment. The calculations that will be performed are averages, or there will be formulas to calculate caloric needs based on the responses given by an athlete. I don’t think I will face major issues with this.
For diets/nutritional advice from the nutritionist, the same approach as training (private or standard) will apply, but I have some doubts, so I’m not sure if I will include diets. In the case of personalized services, I will manually add rows, as I have noticed that updates are also limited (500 updates). That’s basically it.
If you use a Google Sheets in tandem with your Google Form, syncs will also be counted as updates.
I will never use Google Sheets in tandem with your Google Form. That will be for private services. I will add the exercise row only after working on the excel sheet. But I will always insert the rows manually.
So you’ll have to a use a lot of user-specific columns to keep the rows count in the limit? Or do you have another approach in mind, like JSON?