Set the Default value of Reference variable with the first value of the list

[Sarah Austria]

I have a reference field "Assignment Group" from the sys_user_grmember table. I have filter this from reference qual with javascript: 'user=' + current.variables.requested_by;

However, I need to set the default value with the first value available from the list? How to do this? 

Can this be possible from the Default value field? Or do I need to write client script? If via client script? How? thanks.

[Ankur Bawiskar]

Hi,

In that case as already mentioned you need to use GlideAjax and Script Include

Note: Ensure you use setLimit(1) and use orderBy('name') in your query with name column

refer link below for GlideAjax example

Client script glideajax

Regards
Ankur