Chris, could you email be a blank copy too?
It will give me an idea of what fields I may need to add to my existing database.
Thanks!
Puzzle Cataloguing
Re: Puzzle Cataloguing
Hi Guys,
Having used Handbase on the iPad for a while and gotten a bit fed up with its restrictions I then tried Tapforms at the suggestion of Nigel. Whilst this is not bad, it is not a truly relational database and so ends up very wasteful of storage space and will become very slow with large databases (plus the obsessive coder from the 1980s in me dislikes wasteful storage!)
I decided to create a better desktop database which can be ported to iOS device. I have used FileMaker Pro on the Mac and so far have created a basic database and views (not done any iOS views yet) - here are 3 of the basic views. It is fully scripted and I have a basic dashboard screen too.
Basic list view (limited to certain fields):

Puzzle view:

Large photo view:

If anyone has any suggestions for fields to be added or altered, any layout suggestions, searches that you think need to be programmed into a simple button then suggestions would be gratefully received.
If you have FMP and want a copy of the database to play with then let me know. If you don't have FMP but do have a Mac then I can create a standalone executable for you to add your own data to then I would be happy to do this - again, let me know (although it might be better if you wait for iOS views to be done first). Unfortunately the Mac version cannot create Windows executables.
I really hope you can all chip in with ideas!
Having used Handbase on the iPad for a while and gotten a bit fed up with its restrictions I then tried Tapforms at the suggestion of Nigel. Whilst this is not bad, it is not a truly relational database and so ends up very wasteful of storage space and will become very slow with large databases (plus the obsessive coder from the 1980s in me dislikes wasteful storage!)
I decided to create a better desktop database which can be ported to iOS device. I have used FileMaker Pro on the Mac and so far have created a basic database and views (not done any iOS views yet) - here are 3 of the basic views. It is fully scripted and I have a basic dashboard screen too.
Basic list view (limited to certain fields):

Puzzle view:

Large photo view:

If anyone has any suggestions for fields to be added or altered, any layout suggestions, searches that you think need to be programmed into a simple button then suggestions would be gratefully received.
If you have FMP and want a copy of the database to play with then let me know. If you don't have FMP but do have a Mac then I can create a standalone executable for you to add your own data to then I would be happy to do this - again, let me know (although it might be better if you wait for iOS views to be done first). Unfortunately the Mac version cannot create Windows executables.
I really hope you can all chip in with ideas!
Kev1n
Completely addicted to puzzles
Visit my blog it's at: www.puzzlemad.co.uk
Blue Ex BU01113 - open
Green Ex GR00494 - open
Bronze Ex BR00188 - open
Silver Ex AG00168 - open
Orange Ex OR00021 - open
Gold Ex AU00070 - open
Completely addicted to puzzles
Visit my blog it's at: www.puzzlemad.co.uk
Blue Ex BU01113 - open
Green Ex GR00494 - open
Bronze Ex BR00188 - open
Silver Ex AG00168 - open
Orange Ex OR00021 - open
Gold Ex AU00070 - open
- 03SVTCobra
- Posts: 1531
- Joined: Wed Jun 09, 2010 11:46 pm
- Location: NY
Re: Puzzle Cataloguing
Kevin that is pretty sweet. Im on a mac and could use something like that but don't have FMP anymore. I was just going to make it in excel!
BU00060
GR00060
BR00060
AG00060
AU00060 
R00060
OR00060
LM00060
TI00030
CU00060
AQ00060
IN00060
MT00060
TQ00060
GM
HM 
Blue Obs
Green Obs
Black Obs
Black Obs V2
Red Obs 





R00060







MT00060




Blue Obs




