# How do you set your spreadsheet right? **URL:** \ **Category:** Ask for Help\ **Created:** [January 26, 2021, 2:40pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758 "2021-01-26T14:40:16Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 2:40pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/1 "2021-01-26T14:40:16Z")
When building an app, how do you guys go about setting up your spreadsheet? I get easily lost and confused. Which tabs should be there, which one and how needs to be connected? How to get started there? I have seen @Robert_Petitto glide tutorials only and beyond impressed by how he creates detailed functionalities using spreadsheets. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 2:51pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/2 "2021-01-26T14:51:55Z")
The first thing I do is make a user tab. It normally houses email, name, image, and whatever else I think I may need. Second make a tab that houses the type of data your sharing. If it is appointments then start with date and time, location, description, etc. Once you start out and get the hang of it it will all become second nature very quickly and your spreadsheet layout will be the least of your worries. I can tell you my largest app houses 207 spreadsheets with over 3000 lines of scripts/code in it and even though thats a ton I still worry more about the glide end than anything else. ---
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 2:55pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/3 "2021-01-26T14:55:16Z")
wow !! 207 spreadsheets šŸ˜… Do you first set your spreadsheet with all the tabs and everything or go step by step like first make a tab in spreadsheet, then create it glide. Going back and forth? ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 2:57pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/4 "2021-01-26T14:57:17Z")
I try to. This particular one has spreadsheets added almost everyday. The app evolves as requests poor in. At first I would attempt to anticipate the needs but about 4 months in I just accepted that it is what it is. One spreadsheet in particular has 163 columnsā€¦thats the only pain in the ass. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 2:58pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/5 "2021-01-26T14:58:55Z")
But I will say I do make on average 2 glide apps a day and after so many I just build as I go. I try to plan out the complicated stuff but in a lot of cases the attempt is feeble and gets scrapped after I see a better way. ---
**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 26, 2021, 3:00pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/6 "2021-01-26T15:00:06Z")
I agree with @Drearystate. Start small to get your primary screen set up. Need to see a list? Then create a sheet with the basic info you need. Then move on to the next function. Sometimes your initial sheet layout will need to change and you will need rebuild some parts of the app as you go. Donā€™t look at the big picture and think that your sheet needs to be perfect with every function and feature built in from the start. Just start with small chunks, get that piece working, then move on to the next. You will discover that your app flow may change from your original plan as you go. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 3:02pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/7 "2021-01-26T15:02:56Z")
Jeff hit the nail on the head. If you get stuck you have an amazing community here to help in any way we can. We have people that write scripts, people that are amazing at CSS, some great layout junkies, function experts, everythingā€¦just donā€™t hesitate to ask and keep in mind this forum is like non other, we donā€™t argue we just help and recognize one anotherā€™s accomplishments. ---
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 3:10pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/8 "2021-01-26T15:10:02Z")
Thank you @Jeff_Hager and @Drearystate for the motivation. I am trying to create Buy Me coffee clone, so what do I create next after the all users profile section? Should I have a separate tab for collecting user posts data or create one tab with specific user info and posts? ---
**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 26, 2021, 3:23pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/9 "2021-01-26T15:23:10Z")
My general rule for data is to never duplicate data except for a key, like a row id, unique ID, or user email that you can use to link the posts to the user and vice versa. I would have a separate sheet for posts that only contains the unique value of the user who posted and the post itself. A single app tab needs to be attached to a single sheet, but can contain all kinds of data from different sources with proper relations linking all the necessary sheets together. Like I said, just start somewhere and start small, see how things go, and if you decide you donā€™t like how itā€™s working out, you can always change things around. Most people donā€™t create a perfect app on the very first try. My main app has been continuously evolving for 2 years as we get new features or I learn better ways to do things. ---
**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 26, 2021, 3:27pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/10 "2021-01-26T15:27:34Z")
Appreciate the kind words. Just think with the end in mindā€¦ - ā€œWhat screens do I want?ā€ ā€” You can surely have more than one screen per sheet, but usually itā€™s a 1:1 ratio - ā€œDo I need user profiles?ā€ ā€” If so, youā€™ll need a user profile sheet - ā€œWhat layouts do I need?ā€ ā€” As Jeff Hager always reminds us, layouts are tied to sheets. Generally speaking, if you need separate layouts for your data, they should be in separate sheets - ā€œHow many rows do I expect to have in this sheet?ā€ ā€” As I have recently found out, multiple relations and rollup columns over thousands of rows prevent your app from loading efficiently. In this case youā€™d want a separate filtered sheet (using "=filter() or =query() formulas) that run these computed columns OR skip the sheet and use a Glide table There are numerous other factors, but this is how I approach every app I start. ---
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 3:39pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/11 "2021-01-26T15:39:48Z")
It definitely making more sense now to me to have unique ID or email to link and separate tab for posts. ---
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 3:43pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/12 "2021-01-26T15:43:40Z")
I started with glide after your tutorials only. I watch your videos on loop lol. They are so helpful. Big thanks for creating them. I will follow you advice and begin. Thank you for your advice. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 4:36pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/13 "2021-01-26T16:36:33Z")
Lol, the poster child šŸ™‚ ---
**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 26, 2021, 4:37pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/14 "2021-01-26T16:37:17Z")
šŸ™ˆ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 4:39pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/15 "2021-01-26T16:39:32Z")
Itā€™s odd, people always listen to you over any of us. Those tutorials man, I tell ya. I think Iā€™ve made over 400 apps already with dozens in PRO and Iā€™m taken with a grain of salt when Robert speaksā€¦lol, thats life šŸ˜€ ---
**Author:** ![shej](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shej/32/20783_2.png) [@shej](https://community.glideapps.com/u/shej)\ **Post date:** [January 26, 2021, 4:47pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/17 "2021-01-26T16:47:21Z")
Oh dang ! Not at all. Your advice is equally valued, appreciated and taken . Itā€™s just that when someone begins building in glide, they run to youtube first for free tutorials and they come across Robertā€™s tutorials. 400 apps šŸ¤©? Do you have tutorials? Would reaaaaallllly help šŸ„ŗ ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [January 26, 2021, 4:48pm UTC](https://community.glideapps.com/t/how-do-you-set-your-spreadsheet-right/21758/18 "2021-01-26T16:48:59Z")
Robertā€™s the tutorial guy. He takes his time with them and finds time to do them. Competing with his tutorials is just not something anyone wants to take on. Heā€™s been making them for so long we would be the 2nd rate tutorial and no one wants to be that. But he is the face of Glide whether he wants to be or not. Not even the CEO of Glide is known as well as Robert. Iā€™m surprised heā€™s not being paid by them yet.