- Видео 19
- Просмотров 51 084
Ben Borowski - Certified Notion Consultant
Канада
Добавлен 16 май 2014
Ben is a Notion Certified Consultant and Notion Ambassador, focused on advanced tips, tricks, and deep dives into some of the less covered Notion topics like APIs, formulas, permissions, and integrations. By some, he's known as the Notion expert's expert. By day he helps startups and businesses with ops design in Notion at notionmastery.com and is CTO at weareokidoki.com.
Auto Relations with Notion's Merge CSV Feature
Quick overview of some recent updates to Notion's Merge CSV feature which now auto-relates Relations by name!
00:00 Intro
00:14 Setup
02:39 Importing the Tasks
04:00 Other Stuff
04:33 Outro
////////
*Want to go deeper with Notion and get live support from experts in a supportive community?*
Check out our year-long program Notion Mastery for access to me and my team's Notion expertise. We've helped 1000s of students and businesses make Notion a healthy part of their operations.
👉 tinyurl.com/notionmastery-ytb
00:00 Intro
00:14 Setup
02:39 Importing the Tasks
04:00 Other Stuff
04:33 Outro
////////
*Want to go deeper with Notion and get live support from experts in a supportive community?*
Check out our year-long program Notion Mastery for access to me and my team's Notion expertise. We've helped 1000s of students and businesses make Notion a healthy part of their operations.
👉 tinyurl.com/notionmastery-ytb
Просмотров: 1 024
Видео
Building Client Dashboards with Notion's New Home and My Tasks Features
Просмотров 2,9 тыс.5 месяцев назад
Notion launched a new Home dashboard feature with the powerful new "Task database" feature represented as "My Tasks". In this vid we take a look at Home and how to make a client dashboard system with this new feature. 00:00 Introduction 00:38 Home 02:26 My Tasks 05:58 Client Tasks 15:45 Gotchas 18:07 Summary //////// *Want to go deeper with Notion and get live support from experts in a supporti...
An Overview of Notion Formulas 2.0
Просмотров 10 тыс.10 месяцев назад
Formulas 2.0 is here! And boy is it a doozy. Don't worry, though. I've got you covered with "everything" new in Formulas 2.0. Hopefully this'll take some of the pressure off your transition from 1.0 to 2.0. And if you need more than that, check out my Formula Fundamentals course. Follow the link below to get it: 👉 tinyurl.com/notionformulas2 00:00 Intro 00:48 The Editor 02:55 Property Tokens 04...
How to Notion: Building Shared Dashboards with Projects + Permissions
Просмотров 2,6 тыс.Год назад
Recently I talked about building "Me-Pages" in shared Notion Workspaces. But what are they? Follow along as I build a Me-page from scratch with one of Notion's Project Management templates and get into some advanced permissions scenarios in Notion. 00:00 Introduction 00:27 Creating a Teamspace 02:14 Starting the Me-page with Task Management 08:55 Adding Meeting Notes 11:29 Adding Docs & Wiki 14...
Skip the Inbox with Gmail Filters @Notion Template
Просмотров 1,4 тыс.Год назад
Learn how to set up Gmail filters to make your newsletter subscriptions more manageable. Plus how-to build a @Notion template to manage the filters. 00:00 Intro 01:02 Creating Skip the Inbox Gmail Filters 03:30 Updating Gmail Filters 04:15 Notion Template Walkthrough 05:40 How to Make the Notion Template 09:24 Validating Email Addresses 12:11 Outro *Get the Gmail Filters Notion Template:* 📥 tin...
Notion Buttons: A Big Step Towards Internal Automation in Notion
Просмотров 13 тыс.Год назад
For a long time now, basic automation in Notion has meant using a third-party platform such as Zapier or Make to add stepped actions. Today Notion is launching Buttons, which add a new level of automation to the platform. 00:00 Buttons! (Intro) 00:42 Button Basics 02:25 Editing Pages 03:52 Opening Pages 04:35 Daily Task Reset 06:22 Confirmation Step 07:49 Buttons in Database Templates 10:49 Set...
Notion Feature Updates: Recurring Templates!
Просмотров 4,3 тыс.Год назад
Aw, yeah! Notion finally shipped the first iteration of recurring tasks, what they're calling "Recurring Templates". This new feature allows you to create template-driven pages daily, weekly, monthly, and yearly. In this video I show you the feature, talk about its current limitations, and give you a couple tips and ideas for working with it. ///////// Want to go deeper with Notion and get live...
Notion Changed How Synced Blocks Work in Templates (ROLLED BACK!)
Просмотров 2,1 тыс.Год назад
NOTE: As of October 10th, 2022, these changes have been sadly rolled back and no longer apply. Synced Blocks in templates are now back to Syncing instead of creating an instance. Bummer! Notion recently changed how Synced Blocks work when originating inside Template Buttons and Database Templates. Follow along as I demo how things have changed. ///////// Want to go deeper with Notion and get li...
Notion Teamspaces: A Primer and Walkthrough the New Feature
Просмотров 2,3 тыс.Год назад
Notion recently released the powerful Teamspaces feature. This gives businesses on the Team and Enterprise plans more ways to organize their content in the sidebar and new permissions. This video, while quick, goes over all the new features including creating Teamspaces and managing the new settings and permissions. ///////// Want to go deeper with Notion and get live support from experts in a ...
Notion quick tip: making writing your nested if statements easier to write
Просмотров 1,6 тыс.2 года назад
Ever struggled writing a lengthy if statements with lots of conditions? Watch this quick tip you can employ when writing Notion formulas. Want to learn Notion's new Formulas 2.0? Check out the Formulas Fundamentals 2.0 course at the link below. 👉tinyurl.com/notionformulas2 ///////// Want to go deeper? Our online program Notion Mastery also includes the "Formula Fundamentals" course: 👉 tinyurl.c...
Notion API Adventures: Moving Date Objects from Titles to Date Properties
Просмотров 5312 года назад
Our original changelog was a Page with a series of Text Blocks with Date objects in the text. I wanted to move this to a database and extract the date from the title and assign it to a Date property. ///////// Want to go deeper with Notion and get live support from experts in a supportive community? Check out our year-long program-Notion Mastery-for access to me and my team's Notion expertise. ...
Linked View of Databases and Permissions Gotcha!
Просмотров 4152 года назад
TIL that Notion's Linked Views of Databases do not inherit the permissions from the databases they are linked from. This lead to some interesting bugs! Watch this quick video and save yourself some heartache. ///////// Want to go deeper with Notion and get live support from experts in a supportive community? Check out our year-long program-Notion Mastery-for access to me and my team's Notion ex...
Renaming Views in Notion's Better Databases Feature
Просмотров 6082 года назад
This video goes over the maintenance work created by the new database views shipped by Notion on March 15th, 2022. Existing and new Linked Databases now show up in the sidebar without an icon and with a "View of ..." title. So how do we change that? ///////// Want to go deeper with Notion and get live support from experts in a supportive community? Check out our year-long program-Notion Mastery...
What if we built Wordle in Notion?
Просмотров 4172 года назад
A example of a Notion-based Wordle game created with Notion Formulas and using the API to create daily game boards. Source code: github.com/typeoneerror/notion-api-examples/blob/main/examples/wordle/create-game/index.js Workflow code: github.com/typeoneerror/notion-api-examples/blob/main/.github/workflows/create-daily-wordle-game.yml Get the template: tinyurl.com/notionwordle ///////// Want to ...
Using Notion to Manage a Fire Department
Просмотров 2402 года назад
Using Notion to Manage a Fire Department
Notion API Demos - Creating a Year of Entries
Просмотров 6732 года назад
Notion API Demos - Creating a Year of Entries
Using the Notion API to pull in data from the Formula 1 API by Ergast
Просмотров 5 тыс.2 года назад
Using the Notion API to pull in data from the Formula 1 API by Ergast
✅ N. keepnote versi lngkp
▪️5:48 ▪️ 6:28 readable from left to right. ▪️Filter function 9:35 🕵🏻♀️parseDate() 16:48 ▪️Week 18:00 ▪️var 19:24 ▪️ 22:00 round 🕵🏻♀️ 22:21 Lets 🔸ifs 26:26 🔸 27:50 Argument = b, i, u (in style function). So each of these items is passed in as an argurnent to the style function = Jadi masing-masing item ini diteruskan sebagai argumen ke fungsi style.
Hi ben, just subscribed. My current pain point: Do you know how to JOIN data from a CSV to an existing record in a notion database? IE if your notion database has "Write project proposal" and your CSV has "Write project proposal" and there are values in the CSV you want to get into notion.
This video explains how to do what you described unless I am misunderstanding. The name of the column and relation in your databases has to match and the text has to match exactly.
Hey Ben, Great information, do you have a email I can message you at? Thanks
For business inquiries: tally.so/r/nWJRpk For everything else, public questions on X @typeoneerror or join Notion Mastery and you can ask me questions at office hours ;)
Bro, 2.0 is killing me. Thank you for clearing up a straightforward question.
You're welcome! Thanks for watching. My course goes much deeper into code fundamentals if you continue to get stuck. notionmastery.com/formulas
Great video but I'm facing an issue. The automatic property like "today" and "now" aren't showing when using buttons. Do you happen to know why ?
Could be the plan you're on. Are you using Free plan? It's also possible that you're trying to use @Today and @Now somewhere where it's not currently supported. I would reach out to Notion support to understand.
This was exactly what I needed. grateful to @OptiOppNotion for helping me find this video.
I can't replicate how you re-applied a template. I'm a Windows user does it make any difference?
Honestly, there's a bug kicking around with templates right now. Could be related to that. I saw this morning that it should be "patched" soon.
"Promosm"
What if in Notion we have column which is Formula? I tried many opportunities to retrieve values (numbers), but it always retrieve 0 instead of correct number....any idea? :)
Your integration or intergration token has to have access to all the relations you might be using in the formula as well and Notion doesn't load all the records for you when using via the API. In general you want to load all the records you need to *recreate* the formula on the other side and write your own code to do the calculation.
Using this framework to build client dashboards, how would you integrate it with Notion Calendar? I like the idea of each client having a tasks database all their own, but I'd also like to display each of those client tasks in my calendar without having an ever-growing list of databases to link to Notion Calendar
I’d say “you don’t” to be honest. You’d have to add every database to Notion Calendar. To be honest, Notion is designed primarily for internal teams and this is one place it doesn’t shine.
@@benjaminborowski I appreciate the honesty. It's refreshing to see someone who loves Notion, but doesn't try to force it into every situation as if it's the proper solution to every problem. One other question I had for you: You mentioned that in the Client template, alongside having auto-linked Projects for the client you could also have auto-linked Tasks. However, I've always found it a bit hard to properly link Tasks, Projects, AND Clients. The main problem I have is that I would like it so that if I'm in a Project page, editing some tasks assigned to this project, and I add a new task, I would like it if that task inherited the client of the current Project page. I know you can do this after the fact by simply assigning a filter to the Project page, but do you know a templatized way to do this, so when I create a new Project, I don't have to go into it and add a filter to the Tasks linked view in order to auto-assign the client? I know it's a pretty specific ask, but I actually end up running into it every time I work with a new client, since I like working from both the Client page and the Project page.
@@bacotell453 Don't link the Client to the Task? Use a Rollup to pull the Client from the Project :)
Great breakdown. Hate to be the 70th like but gotta do it.
Does this mean automations (ie via Zapier) can also update Relations, given the exact name is matched?
Hey, Kate. Notion’s internal APIs are different from their external ones, so no. You can however use a general web request to associate relations with Zapier. There’s a blog of mine on notionmastery.com showing how to do this. It’s tricky!
@@benjaminborowski Followed your instructions there and worked like a charm. Thank you!!
Thanks for the overview! Looking forward to getting access. If you turn a database into a task database, does that mean it's available in home for anyone who has access to that database?
Yep!
Great video, very clear. all that I needed. however, I'm wondering if you can create a notion formula generator and/or an online converter to/from Notion formula. I'm trying to find something like that without success s ofar
Thanks Ben for the explanation!
Thanks for the overview Ben! Looking forward to consolidating my work and personal tasks into a home page.
Formulas made easy! Signing up for the course now!
Great 👍 Thank you.
Please HELP! I have numbers in two related tables (Table 1. Payslips, with a Property: "Salary Hrs" and Table 2. Rates, with Property: "Salary Rte") I want to create a Formula Property in the Payslip table that multiplies "Salary Hrs" with the corresponding "Salary Rte" in the related Rates table. I can't seem to get the syntax right to reference the "Salary Rte" property in the Rates table.
Hey, Jacob. If you've got a Relation that you want to pull through the rate from, it'd look like this: prop("Rates").first().prop("Salary Rte") * prop("Salary Hrs") Your relation "Rates" is a list, so you need to get an actual page object from the list with "first()" so you can reference the properties on that page. Now, this assumes you only ever attach a single Rate to each Hours page. Make sense?
Ben what do you reccomend for a small start up team of 10 to track both OKRs and monthly work plans by department. This OKR template would be great but ideally we need something that incorporates and links to department level work plans.
Hey, Holly, I'd recommend keeping it simple and creating a "Teams" database and an OKRs database. This would allow you link each objective/key result to a "Team" and then each team can have their own dashboard with their workstream/plans that "pull" from the global OKRs system. This allows you to all share similar architecture for the data and enrich it with team-specific data. Feel free to email me if you need help getting this set up. I offer coaching/pairing sessions :)
Thanks, the trick with copy-pasting the false statement to get a nested if loop has been so helpful.
Glad it was helpful!
Love how clear your video is, at beginning could I have prop or name field like you did ,,so add name then add total income minus total expenses and have it calculate based on that name field, I tried and tried different methods. I need different totals for two different rows
Sorry, I don't understand your question. Can you ask it a different way?
@benjaminborowski appreciate your reply. What I ended up doing was just kept the other account separate instead of together. Because I'm new to this, I'm not sure how to rephrase, but will try. One row has bank 1 income bank 2 income bank 1 expenses bank 2 expenses...those are names on top. Then on side is bank 1...next line is bank 2. Maybe those are rows top is columns. Then I was trying to do formula based on bank name, then income less expenses...but it didn't work..it works without the name
Any boxing day sales on the Formula Fundamentals 2.0 course? Would love to grab it if it was discounted and I am sure many others would feel the same.
Is there a way to make the changes you make to a template automatically update the instances of that template that already exist?
Not without using the API, no. That would involve finding all the instances of the template and using the API to add new blocks to the page. The API is also limited in scope (can't create Linked Views or Link Previews, for example). So mostly: no.
@@benjaminborowski thanks, ending up solving it by replacing the button with an automation on the board
Previously I used synced block all across my workspace to duplicate whole sets of views for databases. But I guess after the new database views and linked database system was introduced, the synced block option isn't anymore helpful. What do you do if you wish to duplicate one particular view of a database to another linked view? My understanding is Notion at present only gives option to choose the views present in the source database but not the views in the linked databases.
Your understanding is correct. Only way to get a View from a Linked View is to duplicate the Linked View.
Thanks, Ben. Such a solid overview, much appreciated. Putting vid side by side with Notion window to get some practicing in sync with your instructions. *One detail I enjoy: being able to keep hands on keyboard instead of clicking 'Done', by using Command-return. (If you forget, tooltip appears when hovering over 'Done' button: "Accept ⌘+Enter")
I tried using button to create a default task for a set of projects, but the tasks are created dependently, i.e., changing one affects all others. Is there a workaround for this ? I tried using Notion's tasks templates, but the behavior is the same
That sounds very odd. I don't think you are creating new pages with buttons if they are linked in some one. Sorry I can't help because I don't really understand what you mean. If you follow this video's steps and the pages are linked, this would be a very bad bug and you should report it to Notion support.
Thanks for making this video Ben! It was really helpful to see you work through examples using the new features and methods.
You’re very welcome.
Nice! These new formula and dot notation syntax are fantastic.
Such an upgrade, right? :)
Another excellent video, thank you Ben!
You're welcome, James, glad this was helpful!
I'm just here to say nice Venom Prison shirt :)
Nice. I forgot how terrible that dirt stache was too.
@@benjaminborowskiHaha. I've seen Venom Prison a couple of times and actually interviewed Larissa a few years ago.
When is your course for formulas 2.0 coming out?
soon! Notion's API issues has been making preparations for launch very difficult. It's currently available to Notion Mastery students, but but the lower cost standalone will be later this month. Definitely before November as I am going on vacation!!
@@benjaminborowski great, thank you 🙏
Thanks so much for this video. I was pulling my hair out with the "prop" terminology and beginning to cry as I couldn't even add two numbers together in two different columns. THANK YOU so very very much. Seem like every other youtube video hasn't flagged this new formula terminology. Automatic subscription. Big thanks.
That's super nice to hear. I appreciate your comment. You're very welcome.
at about 8:30 where you have the new entries automatically added to the filter db. Mind blown! I was looking for how to do something like this yesterday. Thank you!
Ah, yes! In linked views, any filters you assign will automatically apply to newly created pages if they are not "OR" filters (meaning if I made this "where page is Newsletter OR Something Else", it wouldn't work because Notion wouldn't know which page to use!
Thank you! Very understandable and easy to follow! :D
You're very welcome!
This was amazing!! Thanks! This was great on two fronts. I didn’t know you could add a string of emails for filters, as well as the nifty notion template. 🎉
Right on! This one didn't seem to get much traction so glad someone thought it was cool!
Thanks a lot for showiong us the buttons things! Would it be possible to show the buttons directly on the table view? I mean, having one button per row...
No, there is no Button property type yet in databases. I would love that!
Great video! I need to get dot syntax into my muscle memory. Do you know if there's any way to show filtered relations one per line? I tried .map(current + " ") and that didn't work.
.map(current).join(" ") And keep in mind the live-preview does not show newlines and you must have wrap enabled on the column to display them
@@benjaminborowski Much thanks!
@@benjaminborowski Looks like there's some issues with view filters when it comes to empty lists. Items which are returning empty lists are matching when the filter is set to "is empty" and "is not empty".
Awesome use case, thank you.
Glad this was interesting, James.
Nice video! I trying to learn more but I have a quick question. How to sum some values itens that has a specific tag? For example, I linked 40 itens, but just 4 has a specific tag on other database. When I try to sum, the formula uses 40 itens, not just 4. HOw to specify the itens that I want to sum?
You will want to use the "filter" function available for lists to filter down the related items to the ones you want.
Ben, thanks for the video! Could you make a tutorial on how to display progress as a progress bar? I can’t figure out how to link different projects that are in the same database to different databases, where there will be individual checkboxes... How to link not an entire property to another database, but individual projects. I would be very grateful to you. This is perhaps the only question that is causing me great difficulties now (((
The section on lists and variables in this video show how to make a progress tracker with related tasks. You would use this method and select "Bar" as your display instead of "Ring" as I did.
So helpful, I love the update ! Little trick that maybe you know, you can reduce the YYYYMMDD into an L or l, for the formatDate function, to know if prop("date") == Today
Great tip for the viewers!
Great vid. Started using Notion and learning about formulas.
Glad it was helpful! Formulas can be intense, so I recommend starting small at first.
gibberish to me!
Nice video and really happy to have the new list functions. Now we just need reduce() added to go with map() - unless you know of a hacky way to get that already.
I asked for that too during the beta, lol! I'm sure there's a hacky way. I'd love to solve for it. Feel free to link me to a description (or post here) of an outcome you're trying to achieve and I'll see if I can hack it!
As always. Love your work. 💜
Thank you so much!
Thanks!!
Welcome!
Made me smile when I saw your thumbnail pop up. Immediately switched over from the other video as I know yours will likely be more comprehensive and easier to understand 😅
Cheers, Jatin. Your compliment made me smile as well. Appreciate you.