I’m putting the final touches on the asset management system that I am building, and I’m just a little stuck with one element that I want to incorporate.
What I’m looking to do involves two tables: The Assets table, and the Sign Out Log. On the Assets table, I have a field showing the current status of an asset. When someone fills out the Sign Out Log, the status changes to “Checked Out.” When they complete the Sign In Log, the status changes to “Available.”
I’d like to be able to pull the name of the person who most recently has that asset, IF the checked out column on the Assets table reads as Checked Out.
I’m not sure if I should use a standard formula or some kind of rollup feature. Anyone have any guidance as to how I should proceed?