# Best way to implement "Family Account" **URL:** \ **Category:** Ask for Help\ **Created:** [January 20, 2021, 2:21am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429 "2021-01-20T02:21:57Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\ **Post date:** [January 20, 2021, 2:21am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/1 "2021-01-20T02:21:57Z")
I have an app that creates little prompts for parents and kids, currently tailored for _one_ parent. I’m getting feedback from my users that they wanna be able to login as a family instead (like netflix, where they can add both parents). I’m still thinking about the actual jobs to be done here but I’m wondering how you’d go about letting 2 users share the same instance of glide app data and experience? Would you still require them to login as individuals and then you’d somehow link them on the google sheet side? my app: [https://app.edupine.io](https://app.edupine.io) Thanks ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 20, 2021, 4:11am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/2 "2021-01-20T04:11:40Z")
This is an interesting challenge. How much of the data would a family account share together? ---
**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\ **Post date:** [January 20, 2021, 4:34am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/3 "2021-01-20T04:34:24Z")
- their child(ren) - past and upcoming parenting prompts How I’m thinking so far: ![Screenshot 2021-01-20 at 12.30.50 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b4e6271397abdf1ddf144d6b0c833ec60e08aeb2.png) and when the 2nd parent receives an invite link, their fiirst time sign up/in flow will look like: ![Screenshot 2021-01-20 at 12.30.53 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5ee3403d270bef743ad109d5d334145d74ea51f4.png) so that when i filter content i can use the condition “email is signed in user OR email is spouse\_email” ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [January 20, 2021, 6:37am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/4 "2021-01-20T06:37:37Z")
How I would approach this: I would create another sheet for families and on the user profile sheet, I will have a new column called “belong to which family” for each user During onboarding, a user could select his own family from a choice component if their family already exists/create a new family in the family sheet using a form. This would add the family name in the choice component. That way every subsequent member of the same family could select their existing family name. Now all the visibilities inside the app could be configured on basis of the family column so each person belonging to the same family views the same things and users can always add new users to the same family. Let me know if you need more clarity. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 20, 2021, 11:43am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/5 "2021-01-20T11:43:07Z")
Yes, this is a smart method. I should probably update my bankit app template with this workflow. Thanks @Manan_Mehta ---
**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\ **Post date:** [January 20, 2021, 1:12pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/6 "2021-01-20T13:12:14Z")
I am looking at the same issue with an app I am currently building. I am considering the option that the first account has the option of emailing an invite to other family members with a unique family ID that can be pasted into the app to link the accounts via a family table. I am also creating a separate child table so the adults can add them into the family group as they will not have their own sign ins. This is the next item on my to do list, I am thinking it will open up a can of worms. ---
**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\ **Post date:** [January 22, 2021, 2:53am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/7 "2021-01-22T02:53:02Z")
I really like that idea, thanks for sharing. Gonna try it out ---
**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\ **Post date:** [January 24, 2021, 8:32am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/8 "2021-01-24T08:32:52Z")
what would the unique identifier for each family be though? if it’s name, i’m thinking that’ll require some real time validation to make sure it’s not already taken ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 24, 2021, 9:51am UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/9 "2021-01-24T09:51:22Z")
On the Sheet for families, I assume you can add a rowID/unique value when you create them and use that as the unique key. ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [January 24, 2021, 12:00pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/10 "2021-01-24T12:00:27Z")
What about to families with the same family name? If the ID is the rowID, how would a new member distinguish which should select from the choice list? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2021, 3:11pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/11 "2021-01-24T15:11:03Z")
I’ve been working on something similar, but with vehicles and owners. A user can add new vehicles to their account and the vehicle is written to the sheet with the owner’s row id in an owners column. Using the row id in the user sheet, I can create a relation to the vehicle sheet easily. When a user is viewing their list of vehicles, I added the vehicle row id on the screen as well as a qr code of the vehicle row id (for when we get barcode scanning). Whenever a user wants to share one of their vehicles with another user, they can share that row id with them. Then the second user can enter the vehicle row id into a temporary field on the screen and it will instantly validate the row id. If valid, they can press a button and then a set column action takes over. Ultimately, my vehicle sheet has a column that holds the owner id, but this column can hold multiple values in a pipe delimited format. A split text column splits those owner id’s on the pipe delimiter to give me an array of owner id’s that I can use for the relation from owners to vehicles. To build that list of owners, when a user enters the shared vehicle id, I then have a relation to link the entered id to the matching vehicle id in the vehicle sheet. Then I have a lookup column to pull back the owners list for that vehicle. Then I create a template column that joins the existing owners list and the new owner id from the currently signed in user. When the user clicks on the button, the template column overwrites the owners column via a set column action through the relation. Now the vehicle has two owners and both owners can view and work with that vehicle. I just did all of this yesterday, so I haven’t worked through the process of removing an owner yet, but hopefully this gives you some ideas. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 24, 2021, 3:26pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/12 "2021-01-24T15:26:29Z")
Using Jeff’s idea above, I assume if the initial choice has to be through a choice component, then you can show the ID alongside the family name in a template column. Another way is to let the initial user share the ID and then new users type it in a user-specific column for validation, then submit it. ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [January 24, 2021, 3:53pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/13 "2021-01-24T15:53:30Z")
I was thinking the same thing. What about using the idea of invite codes instead? Similar to Jeff’s idea, but making the “invite code” shorter. I’m working on an app now with the same issue of adding people to different groups. I used a GSheet formula with the LEFT function to shorten the RowID then add the number of the row to ensure it’s unique. Not sure if there’s a Glide MATH function equivalent. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51f077de235f1111339af3642db217af8c5a5281.jpeg) ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 24, 2021, 4:00pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/14 "2021-01-24T16:00:41Z")
I don’t know if this will help, but similar to Lisa’s solution - I use this to create my own invite codes: > **[Google Sheets - Random Alphabetic, Random Alphanumeric and Random Alphanumeric...](https://www.google.ca/amp/s/yagisanatode.com/2018/08/23/google-sheets-random-alphabetic-random-alphanumeric-and-random-alphanumeric-character-custom-functions/amp/)** > > Google Sheets, Google Apps Script I was working on a Spreadsheet in Google Sheets a few days ago and needed to generate some random codes for my users. To do this, I just used the RANDBETWEEN(start val, end val) function built into Google Sheets. It... ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2021, 4:08pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/15 "2021-01-24T16:08:09Z")
Here’s a couple screenshots of what my screens look like so far. Once the barcode scanner is released, then I’ll be able to easily scan a barcode instead of typing in the code. Current owner vehicle ![Screenshot_20210124-100345](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3da8b6f612a0958eb9aae252d41a26b458d64a2.png) Second user adding new the shared code. ![Screenshot_20210124-100442](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4384e1dc3a62f497c82ad057f97224f656411db6.png) ---
**Author:** ![Sina\_Meraji](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sina_meraji/32/7160_2.png) [@Sina\_Meraji](https://community.glideapps.com/u/Sina_Meraji)\ **Post date:** [January 24, 2021, 4:24pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/16 "2021-01-24T16:24:43Z")
I’m thinking of a simpler way that doesn’t require creating a Families sheet. In the users sheet, I’m thinking of adding a partner\_emaip sheet where I can add the email of a person’s partner, so that on each screen, I can filter by email == signed in user OR email == partner\_email and have one copy of the data that is shared between two users. May need some relation columns that’ll mirror first parent’s data on their partner at runtime ---
**Author:** ![profechef](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/profechef/32/221_2.png) [@profechef](https://community.glideapps.com/u/profechef)\ **Post date:** [January 24, 2021, 4:40pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/17 "2021-01-24T16:40:28Z")
While the barcode scanner is released I 've used the idea in [this post](https://community.glideapps.com/t/qr-code-scanner-demo/11620) to implement it in an app ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2021, 5:14pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/18 "2021-01-24T17:14:21Z")
I’m in no rush to wait for the scanner. It’s more of a personal project to be used for myself and a few others. I may expand it to others in the future, but for now, I think I’m limited due to proper data security. I had to remove Row Owners on some sheets to make this work how I wanted. ---
**Author:** ![ehdubya](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ehdubya/32/24087_2.png) [@ehdubya](https://community.glideapps.com/u/ehdubya)\ **Post date:** [January 24, 2021, 5:43pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/19 "2021-01-24T17:43:33Z")
Would using a scanner limit “proper data security”? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 24, 2021, 5:50pm UTC](https://community.glideapps.com/t/best-way-to-implement-family-account/21429/20 "2021-01-24T17:50:38Z")
No, a scanner wouldn’t limit security. It’s just that in my particular case I had to remove row owners because I wanted to add an owner to a row, but they need access to that row in the first place before they can be given access. It’s just something unique to my special case. I just mentioned security because I’m not in a rush to find workarounds for a scanner because with the way my app is set up, I feel it’s not secure enough to share with a widespread group of people. [Next page](https://community.glideapps.com/t/best-way-to-implement-family-account/21429.md?page=2)