populate data from another table fields

VSN · ‎02-09-2023

I have 2 tables,

1. program , it contains portfolio and sub-portfolio

2. Change request, it contains portfolio and sub-portfolio,

common number between teo tables is project number field

here , i need to get value from porject portfolio to change request portfolio.

i have written script include and client script , but it was displaying the after form got saved, but i need to display the portfolio and sub-portfolio values for new form.

script include:

Client script:

Anurag Tripathi · ‎02-09-2023

Hi,

You need to change your client script from onload to onchange, and make it run onchange of u_program_name field.

-Anurag

View solution in original post

VSN · ‎02-09-2023

U_program_name is a reference field(parent number). It always contain default value. If we create new record it contain value

ricker · ‎02-09-2023

@VSN,

What is the problem you're trying to solve? Don't forget all the information on the referenced record is only a click away and you can add a dot walked field to the form displaying the information from a referenced record without any scripting.

VSN · ‎02-09-2023

I was tried through dot walking process, but their is some label different. After dit walking it showing as portfolio name. But my requirement is portfolio.