Different tables in reference field based on variable selection

[Sunil31]

Hello Team,

I have a reference field with table as TASK. I have another variable on form which gives option to select the table name for the user (incident, service request, problem).

Whenever user select table name, only those record should be visible in reference field variable, can we achieve this. 

Please let me know the approach.

Thank you

[Sunil31]

@Tai Vu , This works like charms... cheers.. thank you... 
To add it further, can we set a filter like

Active = true and assigned to dynamic me??

If this can be done then its cherry on top.

Thank you

[Tai Vu · Accepted solution]

Hi @Sunil31 

Why not? there you go!

javascript: current.u_task_type ? 'active=true^assigned_toDYNAMIC90d1921e5f510100a9ad2572f2b477fe^sys_class_name=' + current.u_task_type : 'sys_class_name=-1'; 

Cheers,

Tai Vu

[Sunil31]

You were saviour.. thank you.. 

[Priyanshi Singh]

Hi @Tai Vu,
I have a similar requirement. I have two custom tables, and both are completely different (they don’t share the same parent table).
Is it possible to achieve this so that, based on the selection of a variable dropdown, a reference field dynamically points to the appropriate table?