Populate a List field depending the value of an reference field

[Lavanya Nagendr]

Hi All,

We have a field 'Supplier Name' which refers to 'Company(core_company)' table. We have another field 'Business Contact' which refers to 'User' table.

When a value is selected on the supplier name field, we need the business contact field to hold only the users which are 'Business Owners' of the Supplier we selected on the supplier name field.

This is the fields on the Supplier table,

 This is the field on the suppler record in the company table

Kindly provide a solution for this requirement.

Thanks!

[Chaitanya ILCR]

Hi @Lavanya Nagendr ,

you can add reference qualifier on Business contact field

javascript&colon;'sys_idIN'+current.<supplierName backend Name>.<Business Owner field Backed name>

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[GopikaP · Accepted solution]

Hi @Lavanya Nagendr , you can write an advance reference qualifier for 'Business Contact' field like this - 

javascript:'sys_idIN'+current.u_supplier_name.u_business_owner;

Kindly modify the field name as you process it.

[Veer]

@lavanyaNagendra

Open the dictionary of business contact field and under reference qualifier select advanced reference qualifier and write the advanced reference qualifier as below

javascript:"sys_idIN"+ current.u_supplier_name.u_business_owner.toString()

Please mark this as helpful/ accepted solution if it resolves your query.


Thanks & Regards
Veer

[Sourabh Tarlekr]

Hi @Lavanya Nagendr 

1. Open Dictionary of that table and select u_business_contact field (Advanced View)
2. On Reference Specification tab select User Table
3. Add Reference qualification as javascript:'company='+current.u_suppplier_name

Attached screenshots for your reference. Kindly let me know if this solution works for you.

Regards,

Sourabh