FM beginner (sort of). 20 yrs ago without any computer experience, I created a FM database that has served me well. 20 years later I need to add a feature and don't know how to approach the problem. I'm excited to have found this site and look forward to learning from you all. The database has 1000…

This is a requirement of several of my data management solutions. One example is a scientific laboratory setting, where specimens are checked-out, assigned to analysts, transferred to different departments, etc.; another is an inventory management system which includes item sales as well as consignm…

[image] Lovezinnias: I need to keep an ongoing record of the location changes for each object and determine the duration that the object is in each location. <but> making a new record for each object each time the object moved seems cumbersome. :person_shrugging: Making a new record is the…

[image] Lovezinnias: I haven't even considered how to set up for the duration at each location. Any ideas? I didn't address this, but @Malcolm offered a method. If you need daily (or other periodic) duration status updates, one can script any of many options such as a report showing all items…

Thank you Malcolm, thank you Daleallyn. Even a quick reading of your suggestions is helpful, bringing to mind further questions. But not today -- I'm out with pneumonia but wanted to acknowledge your generous responses to my query. I look forward to revisiting when I'm better.

[image] Lovezinnias: I'm out with pneumonia Wish you get well soon.

I hope you feel better soon, @Lovezinnias .

Thanks again, your ideas were very helpful. As suggested, created a Location History Table. Location changes are imported from an excel doc (outside source) into an objects record including a time stamp. Then a new record is created in the LHT whenever an object is moved; a LH portal lists the histo…

Check the Claris resources page. They produce training materials.

How to retain an objects history of movement and date of movement

Questions

Topic		Replies	Views
Portal: how to simultaneously make row changes AND keep track of all recorded rows (history)? Questions	15	463	March 7, 2023
How can I search a portal and only find records in the first or last row?	12	249	May 12, 2025
How to archive checkboxes (& their values) and replace them? Questions community , filemaker	32	348	March 5, 2025
Mass change of field source in layouts Questions layout	36	1236	March 8, 2022
Scripting creation of a record in an un-related table Questions scripting	5	461	October 11, 2021

How to retain an objects history of movement and date of movement

Related topics