Perfect timing ... 🤔 ... and perfect title ... 🤭 Question please: I have an Access database with a list of important dates for a variety of functions, i.e. Marketing, Management, Finance etc., Can those dates be linked to their respective hub site so they can roll up to 'home page to display as 'News'? Thank you ... PS I am new to your site and am finding it very useful ... good delivery ... and you have an excellent comprehension of the material.
Hey 👋, thanks for your outstanding feedback! I am not 💯 sure of your requirements but if I understand, I think you’d be best creating multiple department communication sites. Use the events web part on the department sites to have your key dates related to departments. Then on the Hub add the events web part to roll up events from the sites associated to it.
@@Dougie_Wood Thank you for your prompt response. I subsequently realized my question is maybe more of an 'Access' database question than a 'SharePoint' question, and hence maybe a bit unfair of me to ask (mea culpa ... but I did say 'Perfect Title ... 😵) " ... Then on the Hub add the events web part to roll up events from the sites associated to it..." I understand ... although I have yet to do it. My question (in hindsight a bit unfair) was how can I connect SharePoint to Access where the 'dates' currently reside (fyi ... hundreds of important dates that will need to be periodically updated in SPoint, say weekly). Rather than posting a third party 'news' site, I was hoping to use the 'news webpart' to carry the 'dates' from the department sites to the main hub/home site. Thank you again for the prompt response. I really do think you have an informational 'gem' of a site.
@@chh8860 You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Great video. Wondering if you could help me here with a tricky SharePoint implementation - Do you know if registering an existing SharePoint site as a Hub Site will create a corresponding Team in Microsoft Teams? I’m looking to create a central hub site (B2B Hub) for a B2B client that has various departments such as Sales, Ops, Finance (so ideally 3 SharePoint sites) but my client prefers managing all their associated files of the other departments under the one B2B Teams. Should I be looking at creating one SharePoint Teams site, convert that as a hub and then use the channels function in Teams to create a channel for each department?
My number one challenge is this: I want to associate Vendor Documents with a central Vendor List. That document could be a contract, a W9, a service agreement, a price list, a quality certificate, or an invoice. Each of these documents would be stored in a Document Library managed by the respective department: Accounting, Legal, Quality, Purchasing, Etc. Previously, a Lookup Column could only reference a record from within the same Site. Is that still the case? Could I store a handful of Master Lists in a Hub site which could be referenced by associated sites?
Look up columns still work the same way, I don’t know your full requirements but it might be worth looking into content type hubs and how you can pull documents tagged with meta data back into a centralised site.
@@Dougie_Wood Thanks for the response, I've tinkered with content types using Sub-Sites, but looks like I'll have to dive in deeper. I'm not a SharePoint Admin in my org, so I'll have to get some cooperation from IT to test things out. Requirements: 1. Business data is stored in lists and document libraries 2. Each list/library is appropriately permissioned so that group owners have full control while stakeholders have visibility. 3. Each list/library is connected with meta data (as appropriate) to 4 central Master Lists: Plant Location, Vendor, Customer, Item. What I'm finding is that requirements 2 & 3 are often in conflict. I am forced to choose between data silos and permissions hell. I have an eye towards creating PowerApps to function as a more robust front-end for the data, but that's a ways off, and I'm trying to get the back-end data structure down first.
@@Dougie_Wood Thanks for responding. My full requirements are pretty simple: an extensible ERP system built entirely in SharePoint without heavy coding or paying for additional licensing. In all seriousness, I'm just looking for a better method of managing important business information and documents. For example, all stakeholders should have access to information such as: how many forklifts we have at all plants, whether they are owned or leased, and how many hours of operation each has. That shouldn't be a, "Let me make some calls and put together a spreadsheet for you," situation. That said, I don't want to build a bunch of one-off solutions that utilize choice columns or managed meta-data, when it would be better to use a lookup column to maintain data integrity. I'm pretty sure creating custom column types in the hub is the best compromise. I'll head down that road and see where it leads.
My question is WHY?? I still don't understand what problems are solved by this! It's a site with news... i am already trying to avoid Microsoft news, google news and all the other news are bestowed upon my head!! All the hubs examples i find online are just full of news... how's this increasing organisation and productivity??
Simple question. If I don't have permission to a site within the hub, will the news rollup display information from that site i have no permissions to, on the hub to me?
Please support ME 🙋♂️ by becoming a channel member for only £0.99p! share the LOVE now 💖 Click here: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Dougie, great video and thanks for sharing. I do have a simple question. When you add associated sites for departments i.e. Sales, Operations etc, can these be Teams site or do they have to be Communication sites. I would like to use my main Hub page as a step off for departmental sites where teams share files etc. Thanks in advance
Yes, they can be Team sites 😀 You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
You need to click on the edit section icon at the top right corner of the section if it is the side bar section. It will then options for you to change the colour of the section.
@@Dougie_Wood thanks for the quick reply but I'm still stuck. I've chosen a two thirds/one third layout and i can change the background of the tiles but not of the one third as a whole. if I select a color within the webpart it changes the the two thirds as well as the one third
You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖 More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Perfect timing ... 🤔 ... and perfect title ... 🤭
Question please: I have an Access database with a list of important dates for a variety of functions, i.e. Marketing, Management, Finance etc., Can those dates be linked to their respective hub site so they can roll up to 'home page to display as 'News'?
Thank you ...
PS
I am new to your site and am finding it very useful ... good delivery ... and you have an excellent comprehension of the material.
Hey 👋, thanks for your outstanding feedback!
I am not 💯 sure of your requirements but if I understand, I think you’d be best creating multiple department communication sites.
Use the events web part on the department sites to have your key dates related to departments.
Then on the Hub add the events web part to roll up events from the sites associated to it.
@@Dougie_Wood Thank you for your prompt response. I subsequently realized my question is maybe more of an 'Access' database question than a 'SharePoint' question, and hence maybe a bit unfair of me to ask (mea culpa ... but I did say 'Perfect Title ... 😵)
" ... Then on the Hub add the events web part to roll up events from the sites associated to it..."
I understand ... although I have yet to do it. My question (in hindsight a bit unfair) was how can I connect SharePoint to Access where the 'dates' currently reside (fyi ... hundreds of important dates that will need to be periodically updated in SPoint, say weekly). Rather than posting a third party 'news' site, I was hoping to use the 'news webpart' to carry the 'dates' from the department sites to the main hub/home site.
Thank you again for the prompt response. I really do think you have an informational 'gem' of a site.
@@chh8860 You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖
More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Great video. Wondering if you could help me here with a tricky SharePoint implementation - Do you know if registering an existing SharePoint site as a Hub Site will create a corresponding Team in Microsoft Teams? I’m looking to create a central hub site (B2B Hub) for a B2B client that has various departments such as Sales, Ops, Finance (so ideally 3 SharePoint sites) but my client prefers managing all their associated files of the other departments under the one B2B Teams. Should I be looking at creating one SharePoint Teams site, convert that as a hub and then use the channels function in Teams to create a channel for each department?
Microsoft teams is not related to SharePoint hub sites.
In reverse, when you create a Microsoft team it creates a SharePoint team site.
My number one challenge is this: I want to associate Vendor Documents with a central Vendor List. That document could be a contract, a W9, a service agreement, a price list, a quality certificate, or an invoice. Each of these documents would be stored in a Document Library managed by the respective department: Accounting, Legal, Quality, Purchasing, Etc. Previously, a Lookup Column could only reference a record from within the same Site. Is that still the case? Could I store a handful of Master Lists in a Hub site which could be referenced by associated sites?
Look up columns still work the same way, I don’t know your full requirements but it might be worth looking into content type hubs and how you can pull documents tagged with meta data back into a centralised site.
@@Dougie_Wood Thanks for the response, I've tinkered with content types using Sub-Sites, but looks like I'll have to dive in deeper. I'm not a SharePoint Admin in my org, so I'll have to get some cooperation from IT to test things out.
Requirements:
1. Business data is stored in lists and document libraries
2. Each list/library is appropriately permissioned so that group owners have full control while stakeholders have visibility.
3. Each list/library is connected with meta data (as appropriate) to 4 central Master Lists: Plant Location, Vendor, Customer, Item.
What I'm finding is that requirements 2 & 3 are often in conflict. I am forced to choose between data silos and permissions hell.
I have an eye towards creating PowerApps to function as a more robust front-end for the data, but that's a ways off, and I'm trying to get the back-end data structure down first.
@@Dougie_Wood Thanks for responding. My full requirements are pretty simple: an extensible ERP system built entirely in SharePoint without heavy coding or paying for additional licensing.
In all seriousness, I'm just looking for a better method of managing important business information and documents. For example, all stakeholders should have access to information such as: how many forklifts we have at all plants, whether they are owned or leased, and how many hours of operation each has. That shouldn't be a, "Let me make some calls and put together a spreadsheet for you," situation.
That said, I don't want to build a bunch of one-off solutions that utilize choice columns or managed meta-data, when it would be better to use a lookup column to maintain data integrity.
I'm pretty sure creating custom column types in the hub is the best compromise. I'll head down that road and see where it leads.
My question is WHY?? I still don't understand what problems are solved by this! It's a site with news... i am already trying to avoid Microsoft news, google news and all the other news are bestowed upon my head!! All the hubs examples i find online are just full of news... how's this increasing organisation and productivity??
You can roll up other types of content not just news 👍
Simple question. If I don't have permission to a site within the hub, will the news rollup display information from that site i have no permissions to, on the hub to me?
Simple answer. No it won’t 👍
You will only see news from sites you have access to, it’s very clever 😉
Please support ME 🙋♂️ by becoming a channel member for only £0.99p! share the LOVE now 💖 Click here: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Dougie, great video and thanks for sharing. I do have a simple question. When you add associated sites for departments i.e. Sales, Operations etc, can these be Teams site or do they have to be Communication sites. I would like to use my main Hub page as a step off for departmental sites where teams share files etc. Thanks in advance
Yes, they can be Team sites 😀
You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖
More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
They can be either comm or team sites, I just prefer comm sites personally 👍
how do you change colors in a section? your bar "useful links" is colored while the rest of the page isn't. I cant get my head around that one
You need to click on the edit section icon at the top right corner of the section if it is the side bar section. It will then options for you to change the colour of the section.
@@Dougie_Wood thanks for the quick reply but I'm still stuck. I've chosen a two thirds/one third layout and i can change the background of the tiles but not of the one third as a whole. if I select a color within the webpart it changes the the two thirds as well as the one third
nvm, I got it. I was using the wrong format. thanks a lot a congrats to your videos! really helpful and nicely explained
@@user-np1jp3pp2r glad you enjoy my videos! 👍
You would benefit from my channel membership, including, exclusive training courses and a chance for a live chat in a Q&A drop in! 💖
More details: czcams.com/channels/bl8QtLtzfnv6jPoc8gPqFQ.htmljoin
Could you do a video on how to get pronouns in your bio on Microsoft 365?
This is now possible with an out the box Microsoft 365 feature! 😃
Microsoft really are an ally 🏳️🌈