LaborNetwork@[EMAIL PROTECTED]
wrote:
> I have been looking for quite some time for this, and the only solution
> I can find less than $10K is FileMaker Pro. Unfortunately it will
> require me to either spend the next 8 months learning how to create a
> database from scratch, or spend $10K on a developer!
It wouldn't be that difficult. I used an existing, included FileMaker
templates from 7.0 for a non-profit and took about two weeks (an hour
here, an hour there) to tweak the template to track several types of
contacts: donors, prospective donors, volunteers, and the artists
sup****ted by the organization.
For the donors and prospective donors, one table is used with a list
indicating current, prospect, hiatus (but maybe a donor again someday),
and inactive (often moved, closed business, or worse).
Volunteers includes a list of the skills the person has, previous
projects (a one-to-many relation****p), etc. I use the same contacts
database for everyone in the file, but if the person is a volunteer
there is an entry added in the volunteer details table. I like having
all my contact data together because then it migrates to other programs
more nicely.
Artists need a resume, previous works list, gallery dates, and more. We
can match donors to artists by their interests, volunteers to artists by
need, and even volunteers and artists to donors for the purposes of
begging for money.
I used the Task Management template and changed some field names, for a
start, then added some other tweaks. I did not do a major redesign,
since I was volunteering my time.
Now, I'm no FM Pro guru, coming from MySQL and "serious" programming. I
like to code, not click on script steps!
If someone like me can modify the toys in the box, I'm sure you can find
someone to do what you need for a very reasonable rate. I'm also sure
you could, if you spent a few weeks (not months) playing with FM Pro.
The nice thing is that since we modified the existing templates under 7,
we've just added features (mainly re****ts and two or three fields) over
the last two years or so. Example: We make sure any list is a table, not
a text list, and create a nice form for the staff to add new values and
descriptions of the values. When we wanted to add photos of artwork, no
problem -- modify the artist subtable to include a field for photos.
With FM Pro 8.5, we can use tabs to keep things on one screen.
I'm sure anyone here could help with some basic questions. I'm always
picking up tips.
- CSW
|
