How to set location field from previous record of user.
I had a set field script that copied the location of a box of books on the previous record onto the current record. This made it easier so I would have less to enter. When I started a box I would go and put in the location manually and then use the set field script for the rest of the books.
But now there will be more than one user adding books to the inventory from different box locations (on a hosted database).So now I want the script to copy the location from the last record edited by that user. I know I need to
insert Current User Name
go to record/request/ppage
What calculation would get me to the previous record made by that user?