This was such a glimmer of hope! But alas it does not work. I hate to be the bearer of bad news, but no matter which permission level you give them, the client can still get into full database... They just need to create their own linked view of database and then they can create their own filter / view style... so it doesnt acctually block it. Notion really should get this just built in.
Agreed. Don't know what's taking Notion so long to add support for this. None of these tutorials ever worked, so we used Notion's API to build an integration that does exactly this, and we recently opened it for others to use. I have a quick tutorial on my channel if you're interested. It's still not the ideal built-in solution, but I believe it's better than risking clients finding their way into the full database.
EDIT Oct 23, 2023: ⚠This method is not 100% secure. There are still more ways people may be getting to your data. Use ONLY if the data you're hiding is not sensitive. @Dinesh found a way that the person you share the database with may be able to see all your data. By exporting the database view as CSV and by changing the "Include database" option to "everything". From my experience not many people will even try to find this, but just so you know!
Has this been amended now by Notion? It seems that "Can View" permission now doesn't allow exporting anymore, this would make this method 100% safe @Daniel
@@azmainmd.shahriar4024 I know this is not a 100% secure method, but it's so far the best we have. I believe it's better to know this is possible and then everyone can make their own decisions whether to use it or not. That's why I pinned this comment!
This is a clever way to create something really useful, but for something that should be a standard option in notion in the first place. I love Notion, and keep on finding new ways to use it in better ways every week. /but the most annoying thing is not being able to setup strict rights to properties (properties should have the option te be grouped, (‘toggle option is already there?) so you can group properties to ‘INTERNAL’ and CLIENT FACING) and then give viewing rights to CLIENT FACING ‘properties only - so you can handle this from within notion settings itself.
This is one of the most looked for features in my case... But until they come, which I'm sure they will, we'll have to find workarounds such as the one in this video
Unfortunately, yes. In our team we found that all workarounds within Notion can be manipulated whom you share it with, so they can still end up seeing the whole thing. If you're open to using a Notion integration that solves this problem, I made a quick tutorial on my channel.
Very interesting, thanks for sharing. How do you access your parent (original) unfiltered DB if you filtered everything out before sharing to the client? Are you keeping two views of every table you share, one for you and one for the client? Thanks!
What's the DONE formula checkbox you are adding at the end? I think that part isn't included in the video. I'm a bit confused how you used the "DONE" formula to remove all the other tasks from the client's view, in the core DB. Thanks!
Unfortunately Notion still hasn't made this a thing. You can use their API or a Notion integration instead. If you're interested I have a quick tutorial on my channel
Is there an update to the method in this video? I want to have a teacher / student database where this students can mark off the lessons they have completed. I don't want them to be able to see each other's info
Thanks for the video. Question: at around 5:33 you explain to create a contradictive filter to hide all tasks in that view - my question is, if you have more than one view (i.e. a view that you use to view your tasks) how do you restrict the client from seeing the other views? In my testing, your instructions only work if you only have one view and you are OK keeping it filtered to hide all tasks - but then you can never see your own tasks unless you remove the filter (which opens it back up for the client to see everythin). I feel like I'm missing something. What am I missing?
The solution is to have one original database (contradictive filter, so no items are visible) and then 2+ linked views of the original DB. One for the client to see only his tasks and one for you in another page for you to see every client's tasks. Just remember to set share the original DB with the "can view" option and the client's view to "can view"/"can edit content" depending on your situation.
Ich finde dein Video wirklich sehr gut. Ich habe Wochenlang nach einer Methode gesucht, mit der ich ein Database nur teilweise teilen konnte. Dein Trick mit dem Advanced Filter ist einfach genial. Vielen Dank.
Hey there, you almost made my day but there is another warning that makes it a no go in my use case - If your user, (even a workspace guest) has an "edit right" anywhere, he can create a new linked database view and set it up without any filter to access the whole content of the master db. Do we agree ? It's a shame cause it was a lovely work around :)
This is not the case... even with view only rights guests can still create linked view of your database... so this simply does not work. @@DanielCanosa
I guess, if the "Client" uses the Notion's search function, he or she can view all the entries in the Tasks database (on the search result page)... :-( And on the Task's page, the Client can choose the Projects property, and see all the projects (moreover, they are all links, and he or she can click on the projects, and see them all...) Am I wrong?
You're right. Are you still looking for a solution? I just made a video tutorial with an alternative that doesn't risk exposing all entries on the databases, you might find helpful
Was happy to find your video, but when I follow it I can't get it to work like yours. In my case I have 3 dataBases, Clients, Products, Tasks. I'd like to share the Client page with the client. Inside the client page I create linked database with tasks and advanced filter. But, when sharing that page and viewing it from the user with view permissions, I do not see the linked database. Seems like I need to share that tasks DB as well which is what we like to avoid right? I'm I don't something wrong?
I tested this approach earlier. However, one can download the entire database as a pdf or CSV even with view access. So, this really defeats the purpose of trying to create a ‘private’ view. Thoughts?
I have tried to download the core tasks database shared with the client and I get nothing... Which view are you sharing that you can see the private info in?
@@DanielCanosa While exporting, change the "Include Database" option from "current view" to "everything." The whole database will be downloaded as CSV even if you have the entries hidden using advanced filters. Notion doesn't allow the 'disable export' feature except for its Enterprise plan. This one functionality will open so many possibilities.
@@dineshgoswami6237 you're right Dinesh! I believe very few people would manage to find this way (been using Notion for 2+ years and haven't thought of that myself!) but it is indeed a possibility. So it's something to take into account. Thanks for sharing Dinesh
Either use Notion'a API or a Notion integration, as it's still not possible natively. We did the API route and recently opened our solution as an integration for others to use. Tutorial video on my channel if you're interested
one question: if you set a filter in the "All open" view to hide everything, neither you will be able to see the database. So how do you work on it? You disable the filter? In this case if you disable the filter the client can see the database. Other solutions?
@@DanielCanosa Hi, I have the same question as Lorenzo and still don't get it. I have to share my "tasks" database with the client as well so he can see the tasks of his projects, so he has access to all my tasks.
@@sarah-loulepers9835 yes, but you leave the database with a filter that returns no results. Then you access to your database via linked views that you can filter however you want
Hi Daniel, I would love to share filtered databases through "shared web links". However the web link unfortunately shows the table in full. Your solution here is great, though clients are still needed to sign up to notion and create an account. I would like to share them a weblink to the content to show. Any solution for this?
yup! use super.so or any other website builders and embed the view you wanna share in your own domain :P I know it's not the best solution, but it'll be the only one that doesn't require your clients to sign up for Notion
Hi Daniel, this is great, is there a way to use this method with a "Can Edit" setting? I'm sharing my projects with some externale contractors and they need to edit the tasks, but I don't want them to see anything that's related to other projects.
Hi! Did u try it? I need use this with the edit (now full acess) permission. I'll try it tomorrow but If u can tell me about your experience first, I'll appreciate so much.
Inside the tasks for the client, the tasks database has a field that links to another database. I want to ensure that the client can only see some fields (not all), when opening up this field as a page. For example, the task has a person responsible. The person responsible will have fields such as job role, email and team. I want the client to only be able to see the job role when opening up that field as a page. Is this possible?
Hi , Great Video.!!! when i share a project i always must share the full database with my client and he see the content. I try to send you a screenshot but i can't attached here
Hi Daniel, than you for the video. I'm trying to share a database at the teamspace and it appeared for person as empty page. It works perfectly fine for sharing my personal data base. Is there any way I can partially share database from team space?
If I use the contradictive filters on the master database, I won't see anything anymore. Is there a way to still see and use the original database without letting others to see the original database?
Hi. I tried to make it and it doesn't work in my case (in a private space). The process seems simple : - Database for listing of items. Each items is a page of database. - Database for listing of category. Each category is a page of database. In you video, you didn't explained to share the Database, you only speak about share category (project) page database. If you only do it, the user who you shared the page won't access to it because no access database == no access to an item (page) of the database. But in fact, when you share the project database you will have new problem, the user can see all projects...
Silly question, seems I followed the steps to related 2 DBs, then created filter in Task DB on project page (failed to change to advanced filter as no such option). Then share to my other account with view permission. The other account could only view the project page but not the task DB underneath it. What have I done wrong?
my guess is that you didnt give access to the core Tasks database... so go wherever that core DB is sitting and give access to your other account to it. That'll work
this unfortunately somehow does not work for me. if I share it I cant see the table view of the database but only the empty site... the written text on the site I can see but not the linked database to it...
OMG THANK YOU SO MUCH. I've been trying to do this for ages, over complicating it. All I needed was the advanced filters and the Hide Database Title. The headaches you spared me xd
So you won't be neighter able to see your data base. Beacause it is hidden for you and the client at the same time. I Don't unserstand ??? Can you please help
Great video, I'm sure I will use it soon. Quick question, I have a database that I want to hire a data entry person to do the inputting of data, but I do not want them to see all of the fields in the database when they click "New". How do I do this? It seems I should be able to filter the fields that show when clicking "New" but that is not the case. At least not that I found. Please help. Great work. Love your channel...already subscribed
I'm afraid that's not possible. If the only thing you want this person to do is data entry, you can build a Tally form with the data you want them to enter and connect it to notion. This way the data entry person just needs access to that form, and not to notion
Very helpful! Thank you Daniel. I didn't use this for exactly your use case but I just made the sharing of meeting minutes much safer for our company because now no-one can drill down to our core meeting minute database and read the minutes for other projects or clients.
Followed all the steps and have some weird feedback... The only way I could get the client (guest account -> view only) to see the tasks I had to do these three things: 1. Give client guest access to the [Client Status] table (as in the video) 2. Give client guest access to the [All Tasks] table (and create the block filter, Done checked and Done unchecked) 3. Give client guest access to the [Projects] table (and create a separate block filter there too) Can't figure out if I'm doing something simple wrong, but overall this flow makes it unworkable/impractical. Thanks for trying, Daniel! Would be so simple if Notion would just create a permissions level to share a partial view of a database. Shane
I agree that it's a pain in the ass to have to find these workarounds... I agree that Notion should have this feature as high priority since it's impacting so many use cases I already stopped counting
not in this particular topic, but it's something I say often. This is basically having just one page where all databases are located, and use linked databases everywhere else.
Daniel, that's awesome solution thank you a lot, especially the elegant workaround with advanced filters! I almost succeeded with it, but still there is just one problem: when select a filter user will see the list of all projects, have you find any workaround on that? STR: 1) Created a project, granted user permissions to it 2) Granted permissions to Projects DB (with advanced filter). If not - user won't see any tasks at all. 3) Assign some tasks to this project 4) Granted permissions to Tasks DB (with advanced filter) 5) On Project user can see tasks that's fine, but when he selects filter "Project" - he will be able to see all your project, even if page Project DB is empty (due to advanced filter)
Hey, I just recently created a tutorial video for a solution with granular permissions so that users can't see all your project when playing with your existing filters.
Hi ! I might not understand fully, doesnt the master db appear in the shared pages of the client then ? Even if we only share the view relative to this client, as we have to share the entire db ?
Sadly there is a problem 1st You have to give access to the core DB you create the blocking filter on the 1st view and it works, but if you have other views (which is nearly always the case) the client will have access to the all the data
This seems to work if you choose to not have any views on the DB page other than the The one with the blocking filter This will make an essential feature impossible which is creating several views on the core DB page, and using linked views of the db from different pages utlizing the pre made views, without having to remake the whole view each time. This is tough to sacrifice
@@omarmohamed-mu4np Well you can build your views elsewhere and you will still get to copy them... you dont need to make your filtered views on the acctual database... the bigger issue is that the above technique does not work.. because client can make their own Linked view of databases and see anything they want
I have to say, I have watch this video more than 10 times, because I want it so much, lol, as an experienced software engineer, I didn't manage to do it... 1. I have a table, with a columne named public, intend to be used as a filter. 2. In that table, I created a templete, the content is a linked table, which linked the table itself. 3. Use advanced filter, select public == true 4. Share the templete, open it in browser, the content part is blank.
And as you pinned message says, there is also a security issue. Is there any automation tool, helps to filter one table to another? the logic is simple.
I believe this video is so not fully understood, and there are some missing parts (from my experience and because of the questions here). if you don't want the client to see filters so you need to create a filter in your database that hide everything?: A) how can you work from a database with a filer that hides everything? B) if the filter hides everything - the client also won't see everything. Anybody figured this one out?
Thanks so much Daniel! This is so interesting and I was a little desperate couse I was needing fix diferents access to a two views in a single database for a clients Workspace and just found thats isnt "officially" posible... I'll try this tomorrow. Cheers from Argentina 🇦🇷✨✨✨
Si los usuarios buscan con la herramienta buscar, pueden acceder a todo el contenido, tu video me ayuda a ocultar los datos en las vistas pero realmente siguen estando accesibles, no acabo de encontrar una solución definitiva, pero gracias, si tienes más opciones me gustaría saber un poco más
@Daniel Canosa and @Dinesh, I may have found a way to make partial views work. I followed your setup, but with the following adjustments. In the private master page for the data, I have a public web link enabled that has "can comment" permissions only, but does not allow editing, duplication, or search indexing. In the shared page for the data, have the permissions set as follows: -Share page level: (1) public web link on, "can comment," but all other disabled and (2) invited guest "can comment" permissions only. -Views level: (1) inherits and (2) invited guests "can comment," "can edit content" or "can edit." The "can edit content" permissions say the invited guest can just edit but not database views or structure, so not sure what happens if you choose that option. -Locked the shared page and shared views. -Double checked that the master database name is not showing in any of the shared pages or views because that would let the user click a link to see the master database. For those who know Notion, does this work to make it so that you can safely share ONLY part of a private master database with a client but hide some of the columns in the master data from the client-facing view? One additional question I have is - is there a way to do this kind of limited sharing but with the master page data not available at any public web link? I don't think so because if I disable the public web link sharing the master page data, then the share page itself is still visible, but none of the data being pulled in from the master page, so nothing shows up. My assumption is that the public web link has to be on for the master page data for the share page and shared views to be able to pull data from the master page.
I believe this would have the same issue. Even if the database name is not visible, anyone could open any of the database items as a page and navigate to the core database via breadcrumbs
This was such a glimmer of hope! But alas it does not work. I hate to be the bearer of bad news, but no matter which permission level you give them, the client can still get into full database... They just need to create their own linked view of database and then they can create their own filter / view style... so it doesnt acctually block it. Notion really should get this just built in.
:/
No, this method is working, but its hard. i have more simple decided
@@andriy-kos tell me more
Agreed. Don't know what's taking Notion so long to add support for this. None of these tutorials ever worked, so we used Notion's API to build an integration that does exactly this, and we recently opened it for others to use. I have a quick tutorial on my channel if you're interested. It's still not the ideal built-in solution, but I believe it's better than risking clients finding their way into the full database.
EDIT Oct 23, 2023: ⚠This method is not 100% secure. There are still more ways people may be getting to your data. Use ONLY if the data you're hiding is not sensitive.
@Dinesh found a way that the person you share the database with may be able to see all your data. By exporting the database view as CSV and by changing the "Include database" option to "everything".
From my experience not many people will even try to find this, but just so you know!
Has this been amended now by Notion? It seems that "Can View" permission now doesn't allow exporting anymore, this would make this method 100% safe @Daniel
I think you should not keep this video online as it misleads a lot of people like me. should have read this comment a lot earlier.
@@azmainmd.shahriar4024 I know this is not a 100% secure method, but it's so far the best we have. I believe it's better to know this is possible and then everyone can make their own decisions whether to use it or not. That's why I pinned this comment!
This doesn't work as your client can still cmd + k and search for everything in your master task database.
please consider highlighting the comment of @_wli if not deleting the video. Thank you!
This is a clever way to create something really useful, but for something that should be a standard option in notion in the first place.
I love Notion, and keep on finding new ways to use it in better ways every week. /but the most annoying thing is not being able to setup strict rights to properties (properties should have the option te be grouped, (‘toggle option is already there?) so you can group properties to ‘INTERNAL’ and CLIENT FACING) and then give viewing rights to CLIENT FACING ‘properties only - so you can handle this from within notion settings itself.
This is one of the most looked for features in my case... But until they come, which I'm sure they will, we'll have to find workarounds such as the one in this video
If you want to change something in the data base you have remove the filters right ? So the client can see everything at that moment ?
Unfortunately, yes. In our team we found that all workarounds within Notion can be manipulated whom you share it with, so they can still end up seeing the whole thing. If you're open to using a Notion integration that solves this problem, I made a quick tutorial on my channel.
Very interesting, thanks for sharing. How do you access your parent (original) unfiltered DB if you filtered everything out before sharing to the client? Are you keeping two views of every table you share, one for you and one for the client? Thanks!
did you manage to replicate? somehow it does not work for me
@@jonasrollin137 I haven't yet tried - but where does it block for you?
my issue too - seems you'd have to duplicate this system to view your entire DB? I gave up
What's the DONE formula checkbox you are adding at the end? I think that part isn't included in the video. I'm a bit confused how you used the "DONE" formula to remove all the other tasks from the client's view, in the core DB.
Thanks!
hey man. do you know if is it possible to give editing permissions for a database view without giving access to the original database?
Exactly my question. How do you hire a data entry person without having them have access to all of the fields in your database?
Unfortunately Notion still hasn't made this a thing. You can use their API or a Notion integration instead. If you're interested I have a quick tutorial on my channel
@@358studios Are you still looking for a solution? I just posted a video on my channel that does exactly this
Is there an update to the method in this video? I want to have a teacher / student database where this students can mark off the lessons they have completed. I don't want them to be able to see each other's info
Thanks for the video. Question: at around 5:33 you explain to create a contradictive filter to hide all tasks in that view - my question is, if you have more than one view (i.e. a view that you use to view your tasks) how do you restrict the client from seeing the other views? In my testing, your instructions only work if you only have one view and you are OK keeping it filtered to hide all tasks - but then you can never see your own tasks unless you remove the filter (which opens it back up for the client to see everythin). I feel like I'm missing something. What am I missing?
I have exactly the same question...
The solution is to have one original database (contradictive filter, so no items are visible) and then 2+ linked views of the original DB. One for the client to see only his tasks and one for you in another page for you to see every client's tasks. Just remember to set share the original DB with the "can view" option and the client's view to "can view"/"can edit content" depending on your situation.
Ich finde dein Video wirklich sehr gut. Ich habe Wochenlang nach einer Methode gesucht, mit der ich ein Database nur teilweise teilen konnte. Dein Trick mit dem Advanced Filter ist einfach genial. Vielen Dank.
Hey there, you almost made my day but there is another warning that makes it a no go in my use case
- If your user, (even a workspace guest) has an "edit right" anywhere, he can create a new linked database view and set it up without any filter to access the whole content of the master db.
Do we agree ?
It's a shame cause it was a lovely work around :)
You are right!
So it'll depend on the purpose. If you need your guests to also have "edit" access to any other page, then this'll be a no-go :(
This is not the case... even with view only rights guests can still create linked view of your database... so this simply does not work. @@DanielCanosa
I guess, if the "Client" uses the Notion's search function, he or she can view all the entries in the Tasks database (on the search result page)... :-( And on the Task's page, the Client can choose the Projects property, and see all the projects (moreover, they are all links, and he or she can click on the projects, and see them all...) Am I wrong?
You're right. Are you still looking for a solution? I just made a video tutorial with an alternative that doesn't risk exposing all entries on the databases, you might find helpful
@@Stackoia shure, I'm still interested
Was happy to find your video, but when I follow it I can't get it to work like yours. In my case I have 3 dataBases, Clients, Products, Tasks. I'd like to share the Client page with the client. Inside the client page I create linked database with tasks and advanced filter. But, when sharing that page and viewing it from the user with view permissions, I do not see the linked database. Seems like I need to share that tasks DB as well which is what we like to avoid right? I'm I don't something wrong?
I tested this approach earlier. However, one can download the entire database as a pdf or CSV even with view access. So, this really defeats the purpose of trying to create a ‘private’ view. Thoughts?
I have tried to download the core tasks database shared with the client and I get nothing... Which view are you sharing that you can see the private info in?
@@DanielCanosa While exporting, change the "Include Database" option from "current view" to "everything." The whole database will be downloaded as CSV even if you have the entries hidden using advanced filters. Notion doesn't allow the 'disable export' feature except for its Enterprise plan. This one functionality will open so many possibilities.
@@dineshgoswami6237 you're right Dinesh!
I believe very few people would manage to find this way (been using Notion for 2+ years and haven't thought of that myself!) but it is indeed a possibility. So it's something to take into account.
Thanks for sharing Dinesh
Well spotted @Dinesh, although very unlikely, if this happens the damage can be really great.
I saw that the video is a year old. Is it still possible to do this? Or is there a new workoaround now?
still the same situation :(
@@DanielCanosa so it is no longer possible, is it?
Either use Notion'a API or a Notion integration, as it's still not possible natively. We did the API route and recently opened our solution as an integration for others to use. Tutorial video on my channel if you're interested
Switching to advanced filter...I wonder how did you ever find it out! Thank you! This is perfect
Hmmm at 5:59 when you open the card, it looks like your clients will be able to unfurl all of your hidden properties @Daniel Canosa - is that correct?
one question: if you set a filter in the "All open" view to hide everything, neither you will be able to see the database. So how do you work on it? You disable the filter? In this case if you disable the filter the client can see the database. Other solutions?
You use linked databases from anywhere else
@@DanielCanosa Hi, I have the same question as Lorenzo and still don't get it. I have to share my "tasks" database with the client as well so he can see the tasks of his projects, so he has access to all my tasks.
@@sarah-loulepers9835 yes, but you leave the database with a filter that returns no results. Then you access to your database via linked views that you can filter however you want
did you understand his answer?
trying to get some help with that
Hi Daniel, I would love to share filtered databases through "shared web links". However the web link unfortunately shows the table in full. Your solution here is great, though clients are still needed to sign up to notion and create an account. I would like to share them a weblink to the content to show. Any solution for this?
yup! use super.so or any other website builders and embed the view you wanna share in your own domain :P I know it's not the best solution, but it'll be the only one that doesn't require your clients to sign up for Notion
when the client comments on a task and uses @ he can still access all the data. Does anyone have a solution for this?
Very interesting, thank you Daniel. Is there a way to hide the properties section to the client ? (Data Range, Open Class List, Status, ...)
Hi Daniel, this is great, is there a way to use this method with a "Can Edit" setting? I'm sharing my projects with some externale contractors and they need to edit the tasks, but I don't want them to see anything that's related to other projects.
Hi Daniel, same question than Stephen !
Hi! Did u try it? I need use this with the edit (now full acess) permission. I'll try it tomorrow but If u can tell me about your experience first, I'll appreciate so much.
Any updates? I want the person to be able to edit their own information but not see other people's information
Not possible no
This just filters records, but does not allow to select which fields you want to share.
If you need to share only certain fields then I have a tutorial on my channel, you might find helpful
i dont understand why when i publish a page with a database, when i open the site, i need to ask permission to see it
how do we solve this anyone?
Probably because you’re not publishing the core database and only the linked view of it
@@DanielCanosa Thankyou so much. this works
Inside the tasks for the client, the tasks database has a field that links to another database. I want to ensure that the client can only see some fields (not all), when opening up this field as a page. For example, the task has a person responsible. The person responsible will have fields such as job role, email and team. I want the client to only be able to see the job role when opening up that field as a page. Is this possible?
Hi , Great Video.!!!
when i share a project i always must share the full database with my client and he see the content. I try to send you a screenshot but i can't attached here
Daniel! ¡Qué raro! ahora ya no funciona ¿ha cambiado algo? cuando comparto el proyecto ya no se pueden ver las tardes.🤔
Thanks!!! I was struggling with the same situation!
Hi Daniel, than you for the video. I'm trying to share a database at the teamspace and it appeared for person as empty page. It works perfectly fine for sharing my personal data base. Is there any way I can partially share database from team space?
He can still click on the Relation and see other relation options of clients.
Hello, I did exactly the same, but when sharing the page with the client, he can't see the "Linked View to page" any idea why is this happening?
Because he doesn't have access to the core database
You missed the big thing, which until today I still try to find an answer...He can still see all other Project list if he click to filter the project.
If I use the contradictive filters on the master database, I won't see anything anymore. Is there a way to still see and use the original database without letting others to see the original database?
Linked databases
Hi.
I tried to make it and it doesn't work in my case (in a private space).
The process seems simple :
- Database for listing of items. Each items is a page of database.
- Database for listing of category. Each category is a page of database.
In you video, you didn't explained to share the Database, you only speak about share category (project) page database. If you only do it, the user who you shared the page won't access to it because no access database == no access to an item (page) of the database. But in fact, when you share the project database you will have new problem, the user can see all projects...
Silly question, seems I followed the steps to related 2 DBs, then created filter in Task DB on project page (failed to change to advanced filter as no such option). Then share to my other account with view permission. The other account could only view the project page but not the task DB underneath it. What have I done wrong?
my guess is that you didnt give access to the core Tasks database... so go wherever that core DB is sitting and give access to your other account to it. That'll work
this unfortunately somehow does not work for me. if I share it I cant see the table view of the database but only the empty site... the written text on the site I can see but not the linked database to it...
If you're open to using a Notion integration for this problem, I just posted a video tutorial on my channel
@@Stackoia thanks a lot
OMG THANK YOU SO MUCH. I've been trying to do this for ages, over complicating it. All I needed was the advanced filters and the Hide Database Title. The headaches you spared me xd
You're very welcome!
Hi - can you perhaps tell me how you set up your solution?
So you won't be neighter able to see your data base. Beacause it is hidden for you and the client at the same time. I Don't unserstand ??? Can you please help
Great video, I'm sure I will use it soon. Quick question, I have a database that I want to hire a data entry person to do the inputting of data, but I do not want them to see all of the fields in the database when they click "New". How do I do this? It seems I should be able to filter the fields that show when clicking "New" but that is not the case. At least not that I found. Please help. Great work. Love your channel...already subscribed
I'm afraid that's not possible.
If the only thing you want this person to do is data entry, you can build a Tally form with the data you want them to enter and connect it to notion. This way the data entry person just needs access to that form, and not to notion
@@DanielCanosa Thank you for the quick reply. I appreciate it. In the Notion suggestion box. :)
Very helpful! Thank you Daniel. I didn't use this for exactly your use case but I just made the sharing of meeting minutes much safer for our company because now no-one can drill down to our core meeting minute database and read the minutes for other projects or clients.
Glad it was helpful!
MAN THANK YOU SO MUCH! YOU ARE A KING!
You're welcome!
You're a life saver. Thanks Daniel!
still working? with the new pricing is it change?
Is there a way to do this, but with editing rights instead of "view" rights?
oh.. my.. gosh... this solved SUCH an issue for me. Thank you so so much !
Followed all the steps and have some weird feedback...
The only way I could get the client (guest account -> view only) to see the tasks I had to do these three things:
1. Give client guest access to the [Client Status] table (as in the video)
2. Give client guest access to the [All Tasks] table (and create the block filter, Done checked and Done unchecked)
3. Give client guest access to the [Projects] table (and create a separate block filter there too)
Can't figure out if I'm doing something simple wrong, but overall this flow makes it unworkable/impractical.
Thanks for trying, Daniel!
Would be so simple if Notion would just create a permissions level to share a partial view of a database.
Shane
I agree that it's a pain in the ass to have to find these workarounds... I agree that Notion should have this feature as high priority since it's impacting so many use cases I already stopped counting
I have the same experience... It can't really be used... since update of the All Tasks table is filtered to it is hard to do edits...
Thank you for this! So useful!
Suddenly, the guest I share page to view only still can change the filter of linked database to Project :(. How can I do?
hey Viet, I believe that what your guest can change is the filter within your filter, isn't that the case?
@@DanielCanosa Yes, they can
it worked somehow (but if we share with multiple clients specific data for each one it will be hard to maintane)
Hi Daniel, you mentioned in this video that you managed all the database in one place and use views in other place, it's there a video for this topic?
not in this particular topic, but it's something I say often. This is basically having just one page where all databases are located, and use linked databases everywhere else.
Daniel, that's awesome solution thank you a lot, especially the elegant workaround with advanced filters! I almost succeeded with it, but still there is just one problem: when select a filter user will see the list of all projects, have you find any workaround on that?
STR:
1) Created a project, granted user permissions to it
2) Granted permissions to Projects DB (with advanced filter). If not - user won't see any tasks at all.
3) Assign some tasks to this project
4) Granted permissions to Tasks DB (with advanced filter)
5) On Project user can see tasks that's fine, but when he selects filter "Project" - he will be able to see all your project, even if page Project DB is empty (due to advanced filter)
Hey, I just recently created a tutorial video for a solution with granular permissions so that users can't see all your project when playing with your existing filters.
Hi ! I might not understand fully, doesnt the master db appear in the shared pages of the client then ? Even if we only share the view relative to this client, as we have to share the entire db ?
You are my hero
Did you really succed to do this?
Sadly there is a problem
1st You have to give access to the core DB
you create the blocking filter on the 1st view and it works, but if you have other views (which is nearly always the case) the client will have access to the all the data
This seems to work if you choose to not have any views on the DB page other than the The one with the blocking filter
This will make an essential feature impossible
which is creating several views on the core DB page, and using linked views of the db from different pages utlizing the pre made views, without having to remake the whole view each time.
This is tough to sacrifice
@@omarmohamed-mu4np Well you can build your views elsewhere and you will still get to copy them... you dont need to make your filtered views on the acctual database... the bigger issue is that the above technique does not work.. because client can make their own Linked view of databases and see anything they want
You are a genius brother
That's a very good hack! Thanks for sharing!
Hi Daniel, Can you please Help me and answer the question? 🙏🙏
I have to say, I have watch this video more than 10 times, because I want it so much, lol, as an experienced software engineer, I didn't manage to do it...
1. I have a table, with a columne named public, intend to be used as a filter.
2. In that table, I created a templete, the content is a linked table, which linked the table itself.
3. Use advanced filter, select public == true
4. Share the templete, open it in browser, the content part is blank.
And as you pinned message says, there is also a security issue. Is there any automation tool, helps to filter one table to another? the logic is simple.
have you shared the core database with the other account? Not just the linked database
I believe this video is so not fully understood, and there are some missing parts (from my experience and because of the questions here).
if you don't want the client to see filters so you need to create a filter in your database that hide everything?:
A) how can you work from a database with a filer that hides everything?
B) if the filter hides everything - the client also won't see everything.
Anybody figured this one out?
this is not the way to ask questions
@@DanielCanosa I'm Very sorry, it's the frustration after 4 hours of trying to figure this out, will edit🥴
Can you please help me with that?
It's 2024 and we still have the same problem, unbelievable.
Totally. This is the biggest issue notion has
You just enlighten me.
Thanks so much Daniel! This is so interesting and I was a little desperate couse I was needing fix diferents access to a two views in a single database for a clients Workspace and just found thats isnt "officially" posible... I'll try this tomorrow. Cheers from Argentina 🇦🇷✨✨✨
Followed - Great content bro
I've been asking Notion to fix this since they launched databases years ago
Huge issues to solve
Si los usuarios buscan con la herramienta buscar, pueden acceder a todo el contenido, tu video me ayuda a ocultar los datos en las vistas pero realmente siguen estando accesibles, no acabo de encontrar una solución definitiva, pero gracias, si tienes más opciones me gustaría saber un poco más
Unfortunately, this no longer works.
Hey, if you're still exploring this problem, I just posted a video on my channel with a solution that works
hehe this is clever indeed :P
@Daniel Canosa and @Dinesh, I may have found a way to make partial views work. I followed your setup, but with the following adjustments.
In the private master page for the data, I have a public web link enabled that has "can comment" permissions only, but does not allow editing, duplication, or search indexing.
In the shared page for the data, have the permissions set as follows:
-Share page level: (1) public web link on, "can comment," but all other disabled and (2) invited guest "can comment" permissions only.
-Views level: (1) inherits and (2) invited guests "can comment," "can edit content" or "can edit." The "can edit content" permissions say the invited guest can just edit but not database views or structure, so not sure what happens if you choose that option.
-Locked the shared page and shared views.
-Double checked that the master database name is not showing in any of the shared pages or views because that would let the user click a link to see the master database.
For those who know Notion, does this work to make it so that you can safely share ONLY part of a private master database with a client but hide some of the columns in the master data from the client-facing view?
One additional question I have is - is there a way to do this kind of limited sharing but with the master page data not available at any public web link? I don't think so because if I disable the public web link sharing the master page data, then the share page itself is still visible, but none of the data being pulled in from the master page, so nothing shows up. My assumption is that the public web link has to be on for the master page data for the share page and shared views to be able to pull data from the master page.
I believe this would have the same issue. Even if the database name is not visible, anyone could open any of the database items as a page and navigate to the core database via breadcrumbs