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.

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 ;)

You're welcome! Thanks for watching. My course goes much deeper into code fundamentals if you continue to get stuck. notionmastery.com/formulas

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.

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.

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.

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 :)

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!!

Yep!

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?

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 :)

Glad it was helpful!

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

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

Your understanding is correct. Only way to get a View from a Linked View is to duplicate the Linked View.

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.

You’re very welcome.

Such an upgrade, right? :)

You're welcome, James, glad this was helpful!

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.

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 🙏

That's super nice to hear. I appreciate your comment. You're very welcome.

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!

You're very welcome!

Right on! This one didn't seem to get much traction so glad someone thought it was cool!

No, there is no Button property type yet in databases. I would love that!

.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".

Glad this was interesting, James.

You will want to use the "filter" function available for lists to filter down the related items to the ones you want.

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.

Great tip for the viewers!

Glad it was helpful! Formulas can be intense, so I recommend starting small at first.

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!

Thank you so much!

Welcome!

Cheers, Jatin. Your compliment made me smile as well. Appreciate you.