Client Script - Multi-Tier reference

ChadLee4
Tera Contributor

‎07-26-2023 08:17 AM

I have a Questionnaire form. I am attempting to create a client script to auto-populate the "email" field on this form based on the associated user's sys_user "email" info. Normally this would be a straight-forward reference to the sys_user table, but in this unique case the form has an employee field that is a reference to a custom "x_employee" table which contains additional info about the user. And then that "x_employee" table/record has a reference field to the "sys_user" table.

 

Is there a way to do a reference of a reference field to capture the email field value within the sys_user table?

 

---------------------------------------------

Relevant Questionnaire Form Fields:

  Reference: x_employee

 

Relevant x_employee fields

  Reference: sys_user

 

Relevant sys_user fields:

  email

 

0 Helpfuls
  • 179 Views
1 REPLY 1

Harshal Aditya
Mega Sage
Mega Sage

‎07-26-2023 08:28 AM

Hi @ChadLee4 ,

 

Hope you are doing well.

 

I would suggest you to use glideAjax as getReference is not a best practice and also it only supports one level dot walking. I guess getReference will not work in this case.

 

Please mark this response as correct or helpful if it assisted you with your question.

Regards,
Harshal