Record Producer is Lookup field of other table- Short Description can we fetch from that field?

[Bhavani3]

In Custom table, have a field name -Record producer and that field type is Lookup(type=List).Is it possible fetch the Short description value from that Record Producer Field?

[Ankur Bawiskar]

@Bhavani3 

so on a table you have list type of field and it refers to Record producer table.

When do you wish to fetch the short description and in which script?

If in client side -> you need to use GlideAjax, query and get the value

If in server side -> you need to use GlideRecord and then query and get the value

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

[Bhavani3]

Hi @Ankur Bawiskar 

In portal, in custom widget i created 2 fields one is Record producer(choice field) and other one short description field, so if i select any record producer then in short description field auto populate the short description of Record producer table.

currently in widget custom filed record producer ,in backend that is referencing from other table and that Record producer field is Lookup field means type is List, what the logic scripting for this?

[Ankur Bawiskar]

@Bhavani3 

you can use onChange event and populate that

what did you start with?