Managing your collections

wottle

Active Tinkerer
Oct 30, 2021
719
469
63
47
Fort Mill, SC
Actually, the addition of an Activity table is inspired by my heavy use of 4th Dimension that enables you to create related tables. I guess it is not possible to add a Detail field to the Activity record with the system you use. No sweat.
Adding a detail field is definitely possible - I'm just using a mySQL database. I was simply commenting on the possible confusion of having notes about the work done on a device spread across two locations: general, dated notes, and maintenance specific notes.

I currently removed the hard coded date field for recapping of the analog, logic, and PSUs, as well as a date field for the floppy drive reconditioning (cleaning and lubrication). I now have a generic system where you can specify a maintenance task (e.g. retrobright, analog recap, etc), a date, and an optional note.

I may create a separate "timeline view" that shows events in chronological order across all the dated items (e.g. acquisition [date, source, price], photos injected into the timeline based on their EXIF date, general notes, and maintenance tasks). It would allow a better way to digest the path to restoration for a device. That may have to wait because I have some other core features I'm working on, as well as getting the backend buttoned up and tested for easy distribution.
 
  • Like
Reactions: rolandszori

rolandszori

New Tinkerer
Mar 17, 2025
9
10
3
Hungary
humanunicorn.hu
Hi,


I'm currently working on the user menu. I've added a variable watcher that allows any changes in the product's data to be tracked on a timeline. (The visual representation isn't implemented yet — it's still just a concept in my head.)
I'm also continuing to build the database — I just needed a small refresh to get back into the flow.
Wishing you a great weekend!

Sorry I have to look at my head so often. :oops:

002.png
001.png