On Redwood Page, How to restrict display of LOV of Assignment Category based on chosen Person Type

Summary:

While hiring an employee through the Redwood experience, I am trying to configure the conditional display of Worker Category based on the selected Person Type.

Requirement:

• If Person Type = "Employee", the Worker Category dropdown should display:
  • Permanent
  • Fixed Term
  • Max Term Contract
  • Casual
  • Graduate - Term
  • Intern - Term
  • Secondee
  • Non-Executive Director
• If Person Type = "Contractor" or "Franchisee", the Worker Category should show different values (or possibly be hidden if not applicable).

Issue:

I attempted to configure this behavior using Visual Builder, but I was unable to achieve the desired conditional logic on the Redwood page.

Could anyone guide me on how this can be implemented ? Any help or reference documentation would be greatly appreciated.