Set the default value for reference filed

[sivananda80]

Hi all,

I have felid(u_group_schedule).I need default value(24*5).This filed reference from cmn_schedule table.

Can u help me on that

Thank you

[sivananda80]

Hi Jan,

Thank you reply,

I am using sys_id for default value it's not getting result.

Thank you.

[sivananda80]

Hi Dan,

Thank for reply using the sys_id ,But I am not getting result ,

Thank you.

[Ankur Bawiskar]

Did you copy the correct record sys_id which refers to schedule table?

[sivananda80]

Yes Ankur

[Ankur Bawiskar]

Hi,

it is not recommended to hard-code sys_id

1) create system property of type string and store the sys_id of 24*5 in it

2) then in the default value use this script

javascript: gs.getProperty('schedule_sys_id');

Regards
Ankur