How to assign a default value for a reference field

[mark141230]

Hi Everyone,

I have a requirement, I need to assign a default display value to my Project Time Category  which is a reference field in a Time Card Table.

In the Project Time Category Table i have the following entries:

 - Standard

 - Non-OT Billable

- OT Billable

- Offset

What I want is, once the user open the form, it will automatically display the "Standard" in the Project Time Category field in the Time Card Forms.

Thanks in advance.

[Community Alums · Accepted solution]

Add the sys_id of the "Standard" choice from 'project_time_category' table as the Default value of the field 'project_time_category' in the Time Card table

Example for 'Development' choice from my PDI:

When user creates a new Time Card-

[mark141230]

Hi shruthiub,

Thanks for this it works. 🙂

[Community Alums]

Hi, Glad to know that. Can you mark my answer as correct/helpful and close the thread! Thank you! 🙂

[Jaspal Singh]

Hi Mark,

Right click the 'Project Time Category' field & pass the default value 'Standard'. No need to pass 

'sys_id' as display value is Name for project time category table.