I’m working with three tables: Use Profiles, Sites, and Reports.
- Sites is a parent to Reports
- User Profiles is a parent to Sites
The User Profiles table has a Quick Base username field that I use as the reference proxy in the User Profiles to Sites relationship.
I’ve created a lookup field, Sites – Related User ID , in the Reports table that pulls the Related User ID from the Job Sites table lookup field Related User.
What I’d like to happen is that a user can be on a Report record, and click a button to open their profile in the Users Profile table in edit and additionally mark a checkbox field as true.I messed around with trying to utilize the Sites – Related User ID at the end of a URL in a formula URL field but couldn’t get it right.