Autopopulate the number field from one table to another

pranjalsrvs
Tera Contributor

I have two tables name employee and related list table, now I want to populate number filed from employee table to related list table as number = employee field. 

How can I achieve this, employee table on related list table is a reference field.

pranjalsrvs_0-1744718995929.png

 

pranjalsrvs_1-1744719012875.png

 

1 ACCEPTED SOLUTION

  1. Open your Related List form -> Configure -> Form Layout
  2. Select reference field that you want to dot-walk into(in you case it is Employee):
  3. Click on "Expand selected reference field"
  4. RushiSavarkar_0-1744777344489.png

     

  5. Find field you are looking for (in your case it is Employee > Number) -> move it to "Selected" and if needed adjust placement
  6. RushiSavarkar_1-1744777460151.png
  7. ResultRushiSavarkar_2-1744777542036.png

     

If my response helped you, please accept the solution and mark it as helpful.
Thank You!

View solution in original post

4 REPLIES 4

Rushi Savarkar
Kilo Sage

Hello @pranjalsrvs 

You can dot walk from the Employee Table to Releated List Table by using reference field

If my response helped you, please accept the solution and mark it as helpful.
Thank You!

where do I have to do a dot walk by using reference field, please specify as I am new to learn servicenow

  1. Open your Related List form -> Configure -> Form Layout
  2. Select reference field that you want to dot-walk into(in you case it is Employee):
  3. Click on "Expand selected reference field"
  4. RushiSavarkar_0-1744777344489.png

     

  5. Find field you are looking for (in your case it is Employee > Number) -> move it to "Selected" and if needed adjust placement
  6. RushiSavarkar_1-1744777460151.png
  7. ResultRushiSavarkar_2-1744777542036.png

     

If my response helped you, please accept the solution and mark it as helpful.
Thank You!

Ankur Bawiskar
Tera Patron
Tera Patron

@pranjalsrvs 

if the Related list table has a reference field pointing to Employee then when you are on Employee form and click New from related list then Employee field should get auto populated

This is same how RITM gets auto populated in sc task form when you click New from related list.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader