adding database/spreadsheets to our websites, linking them

  • 1
  • Question
  • Updated 7 years ago
  • Answered
Can anyone be able to give me some instruction on putting a database file on my website? What I want to do, is have like an Excel Spreadsheet with formulas but what I believe I need to do, is figure out how to link that to a hidden file which holds data. I hope this makes sense. For example, if I click on the spreadsheet link, I get a list of items I can add? Please ask me anything you like if this is not clear. I am very new at this as many of you already know. Thank you in advance, denise:) PS I don't understand which to choose in the list of "products or services"? It's about my website on Yola and I don't see that option?
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes

Posted 9 years ago

  • 1
Photo of Amy Muller

Amy Muller

  • 32 Posts
  • 0 Reply Likes
Hi oregoncountry. You've posted your question in the Get Satisfaction customer support community. I'll move it to Yola's customer support community. I'm sure someone there will be able to help you.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
well now Im totally confused, LOL! I thought this was where all the Yola website questions went, that explains a lot, thank you much:) denise
Photo of Amy Muller

Amy Muller

  • 32 Posts
  • 0 Reply Likes
Hi. *THIS* (where your topic lives now) is where all the Yola questions go. When you first posted, you did so at getsatisfaction.com/getsatisfaction rather than getsatisfaction.com/yola, but I moved it for you.

You just want to make sure that it says "Customer support community for Yola" at the top of the page before you create topics if your topics are meant for Yola.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
I see now, LOL!! But I sure thought you were one in the same:) I see now the URL has to have Yola in it as well. The two boards are easy to confuse since they are identical;)

Thank you amy:) denise
Photo of Amy Muller

Amy Muller

  • 32 Posts
  • 0 Reply Likes
You're welcome, Denise.

Yeah, I can see how that could be confusing.

To explain a little further, getsatisfaction.com is a service that we provide as a place to host a customer support community. We have about 16,000 companies represented here, Yola is one of them. We also have our own customer support community which is where you posted originally. To find other companies using Get Satisfaction or other customer communities (not all of them have company participation; some are just customers helping each other) you can use the search box at the very top right of the page.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Amy, that was very kind and helpful, thank you so much! I know for sure this is one of the best places I have ever found online in my "whole" online life;) People are truly knowlegable as well as personable.

Thank you again, denise
Photo of Amy Muller

Amy Muller

  • 32 Posts
  • 0 Reply Likes
You're welcome, Denise. Glad it's been a good experience. You're in good hands now with the Yola support team and champs. They're awesome!
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Hi Denise,

It takes a little while to work out where you are in Get Satisfaction. Yola is one of their many clients. You're safe and sound now!

You can embed a spreadsheet into Yola.

There are two ways that I have found. one very recently, which I have just begun to investigate.

If you own your domain then you can sign up with Google Docs. You can simply create a spread sheet on your desktop first of all and do as much of the setup work as possible. Then you upload it to Google Docs. You publish it there. Google docs gives you a code which you drop into your website.

You or if you allow others, can update and manipulate the spreadsheet live. It's whole purpose was designed as a collaborative tool.

The second newer option is Zoho. they have a spreadsheet and an Access like database and other bits and pieces. From my little exposure it looks like you can also upload a spreadsheet to Zoho. Get a code, embed and you're away.

Have a look at them and see what you feel about each. I am now leaning to Zoho.

i have used Google extensively and it works well. there are a couple of things that you have to remember when using it and particularly important is the Update function. Easy to forget but forget at your won peril.

Hope this gives you a bit of a background.

Great luck keep us informed and ask if you feel that we can help on any issue. Monique and her team have good experience with google Docs also.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Hi Peter, that all sounds great! I paid for my website, will that make a dif? I have the 19.95 package for 12 months? Meanwhile, I will go check out Zoho. I have MS Works on my pc. I wish it were Access and Excel but my old hard-drive was lost and I didn't have the cd's to reload it:( Well, something will work, I know it:) Thanks so much for all the info peter, denise in OR
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Oh, I misread, you said "own" and I thought it said "won" LOL!! How is she ever gonna make it, LOL!! Ok, so, I have to create the spreadsheet in Google docs?? Not my MS Works Spreadsheet? Actually, I've done this, in Google docs. But that's as far as I got. denise:)
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Denise,

shhh! I mistyped and while you weren't looking I changed "won" to "own"

Just check with Google Docs if it will take an MS Works sheet or check MS Worksheet to see if you can save it as an xls sheet. If either of those work, you're laughing!
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
oh you are a sneaky snake and here I thought I lost my one, remaining marble. Ok, back to biz:) But yes, I am laughing:) Zoho looks good, but I still haven't figured out how to link a database to a spreadsheet or maybe get a 2 in 1 deal. I do appreciate you taking the time and hey, helping me and others will only perfect your "proof-reading" abilities
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
well "some" html didn't include my pic of einstein. bfn:) Im off to further examine zoho
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Do you know how to use a spreadsheet as a lookup database?

That's what is generally referred to in relation to spreadsheets rather than a true tables style database. Zoho offer the ability to upload the spreadsheet and by some magic create an interactive database. I Haven't used it as yet. This really is going to be a "biggy" with web-builders, I'm sure of that. You're at the "cutting edge" Denise

Zoho have a true database that you can build tables with. i haven't used it I simply went window shopping on that one.
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
They won't give you a simple champ badge: it will be Denise OR. Consultant Director Embeddable Databases on Yola. (VP. if you like!)
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Im so glad to be on the cutting edge of something except right now, Im just on the edge of my chair about to fall off. Im seeing 3 of everything, LOL!! Tired, but, I will be "brainstorming" in my sleep tonight;) Thank you Peter, you sure are a smart feller for bein so young;)

denise, in Oreeeeeeeeegone!!
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
LOL!! You da champ!
Photo of Pablo

Pablo

  • 39 Posts
  • 0 Reply Likes
I really have no idea what you are trying to do on the spreadsheet side, but I'll try a suggestion.

Is it possible to move the database to a hidden sheet in your spreadsheet, and then run the database query on a defined range in that hidden spread sheet ?

I use this technique on a data array of about 40,000 records with about 30 fields per record.

While this is not a true database, it can actually yield pretty powerful output.
I use the Advanced Query feature in Excel, using the "Copy to another Location" feature.

I would suspect that both Google and Zoho would have similar features in their spreadsheet.
Photo of Donald

Donald

  • 2991 Posts
  • 37 Reply Likes
if your users have the same software you have (MS Works for example) then you can upload it to the file manager and post it on your site but when your users open it, it'll attempt to open it in works. If you prefer to have MS Word and MS Excel you can get that for free (full version).
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Free. Always good Donald. Share!
Photo of Donald

Donald

  • 2991 Posts
  • 37 Reply Likes
well... download the free trial from Microsoft website (that's right... get it directly from the source)... and then go to... serials.ws and search from Microsoft Office**** .... the asterisks indicate the exact name of the office you get... for example... Microsoft Office Professional 2007 or Microsoft Office Enterprise 2007... after you search for the serial on serials.ws look at the success rate of that serial in percentages and choose the highest one... after using the serial to install your "trial" you'll have the full version... DO NOT use the trial code they give you on Microsoft.com, instead, use the one from serials.ws ... you will probably need to activate your MS Office... attempt to do this by internet connection, sometimes it won't allow you to (although you'll still have Office - it just won't be validated yet to download templates and stuff) ... if you can't activate via internet connection, then select the option to activate by phone and you'll be prompted to insert some digits into the automated system, then they'll give you a code to put into Office... this code will activate your Office. Need help? Ask me!
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
I think I am really confused in my ideas of doing this. Last night, it came to me that there are probably "whole programs" that I might be able to embed, like the Nabble Forum?? Only what I need is a food diary/journal with a food database "in it". I was worried someone would steal my idea but that is stupid since they're all over the web already, LOL! Mine will have some improvements though because I plan to beat the pants off the comptetition, LOL!! But wait, you can't "try" the journal unless you join, and although it's free, no one will want to do that. So, just let me explain how this particular site works ok.

You go to the diary/journal page and you see what looks like a little spreadsheet. On that spreadsheet you click on "add food" and a list pops up(a database of like 1000's of foods). You pick the food you ate, or are going to eat, and then it enters it with it's nutritional info to the little spreadsheet. You can then keep track of every days food consumption. You can also run reports. This is what I want to do on my website and I can't figure out what "they" used and how they got it on their website.

thanks so much to you all:) denise
PS they also have the similar program but it is for tracking each days fitness.
PSS You are all probably going to kill me because I didn't just tell you all this from the beginning:(
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Hi Denise,

Restful sleep?

It is a database. The structure I don't know.

Can it store client's profiles so that they can update it day by day?
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Yes, the ones I've seen are like that, yes, I slept pretty well;) Here is a page of a site and it tells exactly what I am trying to find to embed in my website:)

http://www.myfooddiary.com/online_foo...

Here is a paragraph on the food diary itself:

Food Search
At the top of the Food Diary page, you will find the most advanced food search engine available. Simply enter your search phrase and click "go". Our system will quickly and accurately search our food database of over 50,000 food items. You can also search for foods and recipes that you have manually added to your account.

I want something like this and also, a fitness tracker that will do the same thing.
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Big job. You need a relational database.

I would guess that they're doing this offsite.

That being said doesn't prevent you from doing it onsite as your space limitation is not a consideration.

You would need to design your database very well for efficiency. that's truly in the realm of dbase design.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Ok, and when did you say you would start that for me Peter?? LOLLLLLLL!!! Well, back to the starting blocks!! Thank you much, and have a wonderful day! Im sure I'll be back with more "bright" ideas for my website, lol:)
Photo of Peter

Peter

  • 2569 Posts
  • 113 Reply Likes
Good luck. Check Zoho and general database design resources.
Photo of Denise

Denise

  • 393 Posts
  • 3 Reply Likes
Oh thanks for the reminder on Zoho:) I am finding software to download that has the food diary and database but I can't tell if you can embed it and let lots of people use the program? I can download it and use it for me personally. But don't need that, I mean I need it but want others to be able to use it on my site;)