Hi Everyone,
I hope you are all doing well.
I am currently working on a catalog form that includes several variables: Name (referencing the User table), Department, Work Location, Telephone, and Email. When the value in the Name variable changes, the other variables are automatically populated if corresponding values exist for the user in the Name field. If not, users can manually enter values for the Department, Work Location, Telephone, and Email fields.
We also have a MRVS (Multiple Row Variable Set) with the same variables.
Additionally, there is a checkbox variable on the form labeled "Self." When this checkbox is selected, the values from the Name, Department, Work Location, Telephone, and Email fields should be copied to the variables in the MRVS. If the checkbox is deselected, the corresponding row (populated when the checkbox was selected) should be deleted. This functionality should trigger upon changes to both the Name and Self variables.
Thank you.
