▪️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.
@wilsonparry93412 ай бұрын
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.
@benjaminborowski2 ай бұрын
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.
@scully9224 ай бұрын
Hey Ben, Great information, do you have a email I can message you at? Thanks
@benjaminborowski4 ай бұрын
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 ;)
@christophergearhart14735 ай бұрын
Bro, 2.0 is killing me. Thank you for clearing up a straightforward question.
@benjaminborowski5 ай бұрын
You're welcome! Thanks for watching. My course goes much deeper into code fundamentals if you continue to get stuck. notionmastery.com/formulas
@user-tj7ui4zl4x5 ай бұрын
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 ?
@benjaminborowski5 ай бұрын
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.
@erinhybart6 ай бұрын
This was exactly what I needed. grateful to @OptiOppNotion for helping me find this video.
@martinstead28946 ай бұрын
I can't replicate how you re-applied a template. I'm a Windows user does it make any difference?
@benjaminborowski6 ай бұрын
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.
@eada21206 ай бұрын
"Promosm"
@user-xu8le2je5s6 ай бұрын
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? :)
@benjaminborowski6 ай бұрын
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.
@bacotell4536 ай бұрын
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
@benjaminborowski6 ай бұрын
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.
@bacotell4536 ай бұрын
@@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.
@benjaminborowski6 ай бұрын
@@bacotell453 Don't link the Client to the Task? Use a Rollup to pull the Client from the Project :)
@ReinischOps6 ай бұрын
Great breakdown. Hate to be the 70th like but gotta do it.
@k_w_g16 ай бұрын
Does this mean automations (ie via Zapier) can also update Relations, given the exact name is matched?
@benjaminborowski6 ай бұрын
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!
@k_w_g16 ай бұрын
@@benjaminborowski Followed your instructions there and worked like a charm. Thank you!!
@christianmagill38296 ай бұрын
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?
@benjaminborowski6 ай бұрын
Yep!
@blerman136 ай бұрын
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
@EmericLM6 ай бұрын
Thanks Ben for the explanation!
@damienherlihy6 ай бұрын
Thanks for the overview Ben! Looking forward to consolidating my work and personal tasks into a home page.
@sutherlandcarter92686 ай бұрын
Formulas made easy! Signing up for the course now!
@Anonymous-pq3dv7 ай бұрын
Great 👍 Thank you.
@jtross008 ай бұрын
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.
@benjaminborowski8 ай бұрын
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?
@user-io7ue3wf1i8 ай бұрын
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.
@benjaminborowski8 ай бұрын
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 :)
@user-dq1ev9vc7n8 ай бұрын
Thanks, the trick with copy-pasting the false statement to get a nested if loop has been so helpful.
@benjaminborowski8 ай бұрын
Glad it was helpful!
@leebrendalee8 ай бұрын
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
@benjaminborowski8 ай бұрын
Sorry, I don't understand your question. Can you ask it a different way?
@leebrendalee8 ай бұрын
@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
@skibsthebear8 ай бұрын
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.
@nextProgram9 ай бұрын
Is there a way to make the changes you make to a template automatically update the instances of that template that already exist?
@benjaminborowski9 ай бұрын
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.
@nextProgram9 ай бұрын
@@benjaminborowski thanks, ending up solving it by replacing the button with an automation on the board
@kuntalgo10 ай бұрын
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.
@benjaminborowski10 ай бұрын
Your understanding is correct. Only way to get a View from a Linked View is to duplicate the Linked View.
@jfbmusic10 ай бұрын
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")
@lucasabreu22010 ай бұрын
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
@benjaminborowski10 ай бұрын
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.
@Rigson10 ай бұрын
Thanks for making this video Ben! It was really helpful to see you work through examples using the new features and methods.
@benjaminborowski10 ай бұрын
You’re very welcome.
@stevemarkperry10 ай бұрын
Nice! These new formula and dot notation syntax are fantastic.
@benjaminborowski10 ай бұрын
Such an upgrade, right? :)
@user-jo9wn4jn4g10 ай бұрын
Another excellent video, thank you Ben!
@benjaminborowski10 ай бұрын
You're welcome, James, glad this was helpful!
@SteveGerrardPhotography11 ай бұрын
I'm just here to say nice Venom Prison shirt :)
@benjaminborowski11 ай бұрын
Nice. I forgot how terrible that dirt stache was too.
@SteveGerrardPhotography11 ай бұрын
@@benjaminborowskiHaha. I've seen Venom Prison a couple of times and actually interviewed Larissa a few years ago.
@salmasaad19811 ай бұрын
When is your course for formulas 2.0 coming out?
@benjaminborowski11 ай бұрын
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!!
@salmasaad19811 ай бұрын
@@benjaminborowski great, thank you 🙏
@2010Sisko11 ай бұрын
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.
@benjaminborowski11 ай бұрын
That's super nice to hear. I appreciate your comment. You're very welcome.
@cloudlake11 ай бұрын
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!
@benjaminborowski11 ай бұрын
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!
@cloudlake11 ай бұрын
Thank you! Very understandable and easy to follow! :D
@benjaminborowski11 ай бұрын
You're very welcome!
@leilaniausten11 ай бұрын
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. 🎉
@benjaminborowski11 ай бұрын
Right on! This one didn't seem to get much traction so glad someone thought it was cool!
@Melzasx11 ай бұрын
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...
@benjaminborowski11 ай бұрын
No, there is no Button property type yet in databases. I would love that!
@christianmagill3829 Жыл бұрын
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.
@benjaminborowski Жыл бұрын
.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
@christianmagill3829 Жыл бұрын
@@benjaminborowski Much thanks!
@christianmagill382911 ай бұрын
@@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".
@digitaljames790 Жыл бұрын
Awesome use case, thank you.
@benjaminborowski Жыл бұрын
Glad this was interesting, James.
@MrGCaval Жыл бұрын
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?
@benjaminborowski Жыл бұрын
You will want to use the "filter" function available for lists to filter down the related items to the ones you want.
@ex_protuser Жыл бұрын
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 (((
@benjaminborowski Жыл бұрын
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
@benjaminborowski Жыл бұрын
Great tip for the viewers!
@updownsideways Жыл бұрын
Great vid. Started using Notion and learning about formulas.
@benjaminborowski Жыл бұрын
Glad it was helpful! Formulas can be intense, so I recommend starting small at first.
@AS-ld5mz Жыл бұрын
gibberish to me!
@mikedoel3875 Жыл бұрын
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.
@benjaminborowski Жыл бұрын
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!
@notionkombinat Жыл бұрын
As always. Love your work. 💜
@benjaminborowski Жыл бұрын
Thank you so much!
@robynbieber6312 Жыл бұрын
Thanks!!
@benjaminborowski Жыл бұрын
Welcome!
@jatingarg9175 Жыл бұрын
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 😅
@benjaminborowski Жыл бұрын
Cheers, Jatin. Your compliment made me smile as well. Appreciate you.