Database software for OSX?

Phate · 30 Nov 2010 at 23:53

Hi guys,

what I want to do is create a template invoice...

So each time I open a new one it auto numbers it, auto-dates etc...if possible also adds in the client details to the address book etc?

Any ideas guys? Basically I need Access for mac...someone suggested MySQL but god knows how to work that!

Cheers,
Jake

ubersonic · 2 Dec 2010 at 15:02

Why don't you use Access? Office has been available for apple mac's since like 1996

NickK · 2 Dec 2010 at 15:03

ubersonic said:
Why don't you use Access? Office has been available for apple mac's since like 1996

Office mac.. doesn't have access or visio..

NickK · 2 Dec 2010 at 15:09

With Pages you can use merge and use the address book. The same is true for Word - the only thing is 2008 used apple script, 2010+ uses VB script from my understanding.

The fun comes from the auto-creation (ie numbering across documents). You'd need to create a script for this within the document template. You could then create a document using applescript and set the attributes. The document could then reference those document attributes to fill in the fields (ie report number etc).

NickK · 2 Dec 2010 at 15:20

Actually if you go into word, then Insert > Field. Next go to the mail merge and go down to DATABASE it will allow you to reference an external database. The switches allow an ODBC connection and SQL query to be added for the field.

MySQL is ok, although it's a learning experience by itself.

_TubbZ_ · 2 Dec 2010 at 15:47

I do not use macs, but surely OpenOffice Base might be worth a look.

wij · 2 Dec 2010 at 15:53

Filemaker Pro, not too hard to use and is quite well set up for what you want to do.

Johnny|lucidcomposure · 2 Dec 2010 at 17:46

You know im sure the software my boss uses he wrote himself to take orders and do this kinda thing. Problem is hes built him himself I think so obtaining a copy wouldnt be easy!

JonB · 6 Dec 2010 at 11:11

Phate said:
Hi guys,

what I want to do is create a template invoice...

So each time I open a new one it auto numbers it, auto-dates etc...if possible also adds in the client details to the address book etc?

Any ideas guys? Basically I need Access for mac...someone suggested MySQL but god knows how to work that!

Cheers,
Jake

Not database software per se, but you should be able to get Billings to bend to your needs. It appears pretty complicated at first, but it is also very flexible and powerful. You can certainly get it to set up to suit most needs.