This is brilliant. Thanks so much for creating it and for it being succinct. I've tried countless ways to make these types of relationships work and just couldn't figure it ou.
Thanks so much. I tried this, but whereas your variable seems to automatically switch from type text to type block(?), for some reason my variable remains type text and I get an error saying "Formula cannot have a return type of text." Any thoughts?
@@SkyTan_ you can definitely do that, by I prefer the actual project relation to be filled, so when you see your task list, all the project info is in one property.
Excellent video - can you use database automation's to pull in data from another record. For instance in this example the project could be linked to a client record from a client database. When you are creating a task and linking it to the project name , could you pull in other details from the project record? Such as if the client name was held. Or project type or status. My reasoning is that I would like to create time entries from the task and would like to have all the client and project information so I can see how much time is spent on a client or project over any given time period, say week or month. Hope that all makes sense
@@Smaffs59 this should be possible; you may need to create rollup properties to then define the variable. This also possible via formula (which works better if the property is 2 or 3 levels removed, but I try to stick with rollup if I can.
This is brilliant. Thanks so much for creating it and for it being succinct. I've tried countless ways to make these types of relationships work and just couldn't figure it ou.
@@davidsotropa glad it's helpful! I'm still figuring these out myself 😅
Thanks so much. I tried this, but whereas your variable seems to automatically switch from type text to type block(?), for some reason my variable remains type text and I get an error saying "Formula cannot have a return type of text." Any thoughts?
Would rollups / formulas also be a solution?
@@SkyTan_ you can definitely do that, by I prefer the actual project relation to be filled, so when you see your task list, all the project info is in one property.
I love to watch Notion videos. Did Notion completely revamp slash command menu?
Excellent video - can you use database automation's to pull in data from another record. For instance in this example the project could be linked to a client record from a client database. When you are creating a task and linking it to the project name , could you pull in other details from the project record? Such as if the client name was held. Or project type or status. My reasoning is that I would like to create time entries from the task and would like to have all the client and project information so I can see how much time is spent on a client or project over any given time period, say week or month. Hope that all makes sense
@@Smaffs59 this should be possible; you may need to create rollup properties to then define the variable. This also possible via formula (which works better if the property is 2 or 3 levels removed, but I try to stick with rollup if I can.