Notion Databases: Workshop

22
53



Go from Notion Zero to Notion Hero, with our new 24+ lesson course:

Take control of your Notion databases. Learn how to optimise boards, tables, gallery, tables and lists inside of Notion and how to use all the database functions in Notion interactive elements. Notion has plenty of brilliant databases to take advantage of and begin applying to your account, so fingers crossed this video helps you dominate them.

▶ Get $25 Sanebox credit and a free trial:

This week has been sponsored by Sanebox, I reached out to them to discuss the sponsorship as a happy user and they were more than happy to support the Keep Productive channel.

Get everything on Notion here:


▶ GET 2 MONTHS FREE SKILLSHARE with all classes
Our latest Things 3 class:

▶ DEALS/OFFERS for the productivity apps and tools
New added weekly:

▶ DISCOVER MORE
🎙 Subscribe on iTunes:
🏠 Join the Facebook Group:
📧 The monthly newsletter:
📋 Get 2-months free Skillshare:
📅 Contact Francesco direct: francesco@keepproductive.com
📷 Follow Francesco on Instagram:

▶ EQUIPMENT USED
📋 MacBook Pro 13’inch TouchBar:
(UK: (US:
📋 Camtasia 9:
📋 Blue Yeti Microphone:
(UK): (US:
📋 Newer Lighting Set:
(UK: (US:
📋 Canon 70D:
(UK: (US:
📋 Rode Shotgun Mic:
(UK: (US:
___

▶ VIDEO INFORMATION

Edited by Francesco D’Alessio
Business inquiries: francesco@keepproductive.com

Looking to get your app reviewed?! My policy is simple. Ping me an email, share more about the resource with me. Give me time to explore the tool, and I’ll get back to you about an honest review.

▶ ADS

On the majority of my videos, you’ll find YouTube pre-roll ads and other ads. Ads help to support the community and help create new videos in my spare time, my main role is working freelance for clients.

▶ PRIVACY POLICY
You can view my full privacy policy here:

This will outline everything for the email newsletter.

▶ MUSIC USED

♫Music By♫
●KINO – Good Morning
●Song –
●Follow KINO –

▶ ABOUT OUR MISSION

In a nutshell, Keep Productive is your guide to productivity software.

Keep Productive is a community dedicated to helping you find the most suitable productivity software for your work and life. We’re continually growing an evolving towards the mission of being supportive to your everyday productivity.

▶ DISCLAIMER

All opinions expressed are my own. In some of my videos, I’ve started to include affiliate codes/links to earn a small commission if you make a purchase. If you choose to use them, thank you for supporting the channel!

▶ WEBSITE:

#Notion #Productivity #Databases

Nguồn: https://ephraimturner.com

Xem thêm bài viết khác: https://ephraimturner.com/game/

22 comments

  1. Keep Productive 29 May, 2020 at 19:07 Reply

    A little thanks to our sponsor, Sanebox
    ▶ Get $25 Sanebox credit and a free trial: http://bit.ly/2DtuUfE

  2. Brayden Wardrop 29 May, 2020 at 19:07 Reply

    I am probably thinking about this wrong way in Notion terms but I have searched high and low in the community for a solution and can't find one yet. For context, I run a website that provides online courses on popular technology tools. On one hand I am constantly tracking updates to these courses with data points in my tables like Course Name, Creator Name, Creation Date, Amounts Paid to course creators, Course Status etc. So far, all has been well there. My question comes from my goal to be able to share/publish certain (but not all) of these data points from my master database with my customers who want to know where my courses are in the update process but are not privy to details like how much I am paying to update courses, who is updating them, etc…. So, is there a way to either 1) have my main database populate specific data points to another database automatically so that I only have to update the master but can still publish a shared link to the other on the web. Or 2) is there a way to only publish a certain "View" of my master database that would not allow a customer see data points that I want to keep private? I have played with relations and rollups a ton but neither seem to be giving me the result I am after. Any thoughts? Thanks in advance!

  3. Steve Webster 29 May, 2020 at 19:07 Reply

    Hi. Just started to look at using Notion as a one point for all type of application. One thing I’m struggling with is getting existing and new files into Notion from say OneDrive which is my current storage medium. I have lots of projects with even more docs associated with them most of which are PDF’s. I’ve built a database to import the files into where I can add tags etc once in the table. But first obstacle is getting them across and into Notion. Can you perhaps point me in the direct of help with this please? PS, great productivity videos, thanks for all you supporting info thus far.

  4. abhineet kapil 29 May, 2020 at 19:07 Reply

    Do notion tables allow aggregate functions like sum, avg etc on grouping by a column?

    Let's say you have expenses data in a table. Can I get the totals by categories?

  5. hammockmonk 29 May, 2020 at 19:07 Reply

    I'm trying to put multiple views of a database on the same page. Possible? If so, how? Thanks!

  6. Marwan Ahmed 29 May, 2020 at 19:07 Reply

    Thank you sir for taking time to post this great how to video. I love the fact that you elaborate and demonstrate databases in notion. I really loved the workout page. This is my first video of yours and I surely will go through all your videos. Is there any videos on using notion in the aspect of monthly expenses, finance, paying off debt logs or such? Glad I found you on YouTube and can't wait to learn more about Notion and be productive.

  7. Albert Fajarito 29 May, 2020 at 19:07 Reply

    For a channel named "Keep Productive" there sure are alot of fluff before the main topic.

  8. revoflyer 29 May, 2020 at 19:07 Reply

    Thoroughly enjoying your excellent Notion videos Francesco. My only (I hope constructive) criticism is that it would help my poor old brain to absorb all this good stuff if the pace of your delivery could be a little slower. It sometimes feels as though you are scared to pause and draw breath. Keep up the good work though! There's precious little other Notion content out there and the information is very welcome.

  9. KarmaCashflow 29 May, 2020 at 19:07 Reply

    You mentioned someone (Rebecca something) for learning more about the database stuff but you didn't give a link to her. Could you please supply that?

  10. Guilherme Gautreaux 29 May, 2020 at 19:07 Reply

    Great, Francesco! Databases were the reason I got hooked by Notion. So happy you are starting to cover it now. Very good video. The potential of the multiple views is insane. Allowing you to shift perspective and mindset on the flight, but still focused on the job at hand. Great!

  11. Ivvie 29 May, 2020 at 19:07 Reply

    Hello! I was watching some of your previous videos on Notion and I especially loved your workspace setup and how it links to various places in Notion.. would such a thing be possible in Coda? I'm a blogger and something like that would be perfect for my work.

  12. Dmitry Adov 29 May, 2020 at 19:07 Reply

    Thank you Francesco. I think you are almost the only person who produce videos about Notion using. Without detailed manual yours' videos are the one source I could learn something new.
    Could you please say more about building personal finance system using Notion. And, my be you could provide us more detailed videos on different aspects/topics of using Notion? I highly interested in building CRM system for my small educational center for children by Notion.

  13. Shelsight 29 May, 2020 at 19:07 Reply

    Thanks Francesco – I've discovered loads re Notion's flexibility thanks to all your videos..!
    Two ways Notion could help Database newbies:

    1. More colour/tone contrast between the screen background & database/board cards. Unless images are embedded, the blocks merge together, even when they have text and labels in.

    2. Emphasize the importance of choosing what info goes in Column #1 of a Database/List if you plan to view/use it later as a Board, Gallery, or Calendar.

    Because whatever is typed in the #1 (Name) Column in the Database, becomes the 'Card Title' – and that Title CAN'T be changed afterwards (even by moving another Column to position #1.)

    There is a 'tool tip/hint' to that effect, but it's hidden unless you click TWICE and 'hover'. (This issue could particularly frustrate users from Trello or EverNote, used to tweaking Card or Note Titles any time.)

    A quick mundane example (but it applies to any info or process): A Shopping List of 30+ rows:
    – In Column #1 – I added the item 'type' or 'aisle' (ie 'Produce', 'Deli', 'Household' etc. )
    – In Column #2 – I listed each specific 'item' I needed to buy (ie the main 'Task')
    – In Columns #3-7 were Brand, Qty, UseByDate, How to Store, Checkboxetc…

    The order felt logical and looked OK in the database, but in Board/Gallery View:
    – I ended up with 10x cards called Produce, 6x cards called Deli, 8x Household, etc – because they were my Column #1 'Names'.
    – I couldn't remove or amend those card titles, or use them across the top of the Board for sorting (unless I missed something in settings?)
    – And the individual grocery items (from Column #2) were listed in a smaller font inside each card – whereas they probably should have been the more prominent card 'titles'. But even though I dragged Column #2 to the #1 slot in the database, the original 'Names' couldn't be replaced.

    So it's a simple matter of thinking ahead a bit – but Notion could def make it clearer before it frustrates too many new users.

    Sorry – much longer comment than I intended! But I really think those two tweaks would help Notion gain (and keep) new users much more quickly. Thanks again. I'm playing with the relational database aspect next after watching your video today. Cheers!

  14. Frank Arnold 29 May, 2020 at 19:07 Reply

    Thank you Francesco! The idea of a database with different views is also used in Coda and Airtable. I think this is the future because it allows a completely different usage and is a lot more flexible compared to a static system like Trello/Meistertask etc. The advanced usage with linked databases is also very interesting. But Notion had a bug with indexing, so it was a problem to use this feature because you find not all databases. But this is fixed since approx 2 weeks.

  15. CerebralAudio 29 May, 2020 at 19:07 Reply

    Something that hasn't been mentioned in any of your videos that is really important in Notion: filters, property toggles and sorting are attached to the view and persist. For a simple example… A shopping list with three columns: purchased toggle, item and department (or section). I set up three views: All, Done, and Shopping. The "All" view has no filters or sorting. The "Shopping" view uses a filter for "purchased" is no selected, and sorts by department. The "Done" view uses a filter for "purchased" is selected, and sorted by department.

    This is really useful for quick workflow… For example, each week I update my shopping list by going into the "Done" view and toggling off the "purchased" property for the things I need each week. Then I go into the "shopping" view and add any special items. While I'm shopping I just tick off the things in my cart as I add them.

    I use the "All" view when I need to go through and cleanup the list to keep it from becoming too cluttered.

Leave a reply