I’m pretty excited at how quickly I can crank out and visualize some ideas.
I’m curious though, if I build an app and share it with 5 people how can I contain the data for each person? For instance if the app is a “call my Mom” app, the intention is that each user will put in data for their mom, not just call my Mom, she wouldn’t like that. Maybe I’m missing something, It’s not clear how to me how to have a personalized app. Do I need to build a unique app for each user?
I hope I’m explaining this clearly.
If I had a budgeting app, I wanted to share, how do I keep unique data for each use? Make sense?
It’s pretty cool to see things working so quickly.
Hi. Nope you’re not missing anything. Basically, you need to design your spreadsheet based on the idea you have in mind. There are two approaches.
So each entity will have a sheet in your google spreadsheet. In your case, e.g. “Person” and “Mom”. You will relate a record in Mom sheet with one or more records in Person sheet (Mom can have multiple children who are your users). For this, generally both sheets should contain a unique ID (PersonID and MomID). Then Person row will have a MomID that attaches a person to mother. Then from Data tab in glide, you will create a relation column in either sheet based on your need on MomID field.
All data in one sheet. In this case, Mom record will repeat for each child you have as a user. Advantage is this approach is easier for starters.
Thanks for your suggestions Jeff. It makes sense but still not a great long term solution. I can see how this will help me to visually explore my concepts a bit more.
Are you familiar with Relational databases or entity relationship model? I come from that background thus I separate out entities and tie them with relations (1 to 1, 1 to many or many to many).
I’ll certainly explore these options.