This is possibly a bit of a longshot, but I am wondering if anyone here can help with this:
I am finding that I need to track more and more information about my huibs, including:
- Name, title, URL etc.
- Where I have previously shared them and when (G+ communities, Facebook groups etc.)
- Metrics (Page views, likes, plusses)
- Elements of the guides (links to other hubs etc.)
I will probably have around 50-60 individual pieces of information per hub and it is becoming unwieldy to do this in a spreadsheet (which was my previous type of record keeping), so I am looking for another solution.
Ideally, I'd like a light weight, simple to configure database or something similar; I don't want to have to get into programming and data linking (not a big fan of Access or anything like that), but the database would need to:
- Be easily configurable
- Be easy to customise
- Allow multiple tabs where I can add fields / content
- Allow outputs, ideally to a spreadsheet
- Be sortable / filterable on any field
- Be free or cheap(!)
- Ideally be cloud based (rather than local install), although that isn't a deal-breaker and I can work with local install if there's nothing decent that's cloud based
Does anyone have any suggestions please?
Do you work for a corporation that has a license for Microsoft Office? Usually if they have a license you as an employee can buy a discounted full version of Office (about $10) - this would then include Microsoft Access.
I just saw that you don't like Access - sadly most of the database will have similar functionality.....
..Access does come with templates that could probably be adapted.
I would say that you could still do everything you want using some of the DATA functions of Excel - there are some great sort functions, conditional functions etc....
I also found this - which uses Google spreadsheets as a database.
I have'nt checked the video out though...
The other thing to consider, if you're using Excel, is still create the data in one worksheet and then use Pivot Tables to analize the data - they are pretty powerful!!!
Here's another Hub for you, Simey C: "What Is a Pivot Table"?
Already have one called "How to use pivot tables in Microsoft Excel" - didn't want to self promote too much!!!
I do like me some pivot table action!
Unfortunately, 50 columns in Excel is just getting awkward! I think I am going to have to bite the bullet and brave the choppy waters if Access...
by Julie-Ann Amos 8 years ago
Or know of anyone who is? I have a custom built database for project management that needs work on it and the original designer and I have parted company as it all got too difficult for him.I would prefer someone known or a referral rather than to go to the market blind... and of course, cost...
by Claire Evans 5 years ago
Can anyone suggest a name for a business that specializes all fields of artisan work?My sister's fiance can do just about anything: electronics, mechanical, renovating, painting, etc. Can anyone suggest a business name because he wants to start his own business. A name to illustrate he...
by fordie 6 years ago
Can anyone suggest some wacky travel blogs with fun, original contentI don't care whether it is yours or not. I'm just looking to review a range of these for inspiration. Thanks
by Info Bucket 8 years ago
Can you suggest me a topic to write hubs?? I need some topics with search engine demand, please help me...
by Skarlet 5 years ago
I was just creating a hub about Grace Kelly, and as soon as I typed her name in the title area Hubpages popped up a title suggestion stating this is an "exclusive" title that should get good traffic. Has anyone had this happen? If so, did that hub get a lot of traffic?
by Karen Hellier 4 years ago
Can anyone suggest a good writing site to make money on?I write for HubPages, Textbroker, and a blog. I want to add one more site, similar to Textbroker, that I can earn money from. Any suggestions?
Copyright © 2018 HubPages Inc. and respective owners. Other product and company names shown may be trademarks of their respective owners. HubPages® is a registered Service Mark of HubPages, Inc. HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.
|HubPages Device ID||This is used to identify particular browsers or devices when the access the service, and is used for security reasons.|
|Login||This is necessary to sign in to the HubPages Service.|
|HubPages Traffic Pixel||This is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.|
|Remarketing Pixels||We may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.|
|Conversion Tracking Pixels||We may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.|