Use a field of type "Formula - URL (Link)". Set the cover text to "Click Here.." and then use a formula to point to a report that selects for only one record based on the Record ID# field which is unique for every record.
The URL for a report using the API is for example:
Instead of using Lastname: to search, use Email:, as some users do not have the Last Name and First Name values set for their user profile. Using Email: A-F returns the most inclusive list and will sum to the same number as presented in your account usage stats section.
QuickBase relies on email addresses to identify user accounts. When QuickBase user accounts are created, they are initiated and confirmed via an email address. Sometimes a user may inadvertently create two or more accounts, each having a different email address. This can easily occur when users change companies and email addresses.