How to autopopulate a field value based on same field value present on a different table ?

[1_DipikaD]

Hi All,

I want to  auto populate a field value based on same field value present on a different table. As shown in the below picture P records are lnked to t record . We create  records clicking on NEW button on related list of  record . I want to auto populate the field value of  name field on  record at the time while clicking on New button. I  can't find any UI action exists for this . But when I click on ' i ' button besides the name (Reference field) field on   form , it redirects to that record . Could you please suggest how to approach this ? Please let me know if you need more info .  

Thank You

[Ankur Bawiskar]

@1_DipikaD 

yes 1 table can have only 1 field marked as Display=true

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

[MPD Odijk]

Theer are several options for you, for instance

- create a custom "new" button (List Banner Button, make sure the action name starts with sysverb). In that button (server side) you have access to the "parent" object, which is a glide record representing the record that the list is visible on.

- create an onBefore Business Rule that populates the data just before the record on the related table is inserted 

(I'm sure there are more options, such as a client side UI Action that uses an encoded query to populate the data on the new record)