I've been using a spreadsheet (actually, three or four different spreadsheets....) to keep track of names, contact info, and task completion for a large number of people. Would switching to a database ultimately be easier and less stressful? And if so, what would be the best software for a database newbie to use? Or is there some other perfect solution out there? [more inside]
posted by kittenmarlowe
on Jan 29, 2012 -
Need ideas on how to keep track of people making multiple payments for large trips or activities, with the ability to report how much they still owe. Much more detail inside. [more inside]
posted by kraigory
on May 23, 2011 -
Is there a way to turn my Gmail account into a database? I have tons of valuable information in my 15 gigabytes Gmail box...can you recommend exciting ways of extracting it? [more inside]
posted by skylar
on Feb 3, 2011 -
[web programming filter] I need to build a web page that displays spreadsheet data. The data in the spreadsheet changes depending on which user is logged in to the site. Some of the data is preset and some is entered by the user (and saved between sessions).
What might be the most efficient programming solution and the easiest to maintain? [more inside]
posted by Drasher
on Aug 3, 2010 -
Well, I created a spreadsheet in Google docs. A simple, no frills document where there are various columns - one s for email addresses.
Those addresses I want to go into my Address book in either Gmail or Thunderbird. Downloaded the spreadsheet into Excel - in CSV format - tried to save it to text - it's obviously not working. Someone online directed me to the Google Scripts and to API.
This is so not my forte' and it's for a non-profit and am getting lost in a sea of geekage. Is there a simple way to just export the column of email addresses, convert them into a database separated by columns, fit for my email program?
Thanks in advance.
posted by watercarrier
on Jul 21, 2010 -
Please help settle a bet: Is a spreadsheet a simple type of database, or are they fundamentally different things? [more inside]
posted by perrce
on Apr 2, 2009 -
I need to create a database in Excel, with clickable column headers (clicking on them will sort by that column). More inside, of course. [more inside]
posted by Rubythursday
on Feb 4, 2009 -
Excel-filter: I have a spreadsheet with a list of donations made over the past year. Unfortunately, when an individual has donated multiple times within a year there is a new row for each donation. Fortunately, that individual is assigned the same unique identifier. How do I make it so that each individual has one row with total donations for the year? [more inside]
posted by ewiar
on May 1, 2007 -
Help, business owners! I run a mail order business -- about 3-5 orders a day, with about 15 items in stock. For years I have used an Excel spreadsheet to keep track of orders. Is there a better way?
posted by hodyoaten
on Oct 2, 2006 -
I have an Excel Spreadsheet (using Excel 2003). Rather than creating formulas to answer ad hoc questions that I have, I would like to be able to quickly type in a SQL querty against the data in the spreadsheet. So, I could scroll down to the bottom of the sheet to see how many rows I have, OR I could type" select count(*) from data_table" instead. I prefer the latter. Any suggestions? [more inside]
posted by apark
on Apr 7, 2006 -