How to make a dependent field based on user assigned to record

Question

Is there any way to make a field in a module dependent on whether a specific user is assigned to the record? E.g. if 'John Smith' is assigned to the record then text field 'ABC' appears.

Paul Deakin · Accepted Answer

Hi Paul Deakin , Below is the formula that I used to achieve this. equal(related($assigned_user_link,"user_name"),"chris") In my instance I used Chris as my test User. Although you do not see an option for User Name when selecting the related field in formula builder, I simply chose the First Name option and then changed it manually in the formula from "first_name" to "user_name". The two images below show this working, with the field that becomes visible being called "Test" and on the bottom row of fields to the right of the "Test User" image (please ignore the funny field names, this is my test system). Image 1 - Account Assigned To Jen Image 2 - Account Assigned To Chris