Hi all,
I’m looking to create an app to share fitness testing information with over 200 people. I will need users to be able to sign in and only see the fitness testing information about themselves and not other people. I plan to display the fitness data in charts.
We gather the information in a big testing event and write it in google sheets.
Is this is possible?
Thank you
Developers,
We’re also looking for someone to take this on and help build tis with us?
Thanks,
Hello,
Yes, this is definitely possible and is a very common use case for building apps on top of Google Sheets!
Here is how you can manage your requirements:
1. Sign-In & Personal Data View: This is handled using something called Row-Level Security (RLS). All you need to do is make sure your Google Sheet has a column that contains the unique email address for each person (e.g., a column called “Email”).
• The app will use that email column to match the person currently signed in.
• When a user signs in, the app instantly filters the entire sheet and only shows them the data rows that match their email address. Nobody else’s data is even loaded onto their device.
2. Google Sheets Source: Using your Google Sheet as the data source works perfectly. As you update the sheet after your testing event, the data in the app will update automatically.
3. Charts: Since the data is already filtered down to one person, creating charts is easy. Any chart you build will automatically display the personalized data for the user looking at it.
This is a very secure and efficient way to share personalized reports with a large group. Good luck with your testing event!
This is excellent, thank you.
If its not too much trouble, could you provide a few extra steps on how to solve it?
Happy to chat.
P
I think this tutorial can help you.
you.
Hi Thank you for this. I don’t understand the language though. Trying to go off the visuals.
I should not have 
this post, it’s a confusing mess.
Thank you for all this. I’ll go through it and try my best.
Would I be able to ask for more help if needed?
Thanks,
P
That’s what we’re here for.
Hi Dirk,
I can assist you with building the App. I am quite familiar with AppSheet and have built Apps that we’ve been using for Client Management since 2021.
Warm Regards,
Kathryn
Amazing. Thank you.
Could I ask for a little more help please?
I’ve having trouble setting this up.
Will I need to create a new slice for each person? Or will a sign as a certain email address only select the data for them?
I made an app a while back, wondering if I can re use.
Thanks,
P
Slice row filter conditions - AppSheet Help shows exactly what to do.
I’ve given it a really good go but think I need some hands-on help. Would you be able to help Steve? To clarify, students sign in with their email and only see their own fitness results (with charts). Coaches can see everyone.
Hi DirkDirk,
You can turn on captions to view them in your language.
I can also help you build it. I’ve done something very similar before. We had 5 levels of users, each with different rights
I cannot provide hands-on help.
How do your users “sign in”? Are you using the built-in feature (good, but not free), or something of your own creation (very bad, but free)?
How does your app know which users are coaches and which aren’t?
Does your data source (a Google Sheets spreadsheet?) indicate which row corresponds to which users? If so, how?
Sorry my apologies i hope i haven’t did some mistake
Hi Dirk,
I handled that issue by applying a filter directly to the tables. Very easy and saved me from having to do a lot of slices. You can do this under security filters [Email] =
Wondering how you are going to handle the payment of the app?
Hi APN
There is no payment for the app. This is for an internal project and students of the school I work at.
So, have you built something like this before?