I reference this great tutorial all the time on how to create a history log. My trouble is that instead of using Cost as a factor to track, I want to track Borrowers. Then to keep the data clean, I want to use a select list from a table of Borrowers.
AKA when someone goes in to update who has something checked out, they won’t have to write in their name. They can use a select list.
However, that doesn’t seem possible since there’s a formula going on. Would a better practice be to create a Visible!Borrower column with the select list then a Hidden!Borrower column which pulls in the info from the Visible column?