How to set default value for a reference field on Catalog form

[rambabu1]

Hi,

i have a field on form it's reference field and i need to set default value for that field.

below is the script that i written in default value. but it's not working

[Ankur Bawiskar]

Hi,

you are querying u_account with hard-coded sysId and again setting the same record sysId as default value

Why to have this?

Reference field is referring to which table -> u_account? if yes then directly give the sysId of the record

Regards
Ankur

[rambabu1]

Hi Anukar, 

yes the reference table related to u_account table. and i am giving directly sys_id also not working

[Ankur Bawiskar]

Hi,

are you sure that sys_id belongs to the same table which is being referred by that field i.e. u_account

Did you try to search on that table u_account.LIST and search with sysId = your sysId

Regards
Ankur

[rambabu1]

yes ankur. i am giving like below still unable to get default value