Need to populate employee name based on employee type

[CDJ]

Hello all,

I have a requirement to populate the employee name [ reference field ] based on employee hire type [ selectbox].

Hiretype option - Employee , Contractor

On user table , there is a checkbox [Contractor] if user selects employee only employee name should appear or else the contractor employee names.

Need suggestions on this .Thanks in advance!

[Joe Wong]

It sounds like you need a Business Rule to do what you are looking for.

To clarify, you have a custom table that is referencing the [sys_user] table?  Or when you mention "to populate the employee name" you are referring to populating (changing) the employee name in the [sys_user] table?

[CDJ]

Hi @Joe Wong ,

Yes, Employee names [ sys_user ] table and its a reference field.

To make it clear, If user selects "Hire type"[Select box] field as contractor only contractor employee name should be available in Employee names[Reference] field .